/// <summary>
/// Insert Title detail.
/// </summary>
/// <param name="xmlData">Data that converted into xml format.</param>
/// <returns>Returns 1 and 0; (1 indicates successful operation).</returns>
public int InsertPayment(LookupBDto objLookupBDto)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand(DALHelper.USP_BOOKING_PAYMENT_MODE_INSERT);
db.AddInParameter(dbCmd, "@PAYMENT_MODE_NAME", DbType.String, objLookupBDto.LookupName);
db.AddInParameter(dbCmd, "@CREATED_BY", DbType.Int32, objLookupBDto.UserProfile.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;
}
/// <summary>
/// Insert SecurityQuestion detail.
/// </summary>
/// <param name="xmlData">Data that converted into xml format.</param>
/// <returns>Returns 1 and 0; (1 indicates successful operation).</returns>
public int InsertSecurityQuestion(LookupBDto SecurityQuestion)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand(DALHelper.USP_ADMINISTRATION_SECURITY_QUESTION_INSERT);
db.AddInParameter(dbCmd, "@SECURITY_QUESTION_DESC", DbType.String, SecurityQuestion.LookupName);
db.AddInParameter(dbCmd, "@CREATED_BY", DbType.Int32, SecurityQuestion.UserProfile.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;
}
/// <summary>
/// Update Output CheckList detail.
/// </summary>
/// <param name="xmlData">Data that converted into xml format.</param>
/// <returns>Returns 1 and 0; (1 indicates successful operation).</returns>
public int UpdateOutputCheckList(LookupBDto objLookupBDto)
{
Database db = null;
DbCommand dbCmd = null;
int result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand("USP_ADMINISTRATOR_COMMON_OP_CL_UPDATE");
db.AddInParameter(dbCmd, "@OUTPUT_CHECK_LIST_ID", DbType.Int32, objLookupBDto.LookupId);
db.AddInParameter(dbCmd, "@OUTPUT_CHECK_LIST_NAME", DbType.String, objLookupBDto.LookupName);
db.AddInParameter(dbCmd, "@MODIFIED_BY", DbType.Int32, objLookupBDto.UserProfile.UserId);
result = db.ExecuteNonQuery(dbCmd);
}
catch (Exception ex)
{
bool reThrow;
reThrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (reThrow)
{
throw ex;
}
}
finally
{
DALHelper.Destroy(ref dbCmd);
}
return result;
}
/// <summary>
/// Insert Report detail.
/// </summary>
/// <param name="xmlData">Data that converted into xml format.</param>
/// <returns>Returns 1 and 0; (1 indicates successful operation).</returns>
public int InsertReport(LookupBDto objLookupBDto)
{
Database db = null;
DbCommand dbCmd = null;
int result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand("USP_ADMINISTRATOR_COMMON_REPORT_MASTER_INSERT");
db.AddInParameter(dbCmd, "@REPORT_NAME", DbType.String, objLookupBDto.LookupName);
db.AddInParameter(dbCmd, "@CREATED_BY", DbType.Int32, objLookupBDto.LookupId);
result = db.ExecuteNonQuery(dbCmd);
}
catch (Exception ex)
{
bool reThrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (reThrow)
{
throw ex;
}
}
finally
{
DALHelper.Destroy(ref dbCmd);
}
return result;
}
private void Save()
{
try
{
int result = 0;
objRegionLookup = new RegionLookupDal();
objLookupBDto = new LookupBDto();
objLookupBDto.LookupName = txtRegionShortName.Text;
objLookupBDto.Description = txtRegionLongName.Text;
objLookupBDto.UserProfile = objAuthorizationBDto.UserProfile;
result = objRegionLookup.InsertRegion(objLookupBDto);
if (result >= 1)
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Save].ToString());
Master.MessageCssClass = "successMessage";
bisEdit = false;
}
else
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Save].ToString());
Master.MessageCssClass = "errorMessage";
}
BindGrid();
Reset();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{ throw ex; }
}
}
private void SaveInqFollowMode()
{
try
{
int result = 0;
objInquiriesFollowsModeLookup = new InquiriesFollowsModeLookupDal();
LookupBDto objReligion = new LookupBDto();
objLookUpBDto = new LookupBDto();
objLookUpBDto.LookupName = txtInquiriesFollowsMode.Text;
objLookUpBDto.UserProfile = objAuthorizationBDto.UserProfile;
result = objInquiriesFollowsModeLookup.InsertInquiriesFollowsMode(objLookUpBDto);
if (result >= 1)
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Save].ToString());
Master.MessageCssClass = "successMessage";
}
else
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Save].ToString());
Master.MessageCssClass = "errorMessage";
}
BindGrid();
Reset();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{ throw ex; }
}
}
protected void acbOutputCheckList_SaveClick(object sender, EventArgs e)
{
try
{
int result = 0;
objAddressTypeLookup = new AddressTypeLookupDal();
switch (acbOutputCheckList.SaveButton.CommandName)
{
case "Save":
Save();
pnlAddNewMode.Visible = false;
acbOutputCheckList.EditableMode = false;
break;
case "Update":
try
{
objAddressTypeLookup = new AddressTypeLookupDal();
objLookupBDto = new LookupBDto();
if (ViewState[PageConstants.vsItemIndexes] != null)
{
htItemIndex = (Hashtable)(ViewState[PageConstants.vsItemIndexes]);
}
int OutputCheckListId = 0;
for (int i = 0; i < htItemIndex.Count; i++)
{
objAuthorizationBDto = new AuthorizationBDto();
objLookupBDto = new LookupBDto();
Label lblgrdOutputCheckList = (Label)radgrdOutputCheckList.Items[Convert.ToInt32(htItemIndex[i])].FindControl("lblgrdOutputCheckListEdit");
TextBox txtgrdOutputCheckList = (TextBox)radgrdOutputCheckList.Items[Convert.ToInt32(htItemIndex[i])].FindControl("txtgrdOutputCheckList");
OutputCheckListId = int.Parse(lblgrdOutputCheckList.Text);
objAddressTypeLookup = new AddressTypeLookupDal();
objLookupBDto = new LookupBDto();
objLookupBDto.LookupName = txtgrdOutputCheckList.Text;
objLookupBDto.UserProfile = objAuthorizationBDto.UserProfile;
objLookupBDto.LookupId = OutputCheckListId;
result = objAddressTypeLookup.UpdateOutputCheckList(objLookupBDto);
}
if (result >= 1)
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Save].ToString());
Master.MessageCssClass = "successMessage";
}
else
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Save].ToString());
Master.MessageCssClass = "errorMessage";
}
BindGrid();
Reset();
}
catch (Exception ex) { }
result = objAddressTypeLookup.UpdateOutputCheckList(objLookupBDto);
if (result == 1)
{
acbOutputCheckList.DefaultMode = true;
Master.DisplayMessage(ConfigurationSettings.AppSettings["UpdateRecord"].ToString());
Master.MessageCssClass = "successMessage";
if (ViewState[PageConstants.vsItemIndexes] != null)
htItemIndex = (Hashtable)ViewState[PageConstants.vsItemIndexes];
for (int i = 0; i < htItemIndex.Count; i++)
radgrdOutputCheckList.Items[Convert.ToInt32(htItemIndex[i])].Edit = false;
bisEdit = false;
ViewState[PageConstants.vsItemIndexes] = null;
BindGrid();
}
else
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Update].ToString());
Master.MessageCssClass = "errorMessage";
}
break;
}
objAddressTypeLookup = new AddressTypeLookupDal();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{ throw ex; }
}
}
private void Update()
{
try
{
int result = 0;
objAddressTypeLookup = new AddressTypeLookupDal();
objLookupBDto = new LookupBDto();
objLookupBDto.LookupName = txtOutputCheckListName.Text;
objLookupBDto.UserProfile = objAuthorizationBDto.UserProfile;
objLookupBDto.LookupId = 0;
string CityName = txtOutputCheckListName.Text;
Int32 modifyBy = Convert.ToInt32(objAuthorizationBDto.UserProfile);
result = objAddressTypeLookup.UpdateOutputCheckList(objLookupBDto);
if (result >= 1)
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Save].ToString());
Master.MessageCssClass = "successMessage";
}
else
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Save].ToString());
Master.MessageCssClass = "errorMessage";
}
BindGrid();
Reset();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{ throw ex; }
}
}
