public DataTable SelectRentDetailsByID(REF_Rent oREF_Rent)
{
DBConnecton db;
db = new DBConnecton();
DataTable dataTable = new DataTable();
string query = "SELECT * FROM `tblrent` R, users C,tblitem I WHERE R.`CusID`=C.user_id AND R.`ItemID`= I.ID AND R.`ID` = " + oREF_Rent.ID + "";
//Open connection
if (db.OpenConnection() == true)
{
//Create Command
MySqlCommand cmd = new MySqlCommand(query, db.getConnetion());
//Create a data reader and Execute the command
MySqlDataReader dataReader = cmd.ExecuteReader();
DataSet ds = new DataSet();
ds.Tables.Add(dataTable);
ds.EnforceConstraints = false;
dataTable.Load(dataReader);
dataReader.Close();
//close Connection
db.CloseConnection();
//return list to be displayed
return(dataTable);
}
else
{
return(dataTable);
}
}
public int Insert(REF_Rent oREF_Rent)
{
int RID = 0;
DBConnecton db;
db = new DBConnecton();
string sqlQuery;
SqlCommand oSqlCommand;
try
{
sqlQuery = "INSERT INTO `tblrent` (`ID`, `CusID`, `ItemID`, `Qty`, `Deposit`, `Daliy Rate`, `Total Cost`, `NumberOfDay`, `Status`) "
+ "VALUES (NULL, '" + oREF_Rent.CusID + "', '" + oREF_Rent.ItemID + "', '" + oREF_Rent.Qty + "', '" + oREF_Rent.Deposit + "', '" + oREF_Rent.DaliyRate + "', '" + oREF_Rent.TotalCost + "', '" + oREF_Rent.NumberOfDay + "', '0');";
//open connection
if (db.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(sqlQuery, db.getConnetion());
//Execute command
RID = cmd.ExecuteNonQuery();
long id = cmd.LastInsertedId;
RID = Convert.ToInt32(id);
//close connection
db.CloseConnection();
}
}
catch (Exception ex)
{
throw ex;
}
return(RID);
}
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!");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["ID"] != null)
{
DateTime dateTime = DateTime.Today;
Date = "Date :" + dateTime.ToString("d");
REF_Rent oREF_Rent = new REF_Rent();
oREF_Rent.ID = Request.QueryString["ID"];
LoadData(oREF_Rent);
}
}
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();
}
