private void ExtraCostGridView_CellClick(object sender, DataGridViewCellEventArgs e) { if (ExtraCostGridView.CurrentRow != null) { selectedExtraCostModel = (ExtraCostModel)ExtraCostGridView.CurrentRow.DataBoundItem; costId.Text = selectedExtraCostModel.ExtraCostId.ToString(); costDescTextbox.Text = selectedExtraCostModel.CostType; amountTextbox.Text = selectedExtraCostModel.Amount.ToString(); } }
//Extracost Delete public int DeleteExtraCost(ExtraCostModel extraCostModel) { String query = "DELETE FROM extracost WHERE `CostId` = " + extraCostModel.ExtraCostId + ";"; using (MySqlConnection sqlCon = new MySqlConnection(conString)) { using (MySqlCommand cmd = new MySqlCommand(query, sqlCon)) { sqlCon.Open(); int k = cmd.ExecuteNonQuery(); sqlCon.Close(); return(k); } } }
// extracost update public int UpdateExtraCost(ExtraCostModel extraCostModel) { String query = @"UPDATE extracost SET CostType= @CostType , Amount= @Amount Where CostId=" + extraCostModel.ExtraCostId + ";"; using (MySqlConnection sqlConn = new MySqlConnection(conString)) { using (MySqlCommand cmd = new MySqlCommand(query, sqlConn)) { sqlConn.Open(); cmd.Parameters.AddWithValue("@CostType", extraCostModel.CostType); cmd.Parameters.AddWithValue("@Amount", extraCostModel.Amount); // cmd.Parameters.AddWithValue("@Date", extraCostModel.CostDate); int isUpdate = cmd.ExecuteNonQuery(); sqlConn.Close(); return(isUpdate); } } }
//Extra Cost insert public int ExtraCostInsert(ExtraCostModel extraCostModel) { string query = @"INSERT INTO extracost (CostType, Amount, Date) VALUES(@CostType, @Amount, @Date);"; using (MySqlConnection sqlConn = new MySqlConnection(conString)) { using (MySqlCommand cmd = new MySqlCommand(query, sqlConn)) { sqlConn.Open(); cmd.Parameters.AddWithValue("@CostType", extraCostModel.CostType); cmd.Parameters.AddWithValue("@Amount", extraCostModel.Amount); cmd.Parameters.AddWithValue("@Date", extraCostModel.CostDate); int IsInserted = cmd.ExecuteNonQuery(); sqlConn.Close(); return(IsInserted); } } }
//bind all Extracost in to a list public List <ExtraCostModel> FillExtraCostGrid() { using (MySqlConnection sqlConn = new MySqlConnection(conString)) { sqlConn.Open(); String query = "SELECT * FROM extracost; "; MySqlCommand cmd = new MySqlCommand(query, sqlConn); MySqlDataReader mySqlDataReader = cmd.ExecuteReader(); List <ExtraCostModel> extraCostModels = new List <ExtraCostModel>(); while (mySqlDataReader.Read()) { ExtraCostModel extraCostModel = new ExtraCostModel(); extraCostModel.ExtraCostId = (int)mySqlDataReader["CostId"]; extraCostModel.CostType = mySqlDataReader["CostType"].ToString(); extraCostModel.Amount = Convert.ToDecimal(mySqlDataReader["Amount"].ToString()); extraCostModel.CostDate = Convert.ToDateTime(mySqlDataReader["Date"].ToString()); extraCostModels.Add(extraCostModel); } mySqlDataReader.Close(); sqlConn.Close(); return(extraCostModels); } }
//Extracost delete call public int DeleteExtraCost(ExtraCostModel extraCostModel) { return(costGateway.DeleteExtraCost(extraCostModel)); }
//Extracost update call public int ExtraCostUpdate(ExtraCostModel extraCostModel) { int IsUpdate = costGateway.UpdateExtraCost(extraCostModel); return(IsUpdate); }
//Extracost Insert call public int ExtraCostInsert(ExtraCostModel extraCostModel) { int Isinsert = costGateway.ExtraCostInsert(extraCostModel); return(Isinsert); }