protected void btnSaveManufacturer_ServerClick(object sender, EventArgs e)
{
ManufacturerObject obj = new ManufacturerObject();
obj.Manufacturer_Name = txtManufacturerName.Value;
ManageManufacturer manufacturerObj = new ManageManufacturer();
bool success = manufacturerObj.insert(obj, ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString);
if (success)
{
divSuccess.Visible = true;
}
else
divFailure.Visible = true;
}
protected void btnSaveManufacturer_ServerClick(object sender, EventArgs e)
{
ManufacturerObject obj = new ManufacturerObject();
obj.Manufacturer_Name = txtManufacturerName.Value;
ManageManufacturer manufacturerObj = new ManageManufacturer();
bool success = manufacturerObj.updateAManufacturer(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, obj, Convert.ToInt32(Session["rowIndex"]));
if (success)
{
divSuccess.Visible = true;
}
else
divFailure.Visible = true;
Session.Remove("rowIndex");
}
public List<SqlParameter> insertParameters(ManufacturerObject manufacturerObj)
{
List<SqlParameter> insertParamsArray = new List<SqlParameter>();
insertParamsArray.Add(new SqlParameter("@Manufacturer_Name", manufacturerObj.Manufacturer_Name));
return insertParamsArray;
}
public Boolean updateAManufacturer(string connectionString, ManufacturerObject manufacturerObj, int rowIndex)
{
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_UpdateManufacturer", insertParameters(manufacturerObj), conn);
cmdIns.Parameters.Add(new SqlParameter("@Manufacturer_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 bool insert(ManufacturerObject manufacturerObj, string connectionString)
{
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_InsertManufacturer", insertParameters(manufacturerObj), 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();
}
}