private void LoadDealers()
{
if (DatabaseHandler.requestDealers)
{
DatabaseHandler.dealers = DealerDB.GetAllDealers();
DatabaseHandler.requestDealers = false;
}
}
private void DeleteDealer()
{
if (DatabaseHandler.removeDealer != null)
{
var dealer = DatabaseHandler.dealers[(int)DatabaseHandler.dealerInRangeIndex];
DealerDB.RemoveDealer(dealer);
DatabaseHandler.removeDealer = null;
UIHelper.ShowNotification("Removed " + dealer.Name + " - Reload the mod");
}
}
public int SaveDealer(DealerUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
{
int DealerID = 0;
bool flagTransation = true;
DealerDB objDB = new DealerDB();
objDB.Code = objUI.Code;
objDB.Dealer = objUI.Dealer;
objDB.RegionID = objUI.RegionID;
objDB.IsActive = objUI.IsActive;
objDB.Id = objUI.Id;
objDB.CheckID = objUI.CheckID;
objDB.City = objUI.City;
objDB.InstallerName = objUI.InstallerName;
objDB.IsOperatingDealer = objUI.IsOperatingDealer;
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
DealerManager objManager = new DealerManager();
DealerID = objManager.SaveDealer(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
return DealerID;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
public int SaveDealer(DealerDB objDB, SqlTransaction objTrans)
{
int DealerID = 0;
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
if (objDB.CheckID == 0)
{
objCmd.CommandText = "usp_SaveDealer";
}
else
{
objCmd.CommandText = "usp_UpdateDealer";
objCmd.Parameters.AddWithValue("@Id", objDB.Id);
}
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@Dealer", objDB.Dealer);
objCmd.Parameters.AddWithValue("@Code", objDB.Code);
objCmd.Parameters.AddWithValue("@RegionID", objDB.RegionID);
objCmd.Parameters.AddWithValue("@City", objDB.City);
objCmd.Parameters.AddWithValue("@InstallerName", objDB.InstallerName);
objCmd.Parameters.AddWithValue("@IsActive", objDB.IsActive);
objCmd.Parameters.AddWithValue("@IsOperatingDealer", objDB.IsOperatingDealer);
objCmd.Parameters.AddWithValue("@DealerID", SqlDbType.Int);
objCmd.Parameters["@DealerID"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
DealerID = Convert.ToInt32(objCmd.Parameters["@DealerID"].Value);
return DealerID;
}
catch (Exception ex)
{
throw ex;
}
}
