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 GetAllDepartmentJSON(string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
//Get current user info
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
//Security Check For AllDepartment
string departmentID = "";
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "allDepartment"))
{
departmentID = current_user.DepartmentID;
}
//Add into Query Statment
var Query = (from c in dc.Mst_DepartmentViews
where c.Active == true && (departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID))
orderby c.DepartmentName
select new Mst_DepartmentView
{
DepartmentID = c.DepartmentID,
DepartmentName = c.DepartmentName,
NotifyEmail = c.NotifyEmail,
Protocol = c.Protocol,
Description = c.Description,
Remark = c.Remark,
}).ToList();
string return_str = new JavaScriptSerializer().Serialize(Query);
return(return_str);
}
public static List <Object> getAllAttachment(string record_type, string record_id)
{
List <Object> result = new List <object>();
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
List <Attachment> return_attachment = new List <Attachment>();
List <Mst_Image> Query = (from c in dc.Mst_Images
where c.Active == true &&
c.RefID == record_id && c.RefType == record_type
orderby c.CreatedOn
select c).ToList();
foreach (Mst_Image c in Query)
{
Attachment ot = new Attachment()
{
ID = c.ImageID,
Path = c.ImageURL,
ImageName = c.ImageName
};
return_attachment.Add(ot);
}
result.AddRange(return_attachment);
return(result);
}
public static string GetAllPositionJSON(string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
//Get current user info
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
//Add into Query Statment
var Query = (from c in dc.Mst_PositionViews
where c.Active == true
orderby c.PositionName
select new Mst_PositionView
{
PositionID = c.PositionID,
PositionName = c.PositionName,
PositionCode = c.PositionCode,
Protocol = c.Protocol,
Description = c.Description,
Remark = c.Remark,
}).ToList();
string return_str = new JavaScriptSerializer().Serialize(Query);
return(return_str);
}
public static string DeleteImages(string RefID, string RefType, string RequestID)
{
//List<Object> result = new List<object>();
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
try
{
List <Mst_Image> the_record = (from c in dc.Mst_Images
where c.Active == true &&
c.RefID == RefID && c.RefType == RefType
select c).ToList();
Mst_Image delete_image = new Mst_Image();
if (the_record == null)
{
return("Error~We can't find");
}
for (int i = 0; i < the_record.Count; i++)
{
the_record[i].Active = false;
the_record[i].ModifiedOn = DateTime.Now;
the_record[i].ModifiedBy = RequestID;
the_record[i].LastAction = Guid.NewGuid().ToString();
try { File.Delete(the_record[i].ImagePath); }
catch (Exception ex)
{
}
}
dc.SubmitChanges();
return("Success~");
}
catch (ChangeConflictException ex)
{
return("Success~");
}
}
public static string DeleteImageWithImageURL(string imageURL, string RequestID)
{
//List<Object> result = new List<object>();
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
imageURL = imageURL.Replace("https://", "");
try
{
Mst_Image the_record = (from c in dc.Mst_Images
where c.Active == true &&
c.ImageURL == imageURL
select c).FirstOrDefault();
if (the_record == null)
{
return("Error~We can't find");
}
the_record.Active = false;
the_record.ModifiedOn = DateTime.Now;
the_record.ModifiedBy = RequestID;
the_record.LastAction = Guid.NewGuid().ToString();
dc.SubmitChanges(ConflictMode.ContinueOnConflict);
File.Delete(the_record.ImagePath);
return("Success~");
}
catch (ChangeConflictException ex)
{
return("Success~");
}
}
public static Mst_DepartmentView GetDepartment(string dep_id, string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
return((from c in dc.Mst_DepartmentViews where c.DepartmentID == dep_id && c.Active == true select c).FirstOrDefault());
}
public static List <Mst_Image> GetImage(string refID, string RequestID)
{
//List<Object> result = new List<object>();
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
List <Mst_Image> return_images = (from c in dc.Mst_Images
where c.Active == true &&
c.RefID == refID && c.ImageName.Contains(refID)
orderby c.CreatedOn
select c).ToList();
return(return_images);
}
public static List <Mst_PositionView> GetAllPosition(string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
return((from c in dc.Mst_PositionViews
where c.Active == true
orderby c.PositionName
select c).ToList());
}
public static Mst_Image GetImageSMTHLogo(string refID, string RequestID)
{
Mst_Image the_record = new Mst_Image();
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
var return_images = (from c in dc.Mst_Images
where c.Active == true &&
c.RefID == refID && c.RefType == "Logo"
orderby c.CreatedOn
select c).ToList().LastOrDefault();
if (return_images != null)
{
the_record = return_images;
}
return(the_record);
}
public static List <Mst_DepartmentView> GetAllDepartment(string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
//Security Check For AllDepartment
string departmentID = "";
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "allDepartment"))
{
departmentID = current_user.DepartmentID;
}
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
return((from c in dc.Mst_DepartmentViews
where c.Active == true && (departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID))
orderby c.DepartmentName descending
select c).ToList());
}
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);
}
}
public static string SaveImage(string ImageURL, string ImagePath, string ImageName, string RefID, string RefType, string UserID)
{
try
{
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
Mst_Image the_record = new Mst_Image();
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, UserID, "create"))
{
throw new Exception("No Access.");
}
string delete_result = "";
switch (RefType)
{
case "user":
delete_result = DeleteImages(RefID, RefType, UserID);
break;
case "department":
delete_result = DeleteImages(RefID, RefType, UserID);
break;
default:
delete_result = "Success~";
break;
}
if (delete_result == "Success~")
{
the_record = new Mst_Image()
{
CreatedBy = UserID,
CreatedOn = DateTime.Now,
Active = true,
ImageID = Guid.NewGuid().ToString(),
ModifiedBy = UserID,
ModifiedOn = DateTime.Now,
LastAction = Guid.NewGuid().ToString(),
ImageName = ImageName,
ImageURL = ImageURL,
ImagePath = ImagePath,
RefID = RefID,
RefType = RefType,
};
dc.Mst_Images.InsertOnSubmit(the_record);
dc.SubmitChanges();
if (RefType == "Logo")
{
the_record.ImageData = ImageToBinary(ImagePath);
}
dc.SubmitChanges();
return("Success~");
}
else
{
return("Error~" + delete_result);
}
}
catch (Exception ex)
{
return("Error~" + ex.Message);
}
}
