protected void btnsave_Click(object sender, EventArgs e)
{
try
{
DataTable dt;
REF_Return oREF_Return = new REF_Return();
DAC_Return oDAC_Return = new DAC_Return();
DAC_Rent oDAC_Rent = new DAC_Rent();
REF_Rent oREF_Rent = new REF_Rent();
oREF_Rent.ID = dropRent.SelectedValue;
dt = oDAC_Rent.SelectRentByID(oREF_Rent);
CustomerName.Text = dt.Rows[0][0].ToString();
ItemName.Text = dt.Rows[0][1].ToString();
Deposit.Text = dt.Rows[0][2].ToString();
Quentity.Text = dt.Rows[0][3].ToString();
UID = dt.Rows[0][4].ToString();
ItemID = dt.Rows[0][5].ToString();
refundAmount.Text = (Double.Parse(Deposit.Text) - Double.Parse(AdditionAmount.Text)).ToString();
oREF_Return.CusID = UID;
oREF_Return.ItemID = ItemID;
oREF_Return.Deposit = Deposit.Text;
oREF_Return.Qty = Quentity.Text;
oREF_Return.Addition = AdditionAmount.Text;
oREF_Return.Refund = refundAmount.Text;
oDAC_Return.Insert(oREF_Return);
Response.Redirect("./frmRent.aspx", true);
}
catch (Exception ex)
{
ShowMessage("Something went wrong! Please try again!");
}
}
public void LoadDataItem()
{
DataTable dt;
DAC_Rent oDAC_Rent = new DAC_Rent();
dt = oDAC_Rent.Selectstock();
if (dt.Rows.Count > 0)
{
dropItem.DataSource = null;
dropItem.DataSource = dt;
dropItem.DataTextField = "Name";
dropItem.DataValueField = "ID";
dropItem.DataBind();
}
}
private void LoadRent()
{
DataTable dt;
DAC_Rent oDAC_Rent = new DAC_Rent();
dt = oDAC_Rent.SelectRent();
if (dt.Rows.Count > 0)
{
dropRent.DataSource = null;
dropRent.DataSource = dt;
dropRent.DataTextField = "ID";
dropRent.DataValueField = "ID";
dropRent.DataBind();
}
}
protected void dropRent_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt;
DAC_Rent oDAC_Rent = new DAC_Rent();
REF_Rent oREF_Rent = new REF_Rent();
oREF_Rent.ID = dropRent.SelectedValue;
dt = oDAC_Rent.SelectRentByID(oREF_Rent);
CustomerName.Text = dt.Rows[0][0].ToString();
ItemName.Text = dt.Rows[0][1].ToString();
Deposit.Text = dt.Rows[0][2].ToString();
Quentity.Text = dt.Rows[0][3].ToString();
UID = dt.Rows[0][4].ToString();
ItemID = dt.Rows[0][5].ToString();
}
protected void Cal_Click(object sender, EventArgs e)
{
DataTable dt;
DAC_Rent oDAC_Rent = new DAC_Rent();
REF_Rent oREF_Rent = new REF_Rent();
oREF_Rent.ID = dropRent.SelectedValue;
dt = oDAC_Rent.SelectRentByID(oREF_Rent);
CustomerName.Text = dt.Rows[0][0].ToString();
ItemName.Text = dt.Rows[0][1].ToString();
Deposit.Text = dt.Rows[0][2].ToString();
Quentity.Text = dt.Rows[0][3].ToString();
UID = dt.Rows[0][4].ToString();
ItemID = dt.Rows[0][5].ToString();
refundAmount.Text = (Double.Parse(Deposit.Text) - Double.Parse(AdditionAmount.Text)).ToString();
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
REF_Rent oREF_Rent = new REF_Rent();
DAC_Rent oDAC_Rent = new DAC_Rent();
oREF_Rent.CusID = dropCusotmer.SelectedValue.ToString();;
oREF_Rent.ItemID = dropItem.SelectedValue.ToString();
oREF_Rent.Deposit = Deposit.Text;
oREF_Rent.Qty = Quentity.Text;
oREF_Rent.DaliyRate = DailyRate.Text;
oREF_Rent.TotalCost = (Double.Parse(DailyRate.Text) * Double.Parse(NumberOfDay.Text)).ToString();
oREF_Rent.NumberOfDay = NumberOfDay.Text;
int RID = oDAC_Rent.Insert(oREF_Rent);
Response.Redirect("./frmRentInvoice.aspx?ID=" + RID, true);
}catch (Exception ex)
{
ShowMessage("Something went wrong! Please try again!");
}
}
public void LoadData(REF_Rent oREF_Rent)
{
DataTable dt;
DAC_Rent oDAC_Rent = new DAC_Rent();
dt = oDAC_Rent.SelectRentDetailsByID(oREF_Rent);
String StrInnserHtml = "";
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
StrInnserHtml = StrInnserHtml + "<tr><td>" + dt.Rows[i][15].ToString() + "</td><td>" + dt.Rows[i][4].ToString() + "</td></tr>";
}
}
divInnerHtml.InnerHtml = StrInnserHtml;
Name = dt.Rows[0][12].ToString();
RentINumber = dt.Rows[0][0].ToString();
DepostiAmount = dt.Rows[0][4].ToString();
RateAmount = dt.Rows[0][5].ToString();
Total = dt.Rows[0][6].ToString();
}
public void LoadData()
{
try
{
DataTable dt;
DAC_Rent oDAC_Rent = new DAC_Rent();
dt = oDAC_Rent.SelectRentReport();
String StrInnserHtml = "";
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
StrInnserHtml = StrInnserHtml + "<tr><td>" + dt.Rows[i][2].ToString() + "</td><td>" + dt.Rows[i][4].ToString() + "</td><td>" + dt.Rows[i][5].ToString() + "</td><td>" + dt.Rows[i][6].ToString() + "</td><td>" + dt.Rows[i][7].ToString() + "</td><td>" + dt.Rows[i][8].ToString() + "</td><td>" + dt.Rows[i][9].ToString() + "</td></tr>";
}
}
divInnerHtml.InnerHtml = StrInnserHtml;
}
catch (Exception ex)
{
throw;
}
}
