public int InsertAgent(CompetitorAgentMasterBDto objCompetitorAgentMasterBDto)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand(DALHelper.USP_ADMINISTRATION_COMPETITOR_AGENT_INSERT);
db.AddInParameter(dbCmd, "@AGENT_NAME", DbType.String, objCompetitorAgentMasterBDto.AgentName);
db.AddInParameter(dbCmd, "@AGENT_ADDRESS", DbType.String, objCompetitorAgentMasterBDto.AgentAddress);
db.AddInParameter(dbCmd, "@CITY_ID", DbType.Int32, objCompetitorAgentMasterBDto.CityId);
db.AddInParameter(dbCmd, "@STATE_ID", DbType.Int32, objCompetitorAgentMasterBDto.StateId);
db.AddInParameter(dbCmd, "@COUNTRY_ID", DbType.Int32, objCompetitorAgentMasterBDto.CountryId);
db.AddInParameter(dbCmd, "@PHONE_NO", DbType.String, objCompetitorAgentMasterBDto.Phone);
db.AddInParameter(dbCmd, "@OWNER_COMPANY_ID", DbType.Int32, objCompetitorAgentMasterBDto.OwnerCompanyId);
db.AddInParameter(dbCmd, "@USER_ID", DbType.Int32, objCompetitorAgentMasterBDto.UserId);
db.AddOutParameter(dbCmd, "@ISEXIST", DbType.Int32, 1);
db.ExecuteNonQuery(dbCmd);
Result = Convert.ToInt32(db.GetParameterValue(dbCmd, "@ISEXIST"));
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{
throw ex;
}
}
finally
{
DALHelper.Destroy(ref dbCmd);
}
return Result;
}
protected void acbAgent_SaveClick(object sender, EventArgs e)
{
objCompetitorAgentMasterBDto = new CompetitorAgentMasterBDto();
try
{
int result = 0;
objCompetitorAgentMasterDal = new CompetitorAgentMasterDal();
switch (acbAgent.SaveButton.CommandName)
{
case "Save":
SaveCompetitor();
pnlAddNewMode.Visible = false;
acbAgent.EditableMode = false;
BindGrid();
break;
case "Update":
Update();
break;
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{ throw ex; }
}
}
private void Update()
{
try
{
int result = 0;
objCompetitorAgentMasterDal = new CompetitorAgentMasterDal();
objCompetitorAgentMasterBDto = new CompetitorAgentMasterBDto();
objCompetitorAgentMasterBDto.AgentName = txtAgentName.Text.Trim();
objCompetitorAgentMasterBDto.AgentAddress = txtAddress.Text.Trim();
objCompetitorAgentMasterBDto.CityId = Convert.ToInt32(radCmbCity.SelectedValue);
objCompetitorAgentMasterBDto.StateId = Convert.ToInt32(radCmbState.SelectedValue);
objCompetitorAgentMasterBDto.CountryId = Convert.ToInt32(radCmbCountry.SelectedValue);
objCompetitorAgentMasterBDto.Phone = txtphone.Text.Trim();
objCompetitorAgentMasterBDto.OwnerCompanyId = objAuthorizationBDto.UserSelectedCompanyId;
objCompetitorAgentMasterBDto.UserId = objAuthorizationBDto.UserProfile.UserId;
objCompetitorAgentMasterBDto.AgentId = Convert.ToInt32(ViewState["AgentId"]);
result = objCompetitorAgentMasterDal.UpdateAgent(objCompetitorAgentMasterBDto);
if (result >= 1)
{
pnlAddNewMode.Visible = false;
acbAgent.EditableMode = false;
BindGrid();
Reset();
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Save].ToString());
Master.MessageCssClass = "successMessage";
}
else
{
Master.DisplayMessage("Agent Name Already Exist");
//Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Save].ToString());
Master.MessageCssClass = "errorMessage";
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{ throw ex; }
}
}