public ActionResult Insert(GstViewModel objViewModel)
{
ModelState.Remove("Id");
if (objViewModel.EditID == 0)
{
if (InsertData(objViewModel))
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(3, JsonRequestBehavior.AllowGet));
}
}
else
{
if (InsertData(objViewModel))
{
return(Json(2, JsonRequestBehavior.AllowGet));
}
}
ViewBag.GSTAccountList = new SelectList(_gstService.GSTAccountList(), "AccountID", "Name");
ViewBag.IGSTAccountList = new SelectList(_gstService.GSTAccountList(), "AccountID", "Name");
return(View("Index", objViewModel));
}
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 ActionResult Insert(GstViewModel objViewModel)
{
ModelState.Remove("Id");
if (objViewModel.ID == 0)
{
//_employeeService.AddEmployee(objViewModel);
if (InsertData(objViewModel))
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(3, JsonRequestBehavior.AllowGet));
}
}
else
{
if (InsertData(objViewModel))
{
return(Json(2, JsonRequestBehavior.AllowGet));
}
}
return(View("Index", objViewModel));
}
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 ActionResult GST()
{
ButtonVisiblity("Index");
var model = new GstViewModel();
model.EffectiveFrom = DateTime.Now;
model.ID = dd._context.Mst_GstMaster.Any() ? dd._context.Mst_GstMaster.Max(m => m.Gst_RefId) + 1 : 1;
return(View(model));
}
public ActionResult GST()
{
ButtonVisiblity("Index");
var model = new GstViewModel();
model.ID = _gstService.GetMaxId();
ViewBag.GSTAccountList = new SelectList(_gstService.GSTAccountList(), "AccountID", "Name");
return(View(model));
}
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 ActionResult GetGSTById(int ID)
{
string operation = Session["Operation"].ToString();
ButtonVisiblity(operation);
var tblgst = _gstService.GetGSTById(ID);
var gstvm = new GstViewModel();
if (tblgst != null)
{
gstvm = _gstService.SetDataOnEdit(tblgst);
}
gstvm.operation = operation;
ViewBag.GSTAccountList = new SelectList(_gstService.GSTAccountList(), "AccountID", "Name");
ViewBag.IGSTAccountList = new SelectList(_gstService.GSTAccountList(), "AccountID", "Name");
return(View("GST", gstvm));
}
public bool InsertData(GstViewModel gstvm)
{
bool retVal = false;
gstvm.CreatedBy = Convert.ToInt32(Session["UserLoginId"]);
gstvm.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]);
try
{
_gstService.SaveUpdateRecord(gstvm);
retVal = true;
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public List <GstViewModel> GetAllGSTMasters()
{
List <GstViewModel> list = new List <GstViewModel>();
var tbllist = _context.Mst_GstMaster.ToList();
foreach (var item in tbllist)
{
GstViewModel gstvm = new GstViewModel();
gstvm.ID = item.Gst_RefId;
gstvm.EditID = item.Gst_RefId;
gstvm.EffectiveFrom = item.Gst_EffectiveFrom.ToShortDateString();
gstvm.CGST = item.Gst_CGST;
gstvm.SGST = item.Gst_SGST;
gstvm.IGST = item.Gst_IGST;
gstvm.CGSTAccountNo = item.Gst_CgstAccountId;
gstvm.SGSTAccountNo = item.Gst_SgstAccountId;
gstvm.CGSTAccountName = _context.tblaccountmasters.Where(x => x.AccountID == item.Gst_CgstAccountId).Select(x => x.Name).FirstOrDefault();
gstvm.SGSTAccountName = _context.tblaccountmasters.Where(x => x.AccountID == item.Gst_SgstAccountId).Select(x => x.Name).FirstOrDefault();
list.Add(gstvm);
}
return(list);
}
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 void SaveUpdateRecord(GstViewModel model)
{
_gstRepository.SaveUpdateRecord(model);
}