public void Delete(REF_Service oREF_Service) { DBConnecton db; db = new DBConnecton(); string sqlQuery; SqlCommand oSqlCommand; try { sqlQuery = "DELETE FROM `mainservice` WHERE `mainservice`.`idmainservice` = " + oREF_Service.ID + ""; //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 cmd.ExecuteNonQuery(); //close connection db.CloseConnection(); } } catch (Exception ex) { throw ex; } }
public void Insert(REF_Service oREF_Service) { DBConnecton db; db = new DBConnecton(); string sqlQuery; SqlCommand oSqlCommand; try { sqlQuery = "INSERT INTO `mainservice` (`idmainservice`, `service_id`, `service_name`, `service_duration`, `price_per_hour`, `description`)" + " VALUES(NULL, '" + oREF_Service.ServiceiD + "', '" + oREF_Service.Service_Name + "', '" + oREF_Service.Service_Duration + "', '" + oREF_Service.Price_Per_Hour + "', '" + oREF_Service.Description + "');"; //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 cmd.ExecuteNonQuery(); //close connection db.CloseConnection(); } } catch (Exception ex) { throw ex; } }
public void Update(REF_Service oREF_Service) { DBConnecton db; db = new DBConnecton(); string sqlQuery; SqlCommand oSqlCommand; try { sqlQuery = "UPDATE `mainservice` SET `service_id` = '" + oREF_Service.ServiceiD + "', `service_name` = '" + oREF_Service.Service_Name + "', " + "`service_duration` = '" + oREF_Service.Service_Duration + "', `price_per_hour` = '" + oREF_Service.Price_Per_Hour + "', `description` = '" + oREF_Service.Description + "' WHERE `mainservice`.`idmainservice` = " + oREF_Service.ID + ""; //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 cmd.ExecuteNonQuery(); //close connection db.CloseConnection(); } } catch (Exception ex) { throw ex; } }
protected void btnsubmitoffers_Click(object sender, EventArgs e) { DAC_BookServices oDAC_BookServices = new DAC_BookServices(); REF_BookServices oREF_BookServices = new REF_BookServices(); oREF_BookServices.CusID = Convert.ToInt32(dropCusotmer.Value); oREF_BookServices.ServiceID = Convert.ToInt32(dropService.Value); oREF_BookServices.OfferID = Convert.ToInt32(dropoffers.Value); DataTable dt; DAV_Offers oDAV_Offers = new DAV_Offers(); REF_Offers oREF_Offers = new REF_Offers(); oREF_Offers.ID = Convert.ToInt32(dropoffers.Value); dt = oDAV_Offers.SelectOffersByID(oREF_Offers); Double OfferPrice = Double.Parse(dt.Rows[0][6].ToString()); oREF_BookServices.OfferPrice = dt.Rows[0][6].ToString(); DAC_Service oDAC_Service = new DAC_Service(); REF_Service oREF_Service = new REF_Service(); oREF_Service.ID = Convert.ToInt32(dropService.Value); dt = oDAC_Service.SelectServiceByID(oREF_Service); Double ServicePrice = Double.Parse(dt.Rows[0][4].ToString()); Double Total = ServicePrice - OfferPrice; oREF_BookServices.ServicePrice = dt.Rows[0][3].ToString(); oREF_BookServices.TotalPrice = Total.ToString(); oDAC_BookServices.Insert(oREF_BookServices); LoadData(); }
protected void btndelete_Click(object sender, EventArgs e) { DAC_Service oDAC_Service = new DAC_Service(); REF_Service oREF_Service = new REF_Service(); oREF_Service.ID = Convert.ToInt32(ServiceID); oREF_Service.ServiceiD = serviceCode.Text; oREF_Service.Service_Name = ServiceName.Text; oREF_Service.Service_Duration = ServiceDuration.Text; oREF_Service.Price_Per_Hour = PricePerHour.Text; oREF_Service.Description = Description.Text; oDAC_Service.Delete(oREF_Service); Response.Redirect("./frmService.aspx", true); }
public void LoadData(REF_Service oREF_Service) { try { DataTable dt; DAC_Service oDAC_Service = new DAC_Service(); dt = oDAC_Service.SelectServiceByID(oREF_Service); serviceCode.Text = dt.Rows[0][1].ToString(); ServiceName.Text = dt.Rows[0][2].ToString(); ServiceDuration.Text = dt.Rows[0][3].ToString(); PricePerHour.Text = dt.Rows[0][4].ToString(); Description.Text = dt.Rows[0][5].ToString(); } catch (Exception ex) { throw; } }
protected void btnsubmitService_Click(object sender, EventArgs e) { try { DAC_Service oDAC_Service = new DAC_Service(); REF_Service oREF_Service = new REF_Service(); oREF_Service.ServiceiD = serviceCode.Text; oREF_Service.Service_Name = ServiceName.Text; oREF_Service.Service_Duration = ServiceDuration.Text; oREF_Service.Price_Per_Hour = PricePerHour.Text; oREF_Service.Description = Description.Text; oDAC_Service.Insert(oREF_Service); ShowMessage("Data Insert successfully!"); LoadData(); } catch (Exception ex) { ShowMessage("Something went wrong! Please try again!"); } }
protected void Button1_Click(object sender, EventArgs e) { DataTable dt; DAV_Offers oDAV_Offers = new DAV_Offers(); REF_Offers oREF_Offers = new REF_Offers(); oREF_Offers.ID = Convert.ToInt32(dropoffers.Value); dt = oDAV_Offers.SelectOffersByID(oREF_Offers); Double OfferPrice = Double.Parse(dt.Rows[0][6].ToString()); DAC_Service oDAC_Service = new DAC_Service(); REF_Service oREF_Service = new REF_Service(); oREF_Service.ID = Convert.ToInt32(dropService.Value); dt = oDAC_Service.SelectServiceByID(oREF_Service); Double ServicePrice = Double.Parse(dt.Rows[0][4].ToString()); Double Total = ServicePrice - OfferPrice; lbltotal.InnerText = "Total Cost Rs." + Total.ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { btndelete.Visible = false; btnupdate.Visible = false; if (Request.QueryString["ID"] != null) { btndelete.Visible = true; btnupdate.Visible = true; btnsubmitService.Visible = false; ServiceID = Request.QueryString["ID"]; REF_Service oREF_Service = new REF_Service(); oREF_Service.ID = Convert.ToInt32(ServiceID); LoadData(oREF_Service); } else { } } ServiceID = Request.QueryString["ID"]; LoadData(); }
public DataTable SelectServiceByID(REF_Service oREF_Service) { DBConnecton db; db = new DBConnecton(); DataTable dataTable = new DataTable(); string query = "SELECT * FROM `mainservice` WHERE `idmainservice` = '" + oREF_Service.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); } }