protected void btnPackageService_Click(object sender, EventArgs e) { if (Page.IsValid) { try { List <TombstonePackageModel> modelList = client.GetTombstonePackageServiceByPackgeId(this.ParlourId, Convert.ToInt32(ddlPackage.SelectedValue)).ToList(); TombStoneServiceSelectModel objSer = null; foreach (var item in modelList) { objSer = new TombStoneServiceSelectModel(); objSer.fkiTombstoneID = TBID; objSer.fkiServiceID = item.fkiServiceID; objSer.Quantity = 1; objSer.lastModified = System.DateTime.Now; objSer.modifiedUser = UserName; objSer.ServiceRate = item.ServiceCost; int a = client.SaveTombStoneService(objSer); } ShowMessage(ref lblMessage, MessageType.Success, "Package successfully applied."); bindServiceListList(); ClearService(); DiscountCal(); } catch (Exception ex) { ShowMessage(ref lblMessage, MessageType.Danger, ex.Message); } } }
public static int SaveTombStoneService(TombStoneServiceSelectModel model) { string query = "SaveTombStoneService"; DbParameter[] ObjParam = new DbParameter[7]; ObjParam[0] = new DbParameter("@fkiTombstoneID", DbParameter.DbType.Int, 0, model.fkiTombstoneID); ObjParam[1] = new DbParameter("@fkiServiceID", DbParameter.DbType.Int, 0, model.fkiServiceID); ObjParam[2] = new DbParameter("@Quantity", DbParameter.DbType.Int, 0, model.Quantity); ObjParam[3] = new DbParameter("@LastModified", DbParameter.DbType.DateTime, 0, model.lastModified); ObjParam[4] = new DbParameter("@ModifiedUser", DbParameter.DbType.VarChar, 0, model.modifiedUser); ObjParam[5] = new DbParameter("@ServiceRate", DbParameter.DbType.Money, 0, model.ServiceRate); ObjParam[6] = new DbParameter("@pkiTombStoneSelectionID", DbParameter.DbType.Int, 0, model.pkiTombStoneSelectionID); return(Convert.ToInt32(DbConnection.GetScalarValue(CommandType.StoredProcedure, query, ObjParam))); }
//public void GetTombStoneInvoiceNumber() //{ // TombStoneModel objQuotation = client.SelectTombStoneByParlAndPki(TBID, ParlourId); // if (objQuotation.InvoiceNumber == null || objQuotation.InvoiceNumber == "") // { // TombStoneModel obj = client.GetInvoiceNumOfTombByParlID(ParlourId); // if (obj.InvoiceNumber2 == string.Empty || obj.InvoiceNumber2 == "") // { // ViewState["InvoiceNumber2"] = "0001"; // } // else // { // string s = obj.InvoiceNumber2; // s = (Int32.Parse(s) + 1).ToString("D4"); // txtInvoiceNumber.Text= s; // } // } //} public void BindServiceToUpdate() { int serviceID = Convert.ToInt32(ViewState["ID"]); TombStoneServiceSelectModel model = client.SelectServiceByTombAndID(TBID, serviceID); if ((model == null) || (model.fkiTombstoneID != TBID)) { Response.Write("<script>alert('Sorry!you are not authorized to perform edit on this Service.');</script>"); } else { ddlServices.SelectedValue = model.pkiServiceID.ToString(); txtSerDes.Text = model.ServiceDesc; txtNumber.Text = model.Quantity.ToString(); txtRate.Text = model.ServiceRate.ToString(); AddServ.Text = "Update"; } }
protected void btncrtService_Click(object sender, EventArgs e) { if (Page.IsValid) { try { TombStoneServiceSelectModel objSer = null; if (objSer != null) { //ShowMessage(ref lblMessage, MessageType.Danger, "Member Dependenc Already Exists."); } else { objSer = new TombStoneServiceSelectModel(); if (ViewState["ID"] != null) { objSer.pkiTombStoneSelectionID = Convert.ToInt32(ViewState["ID"]); ViewState["ID"] = null; } objSer.fkiTombstoneID = TBID; objSer.fkiServiceID = Convert.ToInt32(ddlServices.SelectedValue); objSer.Quantity = Convert.ToInt32(txtNumber.Text); objSer.lastModified = System.DateTime.Now; objSer.modifiedUser = UserName; objSer.ServiceRate = Convert.ToDecimal(txtRate.Text); int a = client.SaveTombStoneService(objSer); ViewState["FuneralID"] = a; ShowMessage(ref lblMessage, MessageType.Success, "Service Successfully Saved."); bindServiceListList(); ClearService(); DiscountCal(); } } catch (Exception ex) { ShowMessage(ref lblMessage, MessageType.Danger, ex.Message); } } }
public static int SaveTombStoneService(TombStoneServiceSelectModel model) { return(TombStoneDAL.SaveTombStoneService(model)); }