protected void btnSaveServiceProvider_ServerClick(object sender, EventArgs e)
{
ServiceProviderObject obj = new ServiceProviderObject();
obj.SP_Name = txtServiceProviderName.Value;
obj.SP_address= txtServiceProviderAddress.Value;
obj.Telephone = txtServiceProviderTelephone.Value;
obj.Category = Convert.ToInt32(lstCategory.Value);
obj.Disable = chkBoxModelDisable.Checked;
ManageServiceProvider ManageServiceProviderObj = new ManageServiceProvider();
bool success = ManageServiceProviderObj.insert(obj, ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString);
if (success)
{
divSuccess.Visible = true;
}
else
divFailure.Visible = true;
}
protected void btnSaveServiceProvider_ServerClick(object sender, EventArgs e)
{
ServiceProviderObject obj = new ServiceProviderObject();
obj.SP_Name = txtServiceProviderName.Value;
obj.SP_address = txtServiceProviderAddress.Value;
obj.Telephone = txtServiceProviderTelephone.Value;
obj.Category = Convert.ToInt32(lstCategory.Items.FindByValue(lstCategory.Value).Value);
obj.Disable = chkBoxModelDisable.Checked;
ManageServiceProvider ServiceProviderObj = new ManageServiceProvider();
bool success = ServiceProviderObj.updateAServiceProvider(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, obj, Convert.ToInt32(Session["rowIndex"]));
if (success)
{
divSuccess.Visible = true;
}
else
divFailure.Visible = true;
Session.Remove("rowIndex");
}
public Boolean updateAServiceProvider(string connectionString, ServiceProviderObject serviceProviderObj, int rowIndex)
{
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_UpdateServiceProvider", insertParameters(serviceProviderObj), conn);
cmdIns.Parameters.Add(new SqlParameter("@SP_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(ServiceProviderObject ServiceProviderObj)
{
List<SqlParameter> insertParamsArray = new List<SqlParameter>();
insertParamsArray.Add(new SqlParameter("@SP_Name", ServiceProviderObj.SP_Name));
insertParamsArray.Add(new SqlParameter("@category", ServiceProviderObj.Category));
insertParamsArray.Add(new SqlParameter("@SP_Address", ServiceProviderObj.SP_address));
insertParamsArray.Add(new SqlParameter("@Telephone", ServiceProviderObj.Telephone));
insertParamsArray.Add(new SqlParameter("@Disable", ServiceProviderObj.Disable));
return insertParamsArray;
}
public bool insert(ServiceProviderObject ServiceProviderObj, string connectionString)
{
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_InsertServiceProvider", insertParameters(ServiceProviderObj), 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();
}
}