public static string DeleteDepartment(string dep_id, string user_id, string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "delete"))
{
throw new Exception("No Access.");
}
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
try
{
Mst_Department dep = new Mst_Department();
dep = (from c in dc.Mst_Departments where c.DepartmentID == dep_id && c.Active == true select c).FirstOrDefault();
if (dep == null)
{
return("Error~We can't find");
}
dep.Active = false;
dep.ModifiedOn = DateTime.Now;
dep.ModifiedBy = user_id;
dep.LastAction = Guid.NewGuid().ToString();
dc.SubmitChanges(ConflictMode.ContinueOnConflict);
return("Success~");
}
catch (ChangeConflictException ex)
{
return("Success~");
}
}
public static string SaveDepartment(string dep_id, string user_id, string department_name, string notifyemail, string protocol, string description, string remark, string RequestID)
{
try
{
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
Mst_Department the_record = new Mst_Department();
if (dep_id == "" || dep_id == null)
{
the_record = (from c in dc.Mst_Departments where c.DepartmentName == department_name && c.Active == true && ((dep_id == "") || (dep_id != "" && c.DepartmentID != dep_id)) select c).FirstOrDefault();
if (the_record == null)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "create"))
{
throw new Exception("No Access.");
}
the_record = new Mst_Department()
{
CreatedBy = user_id,
CreatedOn = DateTime.Now,
Active = true,
DepartmentID = Guid.NewGuid().ToString(),
LastAction = Guid.NewGuid().ToString()
};
dc.Mst_Departments.InsertOnSubmit(the_record);
dep_id = the_record.DepartmentID;
}
else
{
return("Error~Duplicate Department Name");
}
}
else
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "update"))
{
throw new Exception("No Access.");
}
the_record = (from c in dc.Mst_Departments where c.DepartmentID == dep_id select c).FirstOrDefault();
if (the_record == null)
{
throw new Exception("System cannot find the record");
}
}
the_record.ModifiedBy = user_id;
the_record.ModifiedOn = DateTime.Now;
the_record.LastAction = Guid.NewGuid().ToString();
the_record.DepartmentName = department_name;
the_record.NotifyEmail = notifyemail;
the_record.Protocol = string.IsNullOrEmpty(protocol) ? 0:Convert.ToDecimal(protocol);
the_record.Description = string.IsNullOrEmpty(description) ? "" : description.Replace("%27", "");
the_record.Remark = string.IsNullOrEmpty(remark) ? "" : remark.Replace("%27", "");
dc.SubmitChanges();
return("Success~" + the_record.DepartmentID);
}
catch (Exception ex)
{
return("Error~" + ex.Message);
}
}