public ValidationMsg Save(SysPort model, int userid)
{
var vmMsg = new ValidationMsg();
try
{
Sys_Port tblSysPort = SetToModelObject(model, userid);
_context.Sys_Port.Add(tblSysPort);
_context.SaveChanges();
PortID = tblSysPort.PortID;
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 = "Port Code Already Exit..";
}
else
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Failed to Save.";
}
}
return(vmMsg);
}
public ValidationMsg Update(SysPort model, int userid)
{
var vmMsg = new ValidationMsg();
try
{
var sysPort = _context.Sys_Port.FirstOrDefault(s => s.PortID == model.PortID);
if (sysPort != null)
{
sysPort.PortCode = model.PortCode;
sysPort.PortName = model.PortName;
sysPort.IsActive = model.IsActive == "Active";
sysPort.ModifiedOn = DateTime.Now;
sysPort.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 = "Port Code Already Exit.";
}
else
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Failed to Update.";
}
}
return(vmMsg);
}
public ActionResult Port(SysPort model)
{
if (model != null && model.PortID != 0)
{
_vmMsg = _dalSysPort.Update(model, Convert.ToInt32(Session["UserID"]));
}
else
{
_vmMsg = _dalSysPort.Save(model, Convert.ToInt32(Session["UserID"]));
}
return(Json(new { PortID = _dalSysPort.GetPortID(), msg = _vmMsg }));
}
public Sys_Port SetToModelObject(SysPort model, int userid)
{
Sys_Port entity = new Sys_Port();
entity.PortID = model.PortID;
entity.PortCode = model.PortCode;
entity.PortName = model.PortName;
entity.IsActive = model.IsActive == "Active";
entity.SetOn = DateTime.Now;
entity.SetBy = userid;
entity.IPAddress = string.Empty;
return(entity);
}
