public JsonResult CreateEdit(GstViewModel gst)
{
gst.CreatedBy = Convert.ToInt32(Session["UserLoginId"]);
gst.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]);
Mst_GstMaster tblGst = new Mst_GstMaster();
try
{
gst.ID = dd._context.Mst_GstMaster.Any() ? dd._context.Mst_GstMaster.Max(m => m.Gst_RefId) + 1 : 1;
if (gst.EditID <= 0)
{
tblGst.Gst_RefId = gst.ID;
tblGst.Gst_RecordCreated = DateTime.Now;
tblGst.Gst_RecordCreatedBy = gst.CreatedBy;
dd._context.Mst_GstMaster.Add(tblGst);
}
else
{
tblGst = dd._context.Mst_GstMaster.Where(x => x.Gst_RefId == gst.ID).FirstOrDefault();
}
tblGst.Gst_EffectiveFrom = gst.EffectiveFrom;
tblGst.Gst_CGST = gst.CGST;
tblGst.Gst_SGST = gst.SGST;
tblGst.Gst_IGST = gst.IGST;
tblGst.Gst_RecordUpdated = DateTime.Now;
tblGst.Gst_RecordUpdatedBy = gst.UpdatedBy;
dd._context.SaveChanges();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(Json(gst));
}
public void SaveUpdateRecord(GstViewModel gstvm)
{
Mst_GstMaster tblGst = new Mst_GstMaster();
if (gstvm.EditID <= 0)
{
gstvm.ID = _context.Mst_GstMaster.Any() ? _context.Mst_GstMaster.Max(m => m.Gst_RefId) + 1 : 1;
tblGst.Gst_RefId = gstvm.ID;
tblGst.Gst_RecordCreated = DateTime.Now;
tblGst.Gst_RecordCreatedBy = gstvm.CreatedBy;
_context.Mst_GstMaster.Add(tblGst);
}
else
{
tblGst = _context.Mst_GstMaster.Where(x => x.Gst_RefId == gstvm.ID).FirstOrDefault();
}
tblGst.Gst_EffectiveFrom = Convert.ToDateTime(gstvm.EffectiveFrom);
tblGst.Gst_CGST = gstvm.CGST;
tblGst.Gst_SGST = gstvm.SGST;
tblGst.Gst_IGST = gstvm.IGST;
tblGst.Gst_CgstAccountId = gstvm.CGSTAccountNo;
tblGst.Gst_SgstAccountId = gstvm.SGSTAccountNo ?? 0;
tblGst.Gst_RecordUpdated = DateTime.Now;
tblGst.Gst_RecordUpdatedBy = gstvm.UpdatedBy;
_context.SaveChanges();
}
public GstViewModel SetRecordinEdit(Mst_GstMaster tblGst)
{
GstViewModel gstvm = new GstViewModel();
gstvm.ID = tblGst.Gst_RefId;
gstvm.EditID = tblGst.Gst_RefId;
gstvm.EffectiveFrom = tblGst.Gst_EffectiveFrom.ToShortDateString();
gstvm.CGST = tblGst.Gst_CGST;
gstvm.SGST = tblGst.Gst_SGST;
gstvm.IGST = tblGst.Gst_IGST;
gstvm.CGSTAccountNo = tblGst.Gst_CgstAccountId;
gstvm.SGSTAccountNo = tblGst.Gst_SgstAccountId;
return(gstvm);
}
public ActionResult GetGSTById(int ID)
{
string operation = Session["Operation"].ToString();
ButtonVisiblity(operation);
Mst_GstMaster tblGst = dd._context.Mst_GstMaster.Where(x => x.Gst_RefId == ID).FirstOrDefault();
GstViewModel gstvm = new GstViewModel();
gstvm.ID = tblGst.Gst_RefId;
gstvm.EditID = tblGst.Gst_RefId;
gstvm.EffectiveFrom = tblGst.Gst_EffectiveFrom;
gstvm.CGST = tblGst.Gst_CGST;
gstvm.SGST = tblGst.Gst_SGST;
gstvm.IGST = tblGst.Gst_IGST;
gstvm.operation = operation;
return(View("GST", gstvm));
}
public bool InsertData(GstViewModel gstvm)
{
bool retVal = false;
gstvm.CreatedBy = Convert.ToInt32(Session["UserLoginId"]);
gstvm.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]);
Mst_GstMaster tblGst = new Mst_GstMaster();
try
{
gstvm.ID = dd._context.Mst_GstMaster.Any() ? dd._context.Mst_GstMaster.Max(m => m.Gst_RefId) + 1 : 1;
if (gstvm.EditID <= 0)
{
tblGst.Gst_RefId = gstvm.ID;
tblGst.Gst_RecordCreated = DateTime.Now;
tblGst.Gst_RecordCreatedBy = gstvm.CreatedBy;
dd._context.Mst_GstMaster.Add(tblGst);
}
else
{
tblGst = dd._context.Mst_GstMaster.Where(x => x.Gst_RefId == gstvm.ID).FirstOrDefault();
}
tblGst.Gst_EffectiveFrom = gstvm.EffectiveFrom;
tblGst.Gst_CGST = gstvm.CGST;
tblGst.Gst_SGST = gstvm.SGST;
tblGst.Gst_IGST = gstvm.IGST;
tblGst.Gst_RecordUpdated = DateTime.Now;
tblGst.Gst_RecordUpdatedBy = gstvm.UpdatedBy;
dd._context.SaveChanges();
retVal = true;
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public GstViewModel SetDataOnEdit(Mst_GstMaster tblgst)
{
return(_gstRepository.SetRecordinEdit(tblgst));
}
