public static WaterTreatmentEquipment GetByWTEID(int wte_id) { WaterTreatmentEquipment wte = new WaterTreatmentEquipment(); MyDBConnection myConn = new MyDBConnection(); SqlConnection conn = new SqlConnection(); SqlDataReader dr; SqlCommand cmd = null; string sql = "Select * from AquaOne.dbo.WaterTreatmentEquipment where wte_id = @wte_id"; try { // Open the connection conn = myConn.OpenDB(); cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@wte_id", SqlDbType.Int).Value = wte_id; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (dr.Read()) { wte = FillDataRecord(dr); } dr.Close(); cmd.Dispose(); } finally { //close the connection myConn.CloseDB(conn); } return(wte); }
public static int Save(WaterTreatmentEquipment wTEquipment) { int result; MyDBConnection myConn = new MyDBConnection(); SqlConnection conn = new SqlConnection(); try { conn = myConn.OpenDB(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "dbo.InsertUpdateWTE"; if (wTEquipment.WTE_ID == -1) { cmd.Parameters.Add("@WTEID", SqlDbType.Int).Value = DBNull.Value; } else { cmd.Parameters.Add("@WTEID", SqlDbType.Int).Value = wTEquipment.WTE_ID; } cmd.Parameters.Add("@AccountID", SqlDbType.Int).Value = wTEquipment.AccountID; cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = wTEquipment.Description; cmd.Parameters.Add("@ProductCode", SqlDbType.VarChar).Value = wTEquipment.ProductCode; cmd.Parameters.Add("@Manufacturer", SqlDbType.VarChar).Value = wTEquipment.Manufacturer; cmd.Parameters.Add("@DateObtained", SqlDbType.DateTime).Value = wTEquipment.DateObtained; cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = wTEquipment.CreatedDate; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = wTEquipment.ModifiedDate; cmd.Parameters.Add("@CreatedBy", SqlDbType.VarChar).Value = wTEquipment.CreatedBy; cmd.Parameters.Add("@ModifiedBy", SqlDbType.VarChar).Value = wTEquipment.ModifiedBy; DbParameter returnValue = cmd.CreateParameter(); returnValue.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(returnValue); cmd.ExecuteNonQuery(); result = Convert.ToInt32(returnValue.Value); cmd.Dispose(); } finally { myConn.CloseDB(conn); } return(result); }
protected void gviewWTE_RowEditing(object sender, GridViewEditEventArgs e) { //show the modal popup //load the formview //get the id int wteID = Convert.ToInt32((gviewWTE.Rows[e.NewEditIndex].FindControl("hdnWTEID") as HiddenField).Value.ToString()); WaterTreatmentEquipment wte = WTEManager.GetByWTEID(wteID); WaterTreatmentEquipmentList wteList = new WaterTreatmentEquipmentList(); wteList.Add(wte); fviewUpdateWTE.DataSource = wteList; fviewUpdateWTE.DataBind(); this.modPopUpShowUpdateWTE.Show(); }
protected void lnkUpdateWTE_OnCommand(object sender, CommandEventArgs e) { //get details from formview hdnWteID WaterTreatmentEquipment w = new WaterTreatmentEquipment(); w.WTE_ID = Convert.ToInt32((fviewUpdateWTE.FindControl("hdnWteID") as HiddenField).Value.ToString()); w.Description = (fviewUpdateWTE.FindControl("txtDescription") as TextBox).Text; w.Manufacturer = (fviewUpdateWTE.FindControl("txtManufacturer") as TextBox).Text; w.ProductCode = (fviewUpdateWTE.FindControl("txtProductCode") as TextBox).Text; w.DateObtained = Convert.ToDateTime((fviewUpdateWTE.FindControl("txtDateObtained") as TextBox).Text); w.ModifiedBy = User.Identity.Name.ToString(); //update the record WTEManager.Save(w); //re-display the gridview DisplayWTE(); }
protected void lnkAddWTE_OnCommand(object sender, CommandEventArgs e) { //add record to db //get date from form WaterTreatmentEquipment w = new WaterTreatmentEquipment(); w.AccountID = _accountID; w.ProductCode = (fviewWTE.FindControl("txtProductCode") as TextBox).Text; w.Description = (fviewWTE.FindControl("txtDescription") as TextBox).Text; w.Manufacturer = (fviewWTE.FindControl("txtManufacturer") as TextBox).Text; w.DateObtained = Convert.ToDateTime((fviewWTE.FindControl("txtDateObtained") as TextBox).Text); w.CreatedBy = User.Identity.Name.ToString(); w.WTE_ID = WTEManager.Save(w); ClearWTEFields(); //populate the gridview DisplayWTE(); }
private static WaterTreatmentEquipment FillDataRecord(IDataRecord dr) { WaterTreatmentEquipment wTEquipment = new WaterTreatmentEquipment(); wTEquipment.WTE_ID = dr.GetInt32(dr.GetOrdinal("WTE_ID")); wTEquipment.AccountID = dr.GetInt32(dr.GetOrdinal("AccountID")); wTEquipment.Description = dr.GetString(dr.GetOrdinal("Description")); wTEquipment.ProductCode = dr.GetString(dr.GetOrdinal("ProductCode")); if (!dr.IsDBNull(dr.GetOrdinal("ProductCode"))) { wTEquipment.ProductCode = dr.GetString(dr.GetOrdinal("ProductCode")); } wTEquipment.Manufacturer = dr.GetString(dr.GetOrdinal("Manufacturer")); wTEquipment.DateObtained = dr.GetDateTime(dr.GetOrdinal("DateObtained")); wTEquipment.CreatedDate = dr.GetDateTime(dr.GetOrdinal("CreatedDate")); wTEquipment.ModifiedDate = dr.GetDateTime(dr.GetOrdinal("ModifiedDate")); wTEquipment.CreatedBy = dr.GetString(dr.GetOrdinal("CreatedBy")); wTEquipment.ModifiedBy = dr.GetString(dr.GetOrdinal("ModifiedBy")); return(wTEquipment); }
public static int Save(WaterTreatmentEquipment wte) { return(WTEDB.Save(wte)); }