public async Task <int> LSave(clsSaleOrder cFl) { DynamicParameters parameter = new DynamicParameters(); parameter.Add("@MfgUnit", cFl.MfgUnit, DbType.Int16); parameter.Add("@YCode", cFl.YCode, DbType.Int16); parameter.Add("@OrdNo", cFl.OrdNo, DbType.Int16); parameter.Add("@DetNo", cFl.DetNo, DbType.Int16); parameter.Add("@ICode", cFl.ICode, DbType.Int16); parameter.Add("@Lot", cFl.Lot, DbType.Int16); parameter.Add("@Pcs", cFl.Pcs, DbType.Int16); parameter.Add("@Meter", cFl.Meter, DbType.Double); parameter.Add("@Rate", cFl.Rate, DbType.Int32); parameter.Add("@Unit", cFl.Unit, DbType.String); parameter.Add("@Amt", cFl.Amt, DbType.Double); parameter.Add("@IGSTPer", cFl.IGSTPer, DbType.Double); parameter.Add("@SGSTPer", cFl.SGSTPer, DbType.Double); parameter.Add("@CGSTPer", cFl.CGSTPer, DbType.Double); parameter.Add("@IGSTAmt", cFl.IGSTAmt, DbType.Double); parameter.Add("@SGSTAmt", cFl.SGSTAmt, DbType.Double); parameter.Add("@CGSTAmt", cFl.CGSTAmt, DbType.Double); int x = await _dapperHelper.ExecuteAsync("[dbo].[uSP_SaleLSave]", parameter, CommandType.StoredProcedure); return(x); }
public void SaleOrderView(clsSaleOrder cls) { Ope.Clear(); Ope.AddParams("MfgUnit", cls.MfgUnit); Ope.AddParams("YCode", cls.YCode); Ope.AddParams("StrStsType", cls.ViewStrStsType); Ope.AddParams("FDate", cls.F_DATE); Ope.AddParams("TDate", cls.T_DATE); Ope.FillDataSet(Ope.EnumServer.mServer, DS_VIEW, TableName, "uSP_SaleOrdView", Ope.GetParams()); }
public async Task <IHttpActionResult> LSave(clsSaleOrder cls) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { var x = await mSaleOrd.LSave(cls); return(Ok(x.ToString())); } catch (System.Exception ex) { return(BadRequest(ex.ToString())); } }
public IHttpActionResult View(int mfg = 0, int ycode = 0, string status = "", string fdate = "", string tdate = "") { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } clsSaleOrder cls = new clsSaleOrder(); cls.MfgUnit = mfg; cls.YCode = ycode; cls.ViewStrStsType = status; cls.F_DATE = Ope.DTDBDate(fdate); cls.T_DATE = Ope.DTDBDate(tdate); mSaleOrd.SaleOrderView(cls); if (mSaleOrd.DS_VIEW == null) { return(NotFound()); } return(Ok(mSaleOrd.DS_VIEW)); }
public async Task <int> HSave(clsSaleOrder cFl) { DynamicParameters parameter = new DynamicParameters(); parameter.Add("@MfgUnit", cFl.MfgUnit, DbType.Int16); parameter.Add("@YCode", cFl.YCode, DbType.Int16); parameter.Add("@OrdNo", cFl.OrdNo, DbType.Int16); parameter.Add("@ICat", cFl.ICat, DbType.String); parameter.Add("@TrnDate", cFl.TrnDate, DbType.DateTime); parameter.Add("@AC_Code", cFl.AC_Code, DbType.Int16); parameter.Add("@BAC_Code", cFl.BAC_Code, DbType.Int16); parameter.Add("@ChkName", cFl.ChkName, DbType.String); parameter.Add("@ChkMobNo", cFl.ChkMobNo, DbType.String); parameter.Add("@PayTerms", cFl.PayTerms, DbType.Int16); parameter.Add("@Remark", cFl.Remark, DbType.String); parameter.Add("@PartyOrderNo", cFl.PartyOrderNo, DbType.String); parameter.Add("@OrderStatus", cFl.OrderStatus, DbType.String); parameter.Add("@IUser", cFl.IUser, DbType.String); int x = await _dapperHelper.ExecuteAsync("[dbo].[uSP_SaleHSave]", parameter, CommandType.StoredProcedure); return(x); }