m * h * d
پنج شنبه 28 اردیبهشت 1391, 22:06 عصر
void Insert_Facilities(object ID)
{
TestDataContext Test = new TestDataContext();
Hotel_Facility hotel_Facilities = new Hotel_Facility();
for (int i = 0; i <= CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items[i].Selected)
{
hotel_Facilities.Facilities_ID = Int64.Parse(CheckBoxList1.SelectedValue.ToString() );
hotel_Facilities.Hotel_ID = Int64.Parse(ID.ToString());
Test.Hotel_Facilities.InsertOnSubmit(hotel_Facilit ies);
Test.SubmitChanges();
return;
}
}
}
void Update_Facilities(object ID)
{
TestDataContext Test = new TestDataContext();
Hotel_Facility hotel_Facilities = new Hotel_Facility();
var Q = (from Resualt in Test.Hotel_Facilities where Resualt.Hotel_ID == Int64.Parse(ID.ToString()) select Resualt).SingleOrDefault();
Test.Hotel_Facilities.DeleteOnSubmit(Q);
Test.SubmitChanges();
for (int i = 0; i <= CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items[i].Selected)
{
hotel_Facilities.Facilities_ID = Int64.Parse(CheckBoxList1.SelectedValue.ToString() );
hotel_Facilities.Hotel_ID = Int64.Parse(ID.ToString());
Test.Hotel_Facilities.InsertOnSubmit(hotel_Facilit ies);
Test.SubmitChanges();
}
}
}
void Manage_Insert_HotelFacilities(object Id)
{
TestDataContext Test = new TestDataContext();
var Select = (from Resualt in Test.Hotel_Facilities where Resualt.Hotel_ID == Int64.Parse(Id.ToString()) select Resualt).SingleOrDefault();
if (Select != null)
{
Update_Facilities(Id);
return;
}
else
{
Insert_Facilities(Id);
return;
}
}
{
TestDataContext Test = new TestDataContext();
Hotel_Facility hotel_Facilities = new Hotel_Facility();
for (int i = 0; i <= CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items[i].Selected)
{
hotel_Facilities.Facilities_ID = Int64.Parse(CheckBoxList1.SelectedValue.ToString() );
hotel_Facilities.Hotel_ID = Int64.Parse(ID.ToString());
Test.Hotel_Facilities.InsertOnSubmit(hotel_Facilit ies);
Test.SubmitChanges();
return;
}
}
}
void Update_Facilities(object ID)
{
TestDataContext Test = new TestDataContext();
Hotel_Facility hotel_Facilities = new Hotel_Facility();
var Q = (from Resualt in Test.Hotel_Facilities where Resualt.Hotel_ID == Int64.Parse(ID.ToString()) select Resualt).SingleOrDefault();
Test.Hotel_Facilities.DeleteOnSubmit(Q);
Test.SubmitChanges();
for (int i = 0; i <= CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items[i].Selected)
{
hotel_Facilities.Facilities_ID = Int64.Parse(CheckBoxList1.SelectedValue.ToString() );
hotel_Facilities.Hotel_ID = Int64.Parse(ID.ToString());
Test.Hotel_Facilities.InsertOnSubmit(hotel_Facilit ies);
Test.SubmitChanges();
}
}
}
void Manage_Insert_HotelFacilities(object Id)
{
TestDataContext Test = new TestDataContext();
var Select = (from Resualt in Test.Hotel_Facilities where Resualt.Hotel_ID == Int64.Parse(Id.ToString()) select Resualt).SingleOrDefault();
if (Select != null)
{
Update_Facilities(Id);
return;
}
else
{
Insert_Facilities(Id);
return;
}
}