protected void GetCitybyID(int id)
{
Citytbl ct = new Citytbl();
ct.CityID = id;
List <Citytbl> lst = new List <Citytbl>();
lst = objCityBl.GetCitybyId(ct).ToList();
StateBL objstatebl = new StateBL();
foreach (var el in lst)
{
hdnCityID.Value = el.CityID.ToString();
txtCity.Text = el.CityName;
Statetbl st = new Statetbl();
st.StateID = el.StateID;
List <Statetbl> lstst = new List <Statetbl>();
lstst = objstatebl.GetStateById(st).ToList();
ddlCountry.SelectedValue = lstst[0].CountryID.ToString();
GetState(lstst[0].CountryID);
ddlState.SelectedValue = el.StateID.ToString();
}
btnSave.Visible = false;
btnUpdate.Visible = true;
}
protected void GetCity()
{
Citytbl ct = new Citytbl();
List <Citytbl> lst = new List <Citytbl>();
lst = objCityBl.GetCityWithColumns(ct).ToList();
gdvCity.DataSource = lst;
gdvCity.DataBind();
btnUpdate.Visible = false;
}
protected void InsertCity()
{
Citytbl ct = new Citytbl();
ct.CityName = txtCity.Text;
ct.StateID = Convert.ToInt32(ddlState.SelectedValue);
ct.IsActive = 1;
ct.CreatedBy = 1;
ct.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
ct.UpdatedBy = 1;
ct.UpdatedDate = DateTime.Now.ToString();
List <Citytbl> lst = new List <Citytbl>();
lst = objCityBl.InsertCity(ct).ToList();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alertMessage('Data Inserted Successfully');", true);
btnSave.Visible = true;
GetCity();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Citytbl ct = new Citytbl();
ct.CityID = Convert.ToInt32(hdnCityID.Value);
ct.CityName = txtCity.Text;
ct.StateID = Convert.ToInt32(ddlState.SelectedValue);
ct.IsActive = 1;
ct.UpdatedBy = 1;
ct.UpdatedDate = DateTime.Now.ToString();
List <Citytbl> lst = new List <Citytbl>();
lst = objCityBl.UpdateCity(ct).ToList();
ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alertMessage('City Updated Successfully');", true);
Reset();
GetCity();
btnUpdate.Visible = false;
btnSave.Visible = true;
}
protected void lbtnLMarkAsActive_Click(object sender, EventArgs e)
{
LinkButton lbtn = (LinkButton)sender;
GridViewRow gvr = (GridViewRow)lbtn.NamingContainer;
var val = gvr.DataItemIndex;
var id = gvr.Cells[3].Text;
Citytbl ct = new Citytbl();
ct.CityID = Convert.ToInt32(gvr.Cells[0].Text);
if (id == "Active")
{
ct.IsActive = 0;
}
else if (id == "InActive")
{
ct.IsActive = 1;
}
objCityBl.UpdateCityIsActive(ct);
GetCity();
}
protected void GetAgencyById(int AgencyID)
{
Agentstbl agt = new Agentstbl
{
AgentID = AgencyID
};
List <Agentstbl> lstAgency = new List <Agentstbl>();
lstAgency = objRegBL.GetAgentById(agt).ToList();
foreach (var el in lstAgency)
{
hdnAgentID.Value = el.AgentID.ToString();
lblAgencyName.Text = el.AgencyName;
lblAEmail.Text = el.AgencyEmail;
lblTN.Text = el.MobileNo;
if (el.CategoryId == 0)
{
lblCategory1.Text = "B2B";
}
else if (el.CategoryId == 1)
{
lblCategory1.Text = "B2C";
}
else if (el.CategoryId == 2)
{
lblCategory1.Text = "Others";
}
if (el.IATAStatus == 1)
{
lblIATAS.Text = "Yes";
}
else if (el.IATAStatus == 2)
{
lblIATAS.Text = "No";
}
lblRN.Text = el.IATARegNo;
lblWeb.Text = el.Website;
lblFN.Text = el.FirstName;
lblLN.Text = el.LastName;
lblAddress1.Text = el.Address;
Citytbl ct = new Citytbl();
ct.CityID = el.CityId;
var ctval = objCityBL.GetCitybyId(ct);
lblCt.Text = ctval.Count() <= 0?"": ctval.First().CityName;
Statetbl st = new Statetbl();
st.StateID = el.StateID;
var sval = objStateBL.GetStateById(st);
lblSt.Text = sval.Count() <= 0 ? "" : sval.First().StateName;
Countrytbl cn = new Countrytbl();
cn.CountryID = Convert.ToInt32(el.CountryId);
var cval = objCountryBL.GetCountryById(cn);
lblCntry.Text = cval.First().CountryName;
lblPCode.Text = el.Pincode.ToString();
lblPCurrency1.Text = el.PreferredCurrency;
lblRBy.Text = el.ReferredBy;
lblAcName.Text = el.AccountsName;
lblAcEmail.Text = el.AccountsEmail;
lblAcPhoneNumber.Text = el.AccountsMobileNo;
lblmnName2.Text = el.ManagementsName;
lblmnEmail2.Text = el.ManagementsEmail;
lblmnPhoneNumber2.Text = el.ManagementsMobileNo;
lblopName1.Text = el.OperationsName;
lblopEmail1.Text = el.OperationsEmail;
lblopPhoneNumber1.Text = el.OperationsMobileNo;
List <Employeetbl> lstEmployee = new List <Employeetbl>();
Employeetbl Emply = new Employeetbl();
EmployeeBL objemplyBL = new EmployeeBL();
Emply.IsActive = 1;
lstEmployee = objemplyBL.GetEmployeeByStatus(Emply).ToList();
foreach (var cnt in lstEmployee)
{
ListItem li = new ListItem();
li.Text = cnt.FirstName + " " + cnt.LastName;
li.Value = cnt.EmpId.ToString();
ddlEmployee.Items.Add(li);
}
}
}
public IEnumerable <Citytbl> GetCityWithColumns(Citytbl ct)
{
return(objcityDA.CityAll(9, ct));
}
public IEnumerable <Citytbl> GetCityByStatus(Citytbl ct)
{
return(objcityDA.CityAll(8, ct));
}
public IEnumerable <Citytbl> UpdateCityStatus(Citytbl ct)
{
return(objcityDA.CityAll(7, ct));
}
public IEnumerable <Citytbl> UpdateCityIsActive(Citytbl ct)
{
return(objcityDA.CityAll(6, ct));
}
public IEnumerable <Citytbl> DeleteCity(Citytbl ct)
{
return(objcityDA.CityAll(5, ct));
}
public IEnumerable <Citytbl> InsertCity(Citytbl ct)
{
return(objcityDA.CityAll(3, ct));
}
public IEnumerable <Citytbl> GetCitybyId(Citytbl ct)
{
return(objcityDA.CityAll(2, ct));
}
public IEnumerable <Citytbl> GetAllCity(Citytbl ct)
{
return(objcityDA.CityAll(1, ct));
}
protected void GetAgentsById(int AgentsID)
{
Agentstbl at = new Agentstbl
{
AgentID = AgentsID
};
List <Agentstbl> lstAgents = new List <Agentstbl>();
lstAgents = objagBL.GetAgentById(at).ToList();
foreach (var el in lstAgents)
{
if (el.CategoryId == 0)
{
lblCN.Text = "B2B";
}
else if (el.CategoryId == 1)
{
lblCN.Text = "B2C";
}
else if (el.CategoryId == 2)
{
lblCN.Text = "Others";
}
lblWeb.Text = el.Website;
lblAdd.Text = el.Address;
Citytbl ct = new Citytbl();
ct.CityID = el.CityId;
var ctval = objCityBL.GetCitybyId(ct);
lblCt.Text = ctval.Count() <= 0 ? "":ctval.First().CityName;
Statetbl st = new Statetbl();
st.StateID = el.StateID;
var sval = objSBl.GetStateById(st);
lblSt.Text = sval.Count() <= 0 ? "" : sval.First().StateName;
Countrytbl cn = new Countrytbl();
cn.CountryID = Convert.ToInt32(el.CountryId);
var cval = objCountryBL.GetCountryById(cn);
lblCntry.Text = cval.Count() <= 0 ? "" : cval.First().CountryName;
Employeetbl emp = new Employeetbl();
emp.EmpId = Convert.ToInt32(el.MfbStaff);
var eval = empBL.GetEmployeeById(emp);
lblEname.Text = eval.Count() <= 0 ? "" : eval.First().FirstName + " " + eval.First().LastName;
Usertbl ut = new Usertbl();
ut.LoginUserId = el.AgentID;
var utval = objUBl.GetAgentExists(ut);
lblUName.Text = utval.Count() <= 0 ?"": utval.First().Username;
lblPWord.Text = utval.Count() <= 0 ? "" : utval.First().Password;
if (el.IATAStatus == 1)
{
lblIATAS.Text = "Yes";
}
else if (el.IATAStatus == 2)
{
lblIATAS.Text = "NO";
}
lblAgencyName.Text = el.AgencyName;
lblFN.Text = el.FirstName;
lblLName.Text = el.LastName;
lblAdd.Text = el.Address;
lblRBy.Text = el.ReferredBy;
lblIATARNo.Text = el.IATARegNo;
lblAC.Text = el.AgencyCode;
lblAEmail.Text = el.AgencyEmail;
lblTN.Text = el.MobileNo;
lblPC.Text = el.PreferredCurrency;
lblPin.Text = el.Pincode.ToString();
txtCommission1.Text = el.Commission;
lblACName.Text = el.AccountsName;
lblACEmail.Text = el.AccountsEmail;
lblACPhoneNumber.Text = el.AccountsMobileNo;
lblOPName.Text = el.OperationsName;
lblOPEmail1.Text = el.OperationsEmail;
lblOPPhoneNumber.Text = el.OperationsMobileNo;
lblMNName.Text = el.ManagementsName;
lblMNEmail.Text = el.ManagementsEmail;
lblMNPhoneNumber.Text = el.ManagementsMobileNo;
hdnAgentID.Value = el.AgentID.ToString();
}
}
protected void GetCity()
{
Citytbl ct = new Citytbl();
lst = objCityBL.GetCityWithColumns(ct).ToList();
}
public IEnumerable <Citytbl> UpdateCity(Citytbl ct)
{
return(objcityDA.CityAll(4, ct));
}
