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