protected void SaveAllDetails(object sender, EventArgs e) { string Notes = txtNotes.Text; string QuotaNum = txtQuotationNumber.Text; int a = client.UpdateAllData(QuotationID, Notes, QuotaNum); //Discount Insert QuotationDiscountModel objQDM = new QuotationDiscountModel(); objQDM.DiscountID = Convert.ToInt32(ViewState["DiscountID"]); objQDM.QuotationID = QuotationID; //objQDM.Amount = Convert.ToInt32((lblDisAmt2.Text).ToString()); objQDM.LastModified = DateTime.Now; objQDM.ModifiedUser = UserName; int b = client.SaveDiscountAndAmount(objQDM); Decimal Tax = Convert.ToDecimal(ddlTax.SelectedValue); Decimal dis = 0; if (txtDiscount.Text == null || txtDiscount.Text == "") { dis = 0; } else { dis = Convert.ToDecimal(txtDiscount.Text); } int save = client.SaveQuotationTaxAndDiscount(QuotationID, Tax, dis); ShowMessage(ref lblMessage, MessageType.Success, " Successfully Saved."); }
public void bindServicesType() { try { QuotationServicesModel[] objQuoSer = client.GetAllQuotationServices(ParlourId); ddlServices.DataTextField = "ServiceName"; ddlServices.DataValueField = "pkiServiceID"; ddlServices.DataSource = objQuoSer; ddlServices.DataBind(); ddlServices.Items.Insert(0, new ListItem("Select", "0")); QuotationDiscountModel objid = client.GetAllQuotationDiscounts(QuotationID); if (objid == null) { ViewState["DiscountID"] = "0"; } else { ViewState["DiscountID"] = objid.DiscountID; } } catch (Exception ex) { ShowMessage(ref lblMessage, MessageType.Danger, ex.Message); } }
public static int SaveDiscountAndAmount(QuotationDiscountModel model) { string query = "SaveDiscountAndAmount"; DbParameter[] ObjParam = new DbParameter[5]; ObjParam[0] = new DbParameter("@DiscountID", DbParameter.DbType.Int, 0, model.DiscountID); ObjParam[1] = new DbParameter("@QuotationID", DbParameter.DbType.Int, 0, model.QuotationID); ObjParam[2] = new DbParameter("@Amount", DbParameter.DbType.Int, 0, model.Amount); ObjParam[3] = new DbParameter("@LastModified", DbParameter.DbType.DateTime, 0, model.LastModified); ObjParam[4] = new DbParameter("@ModifiedUser", DbParameter.DbType.VarChar, 0, model.ModifiedUser); return(Convert.ToInt32(DbConnection.GetScalarValue(CommandType.StoredProcedure, query, ObjParam))); }
public int SaveDiscountAndAmount(QuotationDiscountModel model) { return(QuotationBAL.SaveDiscountAndAmount(model)); }