public ValidationMsg Save(SysCountry model, int userid)
{
var vmMsg = new ValidationMsg();
try
{
Sys_Country tblSysCountry = SetToModelObject(model, userid);
_context.Sys_Country.Add(tblSysCountry);
_context.SaveChanges();
CountryID = tblSysCountry.CountryID;
vmMsg.Type = Enums.MessageType.Success;
vmMsg.Msg = "Saved Successfully.";
}
catch (Exception ex)
{
if (ex.InnerException.InnerException.Message.Contains("UNIQUE KEY"))
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Country Code Already Exit..";
}
else
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Failed to Save.";
}
}
return(vmMsg);
}
public ValidationMsg Update(SysCountry model, int userid)
{
var vmMsg = new ValidationMsg();
try
{
var sysCountry = _context.Sys_Country.FirstOrDefault(s => s.CountryID == model.CountryID);
if (sysCountry != null)
{
sysCountry.CountryCode = model.CountryCode;
sysCountry.CountryName = model.CountryName;
sysCountry.IsActive = model.IsActive == "Active";
sysCountry.ModifiedOn = DateTime.Now;
sysCountry.ModifiedBy = userid;
}
_context.SaveChanges();
vmMsg.Type = Enums.MessageType.Update;
vmMsg.Msg = "Updated Successfully.";
}
catch (Exception ex)
{
if (ex.InnerException.InnerException.Message.Contains("UNIQUE KEY"))
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Country Code Already Exit.";
}
else
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Failed to Update.";
}
}
return(vmMsg);
}
public ActionResult Country(SysCountry model)
{
if (model != null && model.CountryID != 0)
{
_vmMsg = _dalSysCountry.Update(model, Convert.ToInt32(Session["UserID"]));
}
else
{
_vmMsg = _dalSysCountry.Save(model, Convert.ToInt32(Session["UserID"]));
}
return(Json(new { CountryID = _dalSysCountry.GetCountryID(), msg = _vmMsg }));
}
public Sys_Country SetToModelObject(SysCountry model, int userid)
{
Sys_Country entity = new Sys_Country();
entity.CountryID = model.CountryID;
entity.CountryCode = model.CountryCode;
entity.CountryName = model.CountryName;
entity.IsActive = model.IsActive == "Active";
entity.SetOn = DateTime.Now;
entity.SetBy = userid;
entity.IPAddress = string.Empty;
return(entity);
}
