private void LoadSearchCity()
{
int?CityId = ddlSearchState.zToInt();
CU.FillDropdown(ref ddlSearchCity, new City()
{
StateId = ddlSearchState.zToInt(),
eStatus = (int)eStatus.Active
}.Select(new City()
{
CityId = 0, CityName = ""
}), "-- All City --", CS.CityId, CS.CityName);
try { ddlSearchCity.SelectedValue = CityId.ToString(); }
catch { }
if (!IsPostBack)
{
ddlSearchCity.SelectedValue = "0";
}
if (!IsPostBack && !string.IsNullOrEmpty(Request.QueryString[CS.CityId.Encrypt()]))
{
try
{
ddlSearchCity.SelectedValue = Request.QueryString[CS.CityId.Encrypt()].ToString().Decrypt();
}
catch { }
}
}
private void LoadSearchCountry()
{
int?CountryId = ddlSearchCountry.zToInt();
CU.FillDropdown(ref ddlSearchCountry, new Country()
{
eStatus = (int)eStatus.Active
}.Select(), "-- All Country --", CS.CountryId, CS.CountryName);
try { ddlSearchCountry.SelectedValue = CountryId.ToString(); }
catch { }
int SetStateId = 0;
if (!IsPostBack && !string.IsNullOrEmpty(Request.QueryString[CS.CityId.Encrypt()]))
{
string CityId = Request.QueryString[CS.CityId.Encrypt()].ToString().Decrypt();
if (CityId.zIsInteger(false))
{
var dtCity = new Query()
{
CityId = CityId.zToInt()
}.Select(eSP.qry_City);
if (dtCity.Rows.Count > 0)
{
ddlSearchCountry.SelectedValue = dtCity.Rows[0][CS.CountryId].ToString();
SetStateId = dtCity.Rows[0][CS.StateId].zToInt().Value;
}
}
}
LoadSearchState(SetStateId);
}
private void LoadSearchState()
{
int?StateId = ddlSearchState.zToInt();
CU.FillDropdown(ref ddlSearchState, new State()
{
CountryId = ddlSearchCountry.zToInt(),
eStatus = (int)eStatus.Active
}.Select(), "-- All State --", CS.StateId, CS.StateName);
try { ddlSearchState.SelectedValue = StateId.ToString(); }
catch { }
if (!IsPostBack)
{
ddlSearchState.SelectedValue = "0";
}
if (!IsPostBack && !string.IsNullOrEmpty(Request.QueryString[CS.StateId.Encrypt()]))
{
try
{
ddlSearchState.SelectedValue = Request.QueryString[CS.StateId.Encrypt()].ToString().Decrypt();
}
catch { }
}
}
private void LoadCountry()
{
CU.FillDropdown(ref ddlCountry, new Query()
{
eStatus = (int)eStatus.Active
}.Select(eSP.qry_Country), "-- Select Country --", CS.CountryId, CS.CountryName);
}
private void LoadSearchCountry()
{
int?CountryId = ddlSearchCountry.zToInt();
CU.FillDropdown(ref ddlSearchCountry, new Country()
{
eStatus = (int)eStatus.Active
}.Select(), "-- All Country --", CS.CountryId, CS.CountryName);
try { ddlSearchCountry.SelectedValue = CountryId.ToString(); }
catch { }
if (!IsPostBack && !string.IsNullOrEmpty(Request.QueryString[CS.StateId.Encrypt()]))
{
string StateId = Request.QueryString[CS.StateId.Encrypt()].ToString().Decrypt();
if (StateId.zIsInteger(false))
{
var lstState = new State()
{
StateId = StateId.zToInt()
}.SelectList <State>();
if (lstState.Count > 0)
{
ddlSearchCountry.SelectedValue = lstState[0].CountryId.ToString();
}
}
}
LoadSearchState();
}
private void LoadState()
{
CU.FillDropdown(ref ddlState, new Query()
{
CountryId = ddlCountry.zToInt(), eStatus = (int)eStatus.Active
}.Select(eSP.qry_State), "-- Select State --", CS.StateId, CS.StateName);
}
private void LoadCity()
{
CU.FillDropdown(ref ddlCity, new Query()
{
StateId = ddlState.zToInt(), eStatus = (int)eStatus.Active
}.Select(eSP.qry_City), "-- Select City --", CS.CityId, CS.CityName);
}
private void LoadSearchState(int?SetStateId)
{
int?StateId = ddlSearchState.zToInt();
CU.FillDropdown(ref ddlSearchState, new State()
{
CountryId = ddlSearchCountry.zToInt(),
eStatus = (int)eStatus.Active
}.Select(), "-- All State --", CS.StateId, CS.StateName);
try { ddlSearchState.SelectedValue = StateId.ToString(); }
catch { }
if (!IsPostBack)
{
ddlSearchState.SelectedValue = "0";
}
if (SetStateId.HasValue)
{
try { ddlSearchState.SelectedValue = SetStateId.ToString(); }
catch { }
}
LoadSearchCity();
}
private void LoadFirm()
{
var dtFirm = new Query()
{
OrganizationId = ddlOrganization.zToInt(), eStatus = (int)eStatus.Active
}.Select(eSP.qry_Firm);
CU.FillDropdown(ref ddlFirm, dtFirm, "-- Select Firm --", CS.FirmId, CS.FirmName);
}
private void LoadBankAccount()
{
var dtBankAccount = new BankAccount()
{
OrganizationId = CU.GetOrganizationId()
}.Select();
CU.FillDropdown(ref ddlBankAccount, dtBankAccount, "-- Select BankAccount --", CS.BankAccountId, CS.BankAccountName);
}
private void LoadPriceList()
{
var dtPriceList = new Query()
{
FirmId = ddlFirm.zToInt(), eStatus = (int)eStatus.Active
}.Select(eSP.qry_PriceList);
CU.FillDropdown(ref ddlPriceList, dtPriceList, "-- Price List --", CS.PriceListId, CS.PriceListName);
}
private void LoadParentUser()
{
var dtUser = new Query()
{
FirmId = ddlFirm.zToInt(), eStatus = (int)eStatus.Active
}.Select(eSP.qry_User);
CU.FillDropdown(ref ddlParentUser, dtUser, "-- Parent User --", CS.UsersId, CS.Name);
}
private void LoadOrganization()
{
var dtOrganization = new Query()
{
eStatus = (int)eStatus.Active
}.Select(eSP.qry_Organization);
CU.FillDropdown(ref ddlOrganization, dtOrganization, "-- Select Organization --", CS.OrganizationId, CS.OrganizationName);
}
private void LoadCallType()
{
var dtCallType = new Query()
{
eStatus = (int)eStatus.Active, FirmId = lblFirmId.zToInt()
}.Select(eSP.qry_CallType);
var dtSearchCallType = dtCallType.Copy();
CU.FillDropdown(ref ddlCallType, dtCallType, "-- Select CallType --", CS.CallTypeId, CS.CallTypeName);
CU.FillDropdown(ref ddlSearchCallType, dtSearchCallType, "-- All CallType --", CS.CallTypeId, CS.CallTypeName);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var dtDesignation = new Query()
{
eDesignationNot = (int)eDesignation.SystemAdmin, eStatus = (int)eStatus.Active
}.Select(eSP.qry_Designation);
CU.FillDropdown(ref ddlDesignation, dtDesignation, "-- Select Designation --", CS.DesignationId, CS.DesignationName);
}
}
private void LoadSearchUser()
{
var dtUser = new Query()
{
FirmId = lblFirmId.zToInt(), eStatus = (int)eStatus.Active
}.Select(eSP.qry_User);
CU.FillDropdown(ref ddlSearchUser, dtUser, "-- All User --", CS.UsersId, CS.Name);
try { ddlSearchUser.SelectedValue = CU.GetUsersId().ToString(); }
catch { }
}
private void LoadUser()
{
var dtUser = new Query()
{
FirmId = ddlFirm.zIsSelect() ? ddlFirm.zToInt() : (int?)null, eStatus = (int)eStatus.Active
}.Select(eSP.qry_User);
CU.FillDropdown(ref ddlUser, dtUser, "-- All User --", CS.UsersId, CS.Name);
try { ddlUser.SelectedValue = lblUsersId.Text; }
catch { }
}
private void LoadCountry()
{
int?CountryId = ddlCountry.zToInt();
CU.FillDropdown(ref ddlCountry, new Country()
{
eStatus = (int)eStatus.Active
}.Select(), "-- Select Country --", CS.CountryId, CS.CountryName);
try { ddlCountry.SelectedValue = CountryId.ToString(); }
catch { }
}
private void LoadFirm()
{
var dtFirm = new Query()
{
OrganizationId = lblOrganizationId.zToInt(), eStatus = (int)eStatus.Active
}.Select(eSP.qry_Firm);
CU.FillDropdown(ref ddlFirm, dtFirm, "-- All Firm --", CS.FirmId, CS.FirmName);
try { ddlFirm.SelectedValue = lblFirmId.Text; }
catch { }
}
private void LoadState()
{
int?SateId = ddlState.zToInt();
CU.FillDropdown(ref ddlState, new State()
{
CountryId = ddlCountry.zToInt(),
eStatus = (int)eStatus.Active
}.Select(), "-- Select State --", CS.StateId, CS.StateName);
try { ddlState.SelectedValue = SateId.ToString(); }
catch { }
}
private void LoadCourier()
{
var dtCourier = new Courier()
{
OrganizationId = lblOrganizationId.zToInt(), eStatus = (int)eStatus.Active
}.Select(new Courier()
{
CourierId = 0, CourierName = string.Empty
});
CU.FillDropdown(ref ddlSearchCourier, dtCourier, string.Empty, CS.CourierId, CS.CourierName);
CU.FillDropdown(ref ddlCourier, dtCourier, "-- Select Courier --", CS.CourierId, CS.CourierName);
CU.FillDropdown(ref ddlCourierExcel, dtCourier, string.Empty, CS.CourierId, CS.CourierName);
}
private void LoadFirm()
{
var dtFirm = new Query()
{
OrganizationId = ddlOrganization.zIsSelect() ? ddlOrganization.zToInt() : null, eStatus = (int)eStatus.Active
}.Select(eSP.qry_Firm);
CU.FillDropdown(ref ddlFirm, dtFirm, "-- Select Firm --", CS.FirmId, CS.FirmName);
try
{
ddlFirm.SelectedValue = CU.GetFirmId().ToString();
}
catch { }
}
private void LoadOrganization()
{
var dtOrganization = new Query()
{
eStatus = (int)eStatus.Active
}.Select(eSP.qry_Organization);
CU.FillDropdown(ref ddlOrganization, dtOrganization, "-- Select Organization --", CS.OrganizationId, CS.OrganizationName);
try
{
ddlOrganization.SelectedValue = CU.GetOrganizationId().ToString();
}
catch { }
}
private void LoadSearchCity()
{
int?CityId = ddlSearchState.zToInt();
CU.FillDropdown(ref ddlSearchCity, new City()
{
StateId = ddlSearchState.zToInt(),
eStatus = (int)eStatus.Active
}.Select(new City()
{
CityId = 0, CityName = ""
}), "-- All City --", CS.CityId, CS.CityName);
try { ddlSearchCity.SelectedValue = CityId.ToString(); }
catch { }
}
