protected void btnSaveModel_ServerClick(object sender, EventArgs e) { ModelObject obj = new ModelObject(); obj.Model_Name = txtModelName.Value; obj.Vehicle_Type = lstVehicleType.Value; obj.Manufacturer_Name = lstManufacturerName.Value; obj.Disable = chkBoxModelDisable.Checked; ManageModel modelObj = new ManageModel(); bool success = modelObj.insert(obj, ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString); if (success) { divSuccess.Visible = true; } else divFailure.Visible = true; }
protected void btnSaveModel_ServerClick(object sender, EventArgs e) { ModelObject obj = new ModelObject(); obj.Manufacturer_Name = lstManufacturerName.Value; obj.Model_Name = txtModelName.Value; obj.Vehicle_Type = lstVehicleType.Value; obj.Disable = chkBoxModelDisable.Checked; ManageModel ModelObj = new ManageModel(); bool success = ModelObj.updateAModel(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, obj, Convert.ToInt32(Session["rowIndex"])); if (success) { divSuccess.Visible = true; } else divFailure.Visible = true; Session.Remove("rowIndex"); }
public Boolean updateAModel(string connectionString, ModelObject modelObj, int rowIndex) { try { conn = DBUtility.createConnection(connectionString); SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_UpdateModel", insertParameters(modelObj), conn); cmdIns.Parameters.Add(new SqlParameter("@Model_ID", rowIndex)); int rowsUpdated = cmdIns.ExecuteNonQuery(); cmdIns.Dispose(); DBUtility.Close(conn); conn.Dispose(); if (rowsUpdated > 0) { return true; } else return false; } catch (Exception ex) { throw new Exception(ex.ToString(), ex); } finally { DBUtility.Close(conn); conn.Dispose(); } }
public List<SqlParameter> insertParameters(ModelObject modelObj) { List<SqlParameter> insertParamsArray = new List<SqlParameter>(); insertParamsArray.Add(new SqlParameter("@Model_Name", modelObj.Model_Name)); insertParamsArray.Add(new SqlParameter("@Vehicle_Type", modelObj.Vehicle_Type)); insertParamsArray.Add(new SqlParameter("@Manufacturer_Name", modelObj.Manufacturer_Name)); insertParamsArray.Add(new SqlParameter("@Disable", modelObj.Disable)); return insertParamsArray; }
public bool insert(ModelObject modelObj, string connectionString) { try { conn = DBUtility.createConnection(connectionString); SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_InsertModel", insertParameters(modelObj), conn); int rowsUpdated = cmdIns.ExecuteNonQuery(); // cmdIns.Parameters.Clear(); // cmdIns.CommandText = "SELECT @@IDENTITY"; // // Get the last inserted id. // int insertID = Convert.ToInt32(cmdIns.ExecuteScalar()); cmdIns.Dispose(); DBUtility.Close(conn); conn.Dispose(); if (rowsUpdated > 0) { return true; } else return false; } catch (Exception ex) { throw new Exception(ex.ToString(), ex); } finally { DBUtility.Close(conn); conn.Dispose(); } }