public string EditMapping(MappingModel model)
{
string table_Name = model.Table_Name;
string FormID = model.FormID;
int Approved = model.Approved;
int MappingFormID = model.MappingFormID;
string Message = "OK";
using (SysContext db = new SysContext())
{
try
{
fl_MappingForm entity_fl_MappingForm = db.fl_MappingForm.Single(d => d.MappingFormID == MappingFormID);
if (entity_fl_MappingForm != null)
{
entity_fl_MappingForm.FormNo = FormID;
entity_fl_MappingForm.Table_Name = table_Name;
entity_fl_MappingForm.Approved = Approved;
entity_fl_MappingForm.ModifiedUser = LoginInfo.UserID;
entity_fl_MappingForm.ModifiedTime = DateTime.Now;
entity_fl_MappingForm.ResetUpdated();
db.SaveChanges();
}
}
catch
{
Message = "Error";
}
}
return(Message);
}
public string AddMapping(MappingModel model)
{
string table_Name = model.Table_Name;
string FormID = model.FormID;
int Approved = model.Approved;
string Message = "OK";
using (SysContext db = new SysContext())
{
System.Data.Entity.DbContextTransaction tran = db.Database.BeginTransaction();
try
{
fl_MappingForm entity_fl_MappingForm = new fl_MappingForm();
entity_fl_MappingForm.FormNo = FormID;
entity_fl_MappingForm.Table_Name = table_Name;
entity_fl_MappingForm.Approved = Approved;
entity_fl_MappingForm.ApprovedDate = DateTime.Now;
entity_fl_MappingForm.TemplateUrl = "";
entity_fl_MappingForm.CreatedUser = LoginInfo.UserID;
entity_fl_MappingForm.ModifiedUser = LoginInfo.UserID;
entity_fl_MappingForm.ResetCreated();
db.fl_MappingForm.Add(entity_fl_MappingForm);
db.SaveChanges();
tran.Commit();
}
catch
{
tran.Rollback();
Message = "Error";
}
}
return(Message);
}
