public static string SaveOrganization(string org_id, string user_id, string org_name, string org_code, string orgType,
string joint_date, string expiry_date, string InvoiceAccountName, string InvoiceAccountNo, string user_count, string orgplan,
string Website, string Facebook, string Email, string PhoneNo, string Address, string InvoiceType,
string remark, string remark1, string RequestID)
{
try
{
LINQ_SystemDataContext dc = new LINQ_SystemDataContext();
DateTime Joint_Date = DateTime.Today;
DateTime.TryParseExact(joint_date, "yyyy/MM/dd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out Joint_Date);
DateTime Expiry_Date = DateTime.Today;
DateTime.TryParseExact(expiry_date, "yyyy/MM/dd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out Expiry_Date);
SYS_Organization the_record = new SYS_Organization();
if (org_id == "" || org_id == null)
{
the_record = (from c in dc.SYS_Organizations where c.OrgID == org_id && c.Active == true 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 SYS_Organization()
{
CreatedBy = user_id,
CreatedOn = DateTime.Now,
Active = true,
OrgID = Guid.NewGuid().ToString(),
LastAction = Guid.NewGuid().ToString()
};
dc.SYS_Organizations.InsertOnSubmit(the_record);
}
else
{
return("Error~Duplicate Organization Name");
}
}
else
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "update"))
{
throw new Exception("No Access.");
}
the_record = (from c in dc.SYS_Organizations where c.OrgID == org_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.OrgType = orgType;
the_record.OrgName = org_name;
the_record.OrgCode = org_code;
the_record.JointDate = Joint_Date;
the_record.ExpiryDate = Expiry_Date;
the_record.UserCount = user_count;
the_record.OrgPlan = org_code;
the_record.Website = Website;
the_record.Facebook = Facebook;
the_record.Email = Email;
the_record.PhoneNo = PhoneNo;
the_record.Address = Address;
the_record.InvoiceType = InvoiceType;
the_record.Remark = remark;
the_record.Remark1 = remark1;
the_record.InvoiceAccountName = InvoiceAccountName;
the_record.InvoiceAccountNo = InvoiceAccountNo;
#region update the log
SYS_Organization log_obj = dc.GetChangeSet().Updates.OfType <SYS_Organization>().FirstOrDefault();
if (log_obj != null)
{
if (Controller_SystemLog.WirteUpdateLog(dc.SYS_Organizations.GetModifiedMembers(log_obj).ToList(), org_id, RequestID) == false)
{
//Error fail to log.
}
}
#endregion
dc.SubmitChanges();
return("Success~" + the_record.OrgID);
}
catch (Exception ex)
{
return("Error~" + ex.Message);
}
}
public static string SaveAgenda(
string AgendaID,
string AgendaDate,
string AgendaNo,
string AgendaNoLabel,
string AgendaStatus,
string AgendaHistory,
string AgendaRemark,
string UserID)
{
try
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, UserID, "read"))
{
throw new Exception("No Access.");
}
LINQ_MeetingDataContext dc = new LINQ_MeetingDataContext();
MET_Agenda the_agenda = new MET_Agenda();
if (AgendaID == "")
{
the_agenda = new MET_Agenda()
{
Active = true,
CreatedBy = UserID,
CreatedOn = DateTime.Now,
AgendaID = Guid.NewGuid().ToString(),
AgendaNo = Controller_RunningNo.GetNewRunningCode("Agenda", UserID),
};
AgendaID = the_agenda.AgendaID;
dc.MET_Agendas.InsertOnSubmit(the_agenda);
}
else
{
the_agenda = (from c in dc.MET_Agendas where c.AgendaID == AgendaID select c).FirstOrDefault();
if (the_agenda == null)
{
throw new Exception("System cannot find the record.");
}
}
DateTime agenda_date = DateTime.Today;
DateTime.TryParseExact(AgendaDate, "yyyy/M/d", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out agenda_date);
the_agenda.AgendaStatus = AgendaStatus;
the_agenda.AgendaHistory = AgendaHistory;
the_agenda.AgendaRemark = AgendaRemark;
the_agenda.AgendaDate = agenda_date;
the_agenda.AgendaNoLable = AgendaNoLabel;
the_agenda.ModifiedBy = UserID;
the_agenda.ModifiedOn = DateTime.Now;
the_agenda.LastAction = Guid.NewGuid().ToString();
#region update the log for Met_Agenda
MET_Agenda log_obj = dc.GetChangeSet().Updates.OfType <MET_Agenda>().FirstOrDefault();
if (log_obj != null)
{
if (Controller_SystemLog.WirteUpdateLog(dc.MET_Agendas.GetModifiedMembers(log_obj).ToList(), AgendaID, UserID) == false)
{
//Error fail to log.
}
}
#endregion
dc.SubmitChanges();
return("Success~" + the_agenda.AgendaID + "~" + the_agenda.AgendaNo);
}
catch (Exception ex)
{
return("Error~" + ex.Message);
}
}
