protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
int AId = 0;
Session.Remove("Prop_Action");
if (Request.QueryString["BillsServices_ID"] != null)
{
AId = Convert.ToInt32(Request.QueryString["BillsServices_ID"]);
Session["Prop_Action"] = "U";
}
if (Session["Prop_Action"] == "U")
{
// int proID= int.Parse(Session["Pro_ID"].ToString());
BillsServices bills = new BillsServices();
bills.BillsServices_ID = AId;
bills.SelectOne();
hidBillsID.Value = bills.BillsServices_ID.ToString();
txtBillsServicesName.Text = bills.Name.ToString();
txtDescription.Text = bills.Description.ToString();
txtQty.Text = bills.Quantity.ToString();
txtPrice.Text = bills.Price.ToString();
}
}
}
private void BindBillServices()
{
BillsServices bs = new BillsServices();
DataTable table = bs.SelectAll();
drpBillServices.DataSource = table;
drpBillServices.DataTextField = "Name";
drpBillServices.DataValueField = "BillsServices_ID";
drpBillServices.DataBind();
drpBillServices.Items.Insert(0, new ListItem("Select an Bills & Service....", "-1"));
}
private void GetBillServices(ref DataTable billsServicesTbl)
{
if (Session["BillServiceTable"] == null)
{
BillsServices bs = new BillsServices();
billsServicesTbl = bs.SelectAll();
Session.Add("BillServiceTable", billsServicesTbl);
}
else
{
billsServicesTbl = (DataTable)Session["BillServiceTable"];
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
BillsServices bills = new BillsServices();
bills.Name = txtBillsServicesName.Text;
bills.Description = txtDescription.Text;
bills.Quantity = int.Parse(txtQty.Text);
bills.Price = SqlMoney.Parse(txtPrice.Text);
if (bills.Price <= 0)
{
lblMsg.Text = "Price cannot be 0 or less.";
lblMsg.ForeColor = Color.Red;
return;
}
bills.CreatedUser = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name);
bool retval = false;
if (Session["Prop_Action"] == "U")
{
bills.BillsServices_ID = Int32.Parse(hidBillsID.Value);
bills.LastModifiedUser = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name);
bills.LastModifiedDate = DateTime.Now;
retval = bills.Update();
}
else
{
bills.CreatedUser = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name);;
bills.CreatedDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Now);
retval = bills.Insert();
}
lblMsg.Text = "Data Saved successfully.";
lblMsg.ForeColor = Color.Green;
if (retval)
{
Response.Redirect("BillsServices.aspx", true);
}
else
{
lblMsg.Text = bills.ErrorDesc.ToString();
}
}
catch (Exception ex)
{
lblMsg.Text = "Data not Saved .";
lblMsg.ForeColor = Color.Red;
}
}
protected void drpBillServices_SelectedIndexChanged(object sender, EventArgs e)
{
if (drpBillServices.SelectedValue == "-1")
{
lblStatus.Text = "Please select an Amenity";
return;
}
lblStatus.Text = "";
SqlMoney price = 0;
BillsServices bs = new BillsServices();
bs.BillsServices_ID = Int32.Parse(drpBillServices.SelectedValue);
bs.SelectOne();
price = bs.Price;
lblPrice.Text = price.ToString();
calculateTotal();
}
private void DeleteBillsService(int billsServiceId)
{
BillsServices bs = new BillsServices();
bs.BillsServices_ID = billsServiceId;
bs.SelectOne();
if (bs.Delete())
{
BindGridView();
}
else
{
if (bs.ErrorCode == -10)
{
lblMsg.Text = " Cannot Delete. There is a Checked-In Reservation using this Bills & Service";
lblMsg.ForeColor = Color.Red;
return;
}
}
BindGridView();
}
private void calculateTotal()
{
int qty = 0;
if (!string.IsNullOrEmpty(txtQuantity.Text))
{
try
{
qty = int.Parse(txtQuantity.Text);
}
catch (Exception ex) { }
SqlMoney price = 0;
if (drpBillServices.SelectedValue != "-1")
{
BillsServices bs = new BillsServices();
bs.BillsServices_ID = int.Parse(drpBillServices.SelectedValue);
bs.SelectOne();
price = bs.Price;
SqlMoney totalAmt = qty * price;
txtPrice.Text = totalAmt.ToString();
}
}
}
private DataTable GetBillsAndServices()
{
DataTable table = new BillsServices().SelectAll();
return(table);
}
