public int SaveOrUpdate(BusinessSubType objBusinessSubType)
{
SqlConnection con = null;
SqlCommand com = null;
SqlTransaction trans = null;
try
{
con = ConnectionHelper.getConnection();
trans = con.BeginTransaction();
com = new SqlCommand();
com.Connection = con;
com.Transaction = trans;
if (objBusinessSubType.BusinessSubTypeID == 0)
{
objBusinessSubType.BusinessSubTypeID = ConnectionHelper.GetID(con, trans, "BusinessSubTypeID", "BusinessSubType");
com.CommandText = "Insert Into BusinessSubType(CompanyID, UserID, ModifiedDate, BusinessSubTypeID, Name, BusinessTypeID) "
+ " Values(@CompanyID, @UserID, @ModifiedDate, @BusinessSubTypeID, @Name, @BusinessTypeID)";
}
else
{
com.CommandText = "Update BusinessSubType SET CompanyID = @CompanyID, UserID =@UserID, ModifiedDate = @ModifiedDate, Name = @Name, BusinessTypeID = @BusinessTypeID WHERE BusinessSubTypeID = @BusinessSubTypeID";
}
com.Parameters.Add("@CompanyID", SqlDbType.Int).Value = LogInInfo.CompanyID;
com.Parameters.Add("@UserID", SqlDbType.Int).Value = LogInInfo.UserID;
com.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = LogInInfo.ModifiedDate;
com.Parameters.Add("@BusinessSubTypeID", SqlDbType.Int).Value = objBusinessSubType.BusinessSubTypeID;
com.Parameters.Add("@Name", SqlDbType.VarChar, 100).Value = objBusinessSubType.Name;
com.Parameters.Add("@BusinessTypeID", SqlDbType.Int).Value = objBusinessSubType.BusinessTypeID;
com.ExecuteNonQuery();
trans.Commit();
ConnectionHelper.closeConnection(con);
}
catch (Exception Ex)
{
if (trans != null)
{
trans.Rollback();
}
throw new Exception("Can not save or update" + Ex.Message);
}
return(objBusinessSubType.BusinessSubTypeID);
}
private BusinessSubType CreateObject(IDataReader objReader)
{
BusinessSubType objBusinessSubType = new BusinessSubType();
NullManager reader = new NullManager(objReader);
try
{
objBusinessSubType.BusinessSubTypeID = reader.GetInt32("BusinessSubTypeID");
objBusinessSubType.Name = reader.GetString("Name");
objBusinessSubType.BusinessTypeID = reader.GetInt32("BusinessTypeID");
objBusinessSubType.CompanyID = reader.GetInt32("CompanyID");
objBusinessSubType.UserID = reader.GetInt32("UserID");
objBusinessSubType.ModifiedDate = reader.GetDateTime("ModifiedDate");
}
catch (Exception Ex)
{
throw new Exception("Error while creating object" + Ex.Message);
}
return(objBusinessSubType);
}
