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));
}
