public static ResultEN Insert_Equipment_SET(ref Equipment_SET en)
{
ResultEN res = new ResultEN();
// int? _Id = GetID("Equipment_SET", "SET_ID");
List <ClassFieldValue> fields = new List <ClassFieldValue>();
//en.SET_ID = _Id.Value;
fields = SetField_SET(fields, en);
res = ClassMain.Insert("Equipment_SET", fields, "SET_ID");
return(res);
}
private void Save()
{
Equipment_SET Equipment_SETone = new Equipment_SET();
List <Equipment_SET_detail> lstEquipment_SET_detail = null;
//GridView grid_Detail = grid_Detail;
if (this.grid_Detail != null && this.grid_Detail.Rows.Count > 0)
{
lstEquipment_SET_detail = new List <Equipment_SET_detail>();
foreach (GridViewRow item in grid_Detail.Rows)
{
Equipment_SET_detail en = new Equipment_SET_detail();
en.Equip_ID = Convert.ToInt32(item.Cells[Enum_grid_Detail.ID.GetHashCode()].Text); //ID
en.cost = Convert.ToDecimal(item.Cells[Enum_grid_Detail.CostRent.GetHashCode()].Text); //CostRent
lstEquipment_SET_detail.Add(en);
}
}
if (VSEnum_Mode == Enum_Mode.Add)
{
Equipment_SETone.Price = Convert.ToDecimal(this.txtPrice.Text);
Equipment_SETone.SETName = this.txtSetName.Text;
Equipment_SETone.Description = this.txtDescription.Text;
}
else if (VSEnum_Mode == Enum_Mode.Edit)
{
//Equipment_SET[] Equipment_SETs = null;
//ClassSet.GetDate_Equipment_SET(out Equipment_SETs, VSSet_Id);
lstEquipment_SET_detail.ToList().ForEach(x => x.SET_ID = VSSet_Id.Value);
//SSEquipments
}
else if (VSEnum_Mode == Enum_Mode.Delete)
{
}
//Call Save
int?SET_ID = ClassSet.SetData_Equipment(Equipment_SETone, lstEquipment_SET_detail, VSEnum_Mode.GetHashCode());
if (SET_ID != null)
{
initial(SET_ID);
string message = "บันทึกเรียบร้อยแล้ว";
MessageShow(message);
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "ToggleScript", "Alert(" + message + ")", true);
}
}
public static int?SetData_Equipment(Equipment_SET Equipment_SETone, List <Equipment_SET_detail> lstEquipment_SET_detail, int Mode)
{
int? SET_ID = null;
bool result = false;
ResultEN ResultENs = new ResultEN();
if (Equipment_SETone != null)
{
if (Mode == 1)//insert
{
ResultENs = Insert_Equipment_SET(ref Equipment_SETone);
SET_ID = ResultENs != null && ResultENs.result ? Convert.ToInt32(ResultENs.returnValue) : (int?)null;
}
else if (Mode == 2)//update
{
var _SET_ID = lstEquipment_SET_detail.Select(x => (int?)x.SET_ID).Distinct().ToArray();
ResultENs = Delete_Equipment_SET_detail(_SET_ID);
if (ResultENs.result == true)
{
SET_ID = _SET_ID.FirstOrDefault();
ResultENs.returnValue = _SET_ID.FirstOrDefault();
}
}
else if (Mode == 3)//delete
{
}
else
{
//break;
}
}
if (ResultENs != null && ResultENs.result == true)
{
if (lstEquipment_SET_detail != null && lstEquipment_SET_detail.Any())
{
lstEquipment_SET_detail.ForEach(x => x.SET_ID = Convert.ToInt32(ResultENs.returnValue));
foreach (var item in lstEquipment_SET_detail)
{
ResultENs = Insert_Equipment_SET_detail(item);
if (ResultENs.result == false)
{
result = false;
}
else
{
result = true;
}
}
}
}
if (result)
{
SET_ID = ResultENs != null && ResultENs.result ? SET_ID : (int?)null;
}
return(SET_ID);
}
private static List <ClassFieldValue> SetField_SET(List <ClassFieldValue> fields, Equipment_SET en)
{
//fields.Add(new ClassFieldValue("SET_ID", en.SET_ID));
fields.Add(new ClassFieldValue("SETName", en.SETName));
fields.Add(new ClassFieldValue("Price", en.Price));
fields.Add(new ClassFieldValue("Description", en.Description));
return(fields);
}
