public ActionResult SchemeMaster(clsSchemeMst oSch) { string sLine = ""; var sMsg = new { Message = "Successfully Saved ...", MsgID = 1, ComplaintNo = "0" }; try { string CompNo = DateTime.Now.Date.Date.ToString("yy") + DateTime.Now.Date.Date.ToString("MM") + DateTime.Now.Date.Date.ToString("dd"); tblSchemeMst oMst = new tblSchemeMst(); oMst.MstCode = Convert.ToInt32(oSubmit.GetSingleData("Select isnull(max(MstCode)+1,1) from tblSchemeMst", "0", true)); oMst.MstDate = oSubmit.GetDate(oSch.sMstDate.ToString()); oMst.SchNo = CompNo + GetNo(oMst.MstCode.ToString()); oMst.SchName = oSch.SchName; oMst.ClaimFrom = oSubmit.GetDate(oSch.sMstDate.ToString()); oMst.ClaimTo = oSubmit.GetDate(oSch.sMstDate.ToString()); if (oSch.SchFrom.ToString() != "") { oMst.SchFrom = oSubmit.GetDate(oSch.SchFrom.ToString()); } if (oSch.SchTo.ToString() != "") { oMst.SchTO = oSubmit.GetDate(oSch.SchTo.ToString()); } oMst.CreatedOn = DateTime.Now; db.tblSchemeMsts.InsertOnSubmit(oMst); db.SubmitChanges(); tblSchemeItd oItd; var json = oSch.SchemeItm; clsPoItem ItemDet = JsonConvert.DeserializeObject <clsPoItem>(json); for (int i = 0; i < ItemDet.LstItem.Count; i++) { oItd = new tblSchemeItd(); oItd.ItdCode = oMst.MstCode; oItd.ItemID = ItemDet.LstItem[i].ItemID; oItd.BrandID = ItemDet.LstItem[i].itdmill; oItd.Qty = Convert.ToInt32(ItemDet.LstItem[i].Qty); oItd.itdFrom = oSubmit.GetDate(ItemDet.LstItem[i].sFrom.ToString()); oItd.itdTo = oSubmit.GetDate(ItemDet.LstItem[i].sTo.ToString()); oItd.Offer = ItemDet.LstItem[i].Remark; db.tblSchemeItds.InsertOnSubmit(oItd); db.SubmitChanges(); } CompNo = CompNo + GetNo(oSubmit.GetSingleData("Select isnull(max(CompID)+1,1) from tblComplaint", "0", true).ToString()); sMsg = new { Message = "Successfully Saved .", MsgID = 1, ComplaintNo = CompNo }; } catch (Exception ex) { sMsg = new { Message = sLine + "#" + ex.Message, MsgID = 2, ComplaintNo = "0" }; } return(Json(sMsg, JsonRequestBehavior.AllowGet)); }
public ActionResult Filter() { clsSubmitModel oSubmit = new clsSubmitModel(); DataTable dtParty; List <clsFilter> lstFilter = new List <clsFilter>(); dtParty = oSubmit.GetData("Select AcctName , acctCode from Account where Compcode =" + SessionMaster.CompCode + " and acctgrou in (21 ,22) order by AcctName "); clsFilter sm1 = new clsFilter(); clsFilter sm = new clsFilter(); clsPoItem Po1 = new clsPoItem(); for (int i = 0; i < dtParty.Rows.Count; i++) { sm = new clsFilter(); sm.PartyName = dtParty.Rows[i]["AcctName"].ToString(); sm.PartyID = Convert.ToInt32(dtParty.Rows[i]["acctCode"].ToString()); lstFilter.Add(sm); } sm1.lstFilter = lstFilter; lstFilter = new List <clsFilter>(); dtParty = oSubmit.GetData("Select AcctName , acctCode from Account where Compcode =" + SessionMaster.CompCode + " and acctgrou = 34 order by AcctName "); for (int i = 0; i < dtParty.Rows.Count; i++) { sm = new clsFilter(); sm.PartyName = dtParty.Rows[i]["AcctName"].ToString(); sm.PartyID = Convert.ToInt32(dtParty.Rows[i]["acctCode"].ToString()); lstFilter.Add(sm); } sm1.lstAgent = lstFilter; lstFilter = new List <clsFilter>(); dtParty = oSubmit.GetData("Select AcctName , acctCode from Account where Compcode =" + SessionMaster.CompCode + " and acctgrou = 28 order by AcctName "); for (int i = 0; i < dtParty.Rows.Count; i++) { sm = new clsFilter(); sm.PartyName = dtParty.Rows[i]["AcctName"].ToString(); sm.PartyID = Convert.ToInt32(dtParty.Rows[i]["acctCode"].ToString()); lstFilter.Add(sm); } sm1.lstEmployee = lstFilter; lstFilter = new List <clsFilter>(); dtParty = oSubmit.GetData("select cityCode ,cityName from citydet where citytype = 15 order by cityName "); for (int i = 0; i < dtParty.Rows.Count; i++) { sm = new clsFilter(); sm.PartyName = dtParty.Rows[i]["cityName"].ToString(); sm.PartyID = Convert.ToInt32(dtParty.Rows[i]["cityCode"].ToString()); lstFilter.Add(sm); } sm1.lstCity = lstFilter; ERPDataContext o = new ERPDataContext(); ViewBag.PartyList = (from a in o.accounts where a.compcode == SessionMaster.CompCode && a.acctgrou == 21 && a.acctgrou == 22 select a).AsEnumerable(); return(View(sm1)); }