public static int SaveTombStone(TombStoneModel model) { string query = "SaveTombStone"; DbParameter[] ObjParam = new DbParameter[26]; ObjParam[0] = new DbParameter("@pkiTombstoneID", DbParameter.DbType.Int, 0, model.pkiTombstoneID); ObjParam[1] = new DbParameter("@LastName", DbParameter.DbType.NVarChar, 0, model.LastName); ObjParam[2] = new DbParameter("@FirstName", DbParameter.DbType.NVarChar, 0, model.FirstName); ObjParam[3] = new DbParameter("@IDNumber", DbParameter.DbType.NVarChar, 0, model.IDNumber); ObjParam[4] = new DbParameter("@DateOfApplication", DbParameter.DbType.DateTime, 0, model.DateOfApplication); ObjParam[5] = new DbParameter("@Address1", DbParameter.DbType.NVarChar, 0, model.Address1); ObjParam[6] = new DbParameter("@Address2", DbParameter.DbType.NVarChar, 0, model.Address2); ObjParam[7] = new DbParameter("@Address3", DbParameter.DbType.NVarChar, 0, model.Address3); ObjParam[8] = new DbParameter("@Code", DbParameter.DbType.NVarChar, 0, model.Code); ObjParam[9] = new DbParameter("@TelNumber", DbParameter.DbType.NVarChar, 0, model.TelNumber); ObjParam[10] = new DbParameter("@CellNumber", DbParameter.DbType.NVarChar, 0, model.CellNumber); ObjParam[11] = new DbParameter("@DeceasedLastName", DbParameter.DbType.NVarChar, 0, model.DeceasedLastName); ObjParam[12] = new DbParameter("@DeceasedFirstName", DbParameter.DbType.NVarChar, 0, model.DeceasedFirstName); ObjParam[13] = new DbParameter("@DeceasedIDNumber", DbParameter.DbType.NVarChar, 0, model.DeceasedIDNumber); ObjParam[14] = new DbParameter("@Deceased", DbParameter.DbType.NVarChar, 0, model.Deceased); ObjParam[15] = new DbParameter("@DateOFMemorial", DbParameter.DbType.DateTime, 0, model.DateOFMemorial); ObjParam[16] = new DbParameter("@CemeterOrCrematorium", DbParameter.DbType.NVarChar, 0, model.CemeterOrCrematorium); ObjParam[17] = new DbParameter("@GraveNo", DbParameter.DbType.NVarChar, 0, model.GraveNo); ObjParam[18] = new DbParameter("@Erect", DbParameter.DbType.NVarChar, 0, model.Erect); ObjParam[19] = new DbParameter("@TombStoneMessage", DbParameter.DbType.NVarChar, 0, model.TombStoneMessage); ObjParam[20] = new DbParameter("@Notes", DbParameter.DbType.NVarChar, 0, model.Notes); ObjParam[21] = new DbParameter("@parlourid", DbParameter.DbType.UniqueIdentifier, 0, model.parlourid); ObjParam[22] = new DbParameter("@ModifiedUser", DbParameter.DbType.NVarChar, 0, model.ModifiedUser); ObjParam[23] = new DbParameter("@InvoiceNumber", DbParameter.DbType.NVarChar, 0, model.InvoiceNumber); ObjParam[24] = new DbParameter("@ContactPerson", DbParameter.DbType.NVarChar, 0, model.ContactPerson); ObjParam[25] = new DbParameter("@ContactPersonNumber", DbParameter.DbType.NVarChar, 0, model.ContactPersonNumber); return(Convert.ToInt32(DbConnection.GetScalarValue(CommandType.StoredProcedure, query, ObjParam))); }
public void GetTombStoneData() { TombStoneModel objQuotation = new TombStoneModel(); objQuotation = null; objQuotation = client.SelectTombStoneByParlAndPki(TBID, ParlourId); if (objQuotation != null) { txtTo.Text = objQuotation.LastName + " " + objQuotation.FirstName + Environment.NewLine + objQuotation.Address1 + "," + Environment.NewLine + objQuotation.Address2 + "," + Environment.NewLine + objQuotation.Address3 + "," + Environment.NewLine + objQuotation.Address4 + Environment.NewLine + objQuotation.Code; txtInvoiceNumber.Text = objQuotation.InvoiceNumber; string CreatedDate = objQuotation.CreatedDate.ToString(); if (CreatedDate == null || CreatedDate == "01/01/0001 00:00:00" || CreatedDate == "01-01-0001 00:00:00")//"01/01/0001 00:00:00" { txtDate.Text = System.DateTime.Now.ToString("dd/MMM/yyyy"); } else { txtDate.Text = objQuotation.CreatedDate.ToString("dd/MMM/yyyy"); } if (objQuotation.Tax != null) { ddlTax.SelectedValue = (objQuotation.Tax).ToString("N2"); } string datenow = txtDate.Text; DateTime Start = DateTime.Parse(datenow); DateTime end = Start.AddHours(48); txtDueDate.Text = end.ToString("dd/MMM/yyyy"); txtDiscount.Text = (objQuotation.DisCount).ToString(); txtNotes.Text = objQuotation.Notes; } }
public void bindServiceListList() { List <TombStoneServiceSelectModel> objServ = client.SelectServiceByTombStoneID(TombstoneId).ToList(); decimal Amt = 0; foreach (var item in objServ) { Amt = Amt + item.Amount; } TombStoneModel tombstoneModel = client.SelectTombStoneByParlAndPki(TombstoneId, ParlourId); decimal TotalPayment = client.TombStonesPaymentSelectByTombstoneId(this.ParlourId, TombstoneId).ToList().Sum(x => x.AmountPaid); txtAmount.Text = CalculateFinal(Amt, tombstoneModel.Tax, tombstoneModel.DisCount, TotalPayment); gvServiceList.DataSource = objServ; gvServiceList.DataBind(); }
public void BindCustomerDetails() { if (QuotationID != 0 && ParlourId != Guid.Empty) { QuotationModel objQuotation = client.SelectQuotationByQuotationId(QuotationID, ParlourId); lblName.Text = objQuotation.ContactTitle + " " + objQuotation.ContactLastName + " " + objQuotation.ContactFirstName; lblcAdd1.Text = objQuotation.AddressLine1; lblcAdd2.Text = objQuotation.AddressLine2; lblcAdd3.Text = objQuotation.AddressLine3; lblcAdd4.Text = objQuotation.AddressLine4; lblcCode.Text = objQuotation.Code; lblDate.Text = objQuotation.DateOfQuotation.ToString("dd MMM yyyy"); lblInvoiceDateTitle.Text = "Quotation date"; lblInvoiceDate.Text = objQuotation.DateOfQuotation.ToString("dd MMM yyyy"); lblNumber1.Text = "Quotation Number"; lblNumber2.Text = objQuotation.QuotationNumber.ToString(); lblHeading.Text = "Quotation"; lblTax.Text = (objQuotation.Tax).ToString("N2"); lblDiscount.Text = (objQuotation.Discount).ToString(); lblNotes.Text = objQuotation.Notes; } else if (FID != 0 && ParlourId != Guid.Empty) { FuneralModel model = client.SelectFuneralBypkid(FID, ParlourId); lblName.Text = string.Format("<b>Contact Person : </b>{0}<br/><b>Contact Number : </b>{1}", model.ContactPerson, model.ContactPersonNumber); lblcAdd1.Text = model.Address1; lblcAdd2.Text = model.Address2; lblcAdd3.Text = model.Address3; lblcAdd4.Text = model.Address4; lblcCode.Text = model.Code; //string CreatedDate = model.CreatedDate.ToString(); if (model.CreatedDate == null || model.CreatedDate == DateTime.MinValue)//"01/01/0001 00:00:00" { if (model.DateOfFuneral != DateTime.MinValue) { lblDate.Text = model.DateOfFuneral.ToString("dd/MMM/yyyy"); } else { lblDate.Text = System.DateTime.Now.ToString("dd/MMM/yyyy"); } } else { lblDate.Text = model.CreatedDate.ToString("dd/MMM/yyyy"); } lblInvoiceDateTitle.Text = "Invoice date"; lblInvoiceDate.Text = lblDate.Text; //string datenow = lblDate.Text; DateTime Start = DateTime.Parse(lblDate.Text); DateTime end = Start.AddHours(48); lblDueDate1.Text = end.ToString("dd/MMM/yyyy"); lblDueDate.Text = "Due Date"; lblNumber1.Text = "Invoice Number"; lblNumber2.Text = model.InvoiceNumber.ToString(); lblHeading.Text = "Funeral Invoice"; lblTax.Text = (model.Tax).ToString("N2"); lblDiscount.Text = (model.Discount).ToString(); lblNotes.Text = model.Notes; lblDecename1.Text = "Name:"; lblDecename2.Text = string.Format("{0} {1}", model.FullNames, model.Surname); lblDeceIDnum1.Text = "ID Number:"; lblDeceIDnum2.Text = model.IDNumber; lblDeceBI1.Text = "BI663 Serial No:"; lblDeceBI2.Text = model.BI1663; lblCemetery1.Text = "Cemetery:"; lblCemetery2.Text = model.FuneralCemetery; lblDeceDate1.Text = "Date: " + (model.DateOfFuneral).ToString("dd/MMM/yyyy") + " "; lblDeceDate2.Text = "At " + (model.TimeOfFuneral).ToString("hh:mm"); lblsemi.Text = ":"; } else if (TBID != 0 && ParlourId != Guid.Empty) { TombStoneModel model = client.SelectTombStoneByParlAndPki(TBID, ParlourId); lblName.Text = string.Format("<b>Contact Person : </b>{0}<br/><b>Contact Number : </b>{1}", model.ContactPerson, model.ContactPersonNumber); lblcAdd1.Text = model.Address1; lblcAdd2.Text = model.Address2; lblcAdd3.Text = model.Address3; lblcAdd4.Text = model.Address4; lblcCode.Text = model.Code; //string CreatedDate = model.CreatedDate.ToString(); if (model.CreatedDate == null || model.CreatedDate == DateTime.MinValue)//"01/01/0001 00:00:00" { if (model.DateOfApplication != null && model.DateOfApplication != DateTime.MinValue) { lblDate.Text = Convert.ToDateTime(model.DateOfApplication).ToString("dd/MMM/yyyy"); } else { lblDate.Text = System.DateTime.Now.ToString("dd/MMM/yyyy"); } lblDate.Text = System.DateTime.Now.ToString("dd/MMM/yyyy"); } else { lblDate.Text = model.CreatedDate.ToString("dd/MMM/yyyy"); } //lblInvoiceDateTitle.Text = "Invoice date"; //lblInvoiceDate.Text = lblDate.Text; string datenow = lblDate.Text; DateTime Start = DateTime.Parse(datenow); DateTime end = Start.AddHours(48); lblDueDate1.Text = end.ToString("dd/MMM/yyyy"); lblDueDate.Text = "Due Date :"; lblNumber1.Text = "Invoice Number"; lblNumber2.Text = model.InvoiceNumber.ToString(); lblHeading.Text = "Tombstone Invoice"; lblTax.Text = (model.Tax).ToString("N2"); lblDiscount.Text = (model.DisCount).ToString(); lblNotes.Text = model.Notes; lblMsg1.Text = "Message:"; lblMsg2.Text = model.TombStoneMessage; lblsemi.Text = ":"; lblInvoiceDateTitle.Text = "<b>Deceased Info : </b>"; lblDecename1.Text = "<b>Id number : </b>"; lblDeceIDnum1.Text = "<b>Date of death : </b>"; lblDeceBI1.Text = "<b>Cemetery name : </b>"; lblCemetery1.Text = "<b>Grave no : </b>"; lblInvoiceDate.Text = string.Format("{0} {1}", model.DeceasedLastName, model.DeceasedFirstName); lblDecename2.Text = model.DeceasedIDNumber; lblDeceIDnum2.Text = model.DateOFMemorial.HasValue ? Convert.ToDateTime(model.DateOFMemorial).ToString("dd/MMM/yyyy") : "Not provided"; lblDeceBI2.Text = model.CemeterOrCrematorium; lblCemetery2.Text = model.GraveNo; } }
public static int SaveTombStone(TombStoneModel model) { return(TombStoneDAL.SaveTombStone(model)); }
protected void btnSubmitClick(object sender, EventArgs e) { if (Page.IsValid) { try { TombStoneModel objTomb = client.SelectTombStoneByParlAndPki(TSID, ParlourId); if (objTomb != null && TSID == 0) { ShowMessage(ref lblMessage, MessageType.Danger, "TombStone Details Already Exists."); } else { objTomb = new TombStoneModel(); objTomb.pkiTombstoneID = TSID; objTomb.LastName = txtLastName.Text; objTomb.FirstName = txtFirstName.Text; objTomb.IDNumber = txtIdNumber1.Text; if (txtAppDate.Text == null || txtAppDate.Text == "") { objTomb.DateOfApplication = null; } else { objTomb.DateOfApplication = Convert.ToDateTime(txtAppDate.Text); } objTomb.TelNumber = txtTel.Text; objTomb.Address1 = txtAdd1.Text; objTomb.Address2 = txtadd2.Text; objTomb.Address3 = txtadd3.Text; objTomb.Code = txtCode.Text; objTomb.CellNumber = txtCell.Text; objTomb.DeceasedLastName = txtDLastName.Text; objTomb.DeceasedFirstName = txtDFirstname.Text; objTomb.DeceasedIDNumber = txtDIdNumber.Text; string Deceased = string.Empty; if (rdbBuried.Checked) { Deceased = "Buried"; } else if (rdbCremated.Checked) { Deceased = "Cremated"; } objTomb.Deceased = Deceased; if (txtDateOfMemorial.Text == null || txtDateOfMemorial.Text == "") { objTomb.DateOFMemorial = null; } else { objTomb.DateOFMemorial = Convert.ToDateTime(txtDateOfMemorial.Text); } objTomb.CemeterOrCrematorium = txtCemetery.Text; objTomb.GraveNo = txtGraveNo.Text; string Erect = string.Empty; if (rdbYes.Checked) { Erect = "Yes"; } else if (rdbNo.Checked) { Erect = "No"; } objTomb.Erect = Erect; objTomb.TombStoneMessage = txtMessage.Text; objTomb.Notes = txtNotes.Text; objTomb.parlourid = ParlourId; objTomb.ModifiedUser = UserName; objTomb.InvoiceNumber = ""; objTomb.ContactPerson = txtContactPerson.Text; objTomb.ContactPersonNumber = txtContactNumber.Text; int a = client.SaveTombStone(objTomb); UploadImage(a); ShowMessage(ref lblMessage, MessageType.Success, "TombStone Details Successfully Saved."); ClearControl(); bindTombStoneList(); btnUpload.Enabled = false; btnService.Enabled = false; //GetTombStoneInvoiceNumber(); } } catch (Exception ex) { ShowMessage(ref lblMessage, MessageType.Danger, ex.Message); } } }
public void bindTombStoneUpdateList() { TombStoneModel model = client.SelectTombStoneByParlAndPki(TSID, ParlourId); if ((model == null) || (model.parlourid != ParlourId)) { Response.Write("<script>alert('Sorry!you are not authorized to perform edit on this TombStone.');</script>"); } else { btnUpload.Enabled = true; TSID = model.pkiTombstoneID; txtLastName.Text = model.LastName.ToString(); txtFirstName.Text = model.FirstName.ToString(); txtIdNumber1.Text = model.IDNumber.ToString(); if (model.DateOfApplication != null) { txtAppDate.Text = (Convert.ToDateTime(model.DateOfApplication)).ToString("dd MMM yyyy"); } txtTel.Text = model.TelNumber.ToString(); txtAdd1.Text = model.Address1.ToString(); txtadd2.Text = model.Address2.ToString(); txtadd3.Text = model.Address3.ToString(); txtCode.Text = model.Code.ToString(); txtCell.Text = model.CellNumber.ToString(); string Deceased = model.Deceased.ToString(); if (Deceased == rdbBuried.Text) { rdbBuried.Checked = true; } else { rdbCremated.Checked = true; } if (model.DateOFMemorial != null) { txtDateOfMemorial.Text = (Convert.ToDateTime(model.DateOFMemorial)).ToString("dd MMM yyyy"); } txtCemetery.Text = model.CemeterOrCrematorium.ToString(); txtGraveNo.Text = model.GraveNo.ToString(); string Erect = model.Erect.ToString(); if (Erect == rdbYes.Text) { rdbYes.Checked = true; } else { rdbNo.Checked = true; } txtMessage.Text = model.TombStoneMessage.ToString(); txtNotes.Text = model.Notes.ToString(); txtDFirstname.Text = model.DeceasedFirstName.ToString(); txtDIdNumber.Text = model.DeceasedIDNumber.ToString(); txtDLastName.Text = model.DeceasedLastName.ToString(); txtContactPerson.Text = model.ContactPerson; txtContactNumber.Text = model.ContactPersonNumber; if (model.ImagePath != null) { ImagePreview.ImageUrl = model.ImagePath; } else { ImagePreview.ImageUrl = string.Empty; } btnUpload.Visible = true; btnService.Enabled = true; btnCreateInvoice.Enabled = true; btnViewPayments.Enabled = true; } }