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