public static LOCATIONGROUP GetLOCATIONGROUPByID(int id)
{
LOCATIONGROUP lOCATIONGROUP = new LOCATIONGROUP();
SqlLOCATIONGROUPProvider sqlLOCATIONGROUPProvider = new SqlLOCATIONGROUPProvider();
lOCATIONGROUP = sqlLOCATIONGROUPProvider.GetLOCATIONGROUPByID(id);
return(lOCATIONGROUP);
}
private void loadLocation()
{
List <LOCATION> locations = new List <LOCATION>();
if (Session["userType"] != null && (Session["lOCATION"] != null || Session["aGENT"] != null))
{
if (Session["userType"].ToString() == "Location")
{
LOCATIONGROUP lOCATIONGROUP = new LOCATIONGROUP();
lOCATIONGROUP = (LOCATIONGROUP)Session["lOCATION"];
hfLoggedinLocationID.Value = lOCATIONGROUP.LOCATIONGROUPID.ToString();
if (ddlAgent.SelectedItem.Text != "All Agents")
{
locations = LOCATIONManager.GetAllLOCATIONsByAgentIDnGroupID(int.Parse(ddlAgent.SelectedItem.Value), int.Parse(hfLoggedinLocationID.Value));
}
else
{
locations = LOCATIONManager.GetAllLOCATIONsByGroupID(int.Parse(hfLoggedinLocationID.Value));
}
//locations = LOCATIONManager.GetAllLOCATIONsByGroupID(int.Parse(hfLoggedinLocationID.Value));
//trLocation.Visible = false;
}
else if (Session["userType"].ToString() == "Agent")
{
AGENT aGENT = (AGENT)Session["aGENT"];
hfAgentID.Value = aGENT.AGENTID.ToString();
trLocation.Visible = true;
if (hfAgentID.Value == "4")
{
if (ddlAgent.SelectedItem.Text != "All Agents")
{
locations = LOCATIONManager.GetAllLOCATIONsByAgentID(int.Parse(ddlAgent.SelectedItem.Value));
}
else
{
locations = LOCATIONManager.GetAllLOCATIONs();
}
}
else
{
locations = LOCATIONManager.GetAllLOCATIONsByAgentID(int.Parse(hfAgentID.Value));
}
}
dlLocation.DataSource = locations;
dlLocation.DataBind();
tblSearchByRefCode.Visible = false;
}
else
{
Session.RemoveAll(); Response.Redirect("LogInPage.aspx");
}
}
private void loadLogin()
{
if (User.Identity.IsAuthenticated && Session["userType"] != null && (Session["aGENT"] != null || Session["lOCATION"] != null))
{
if (Session["userType"].ToString() == "Location")
{
LOCATIONGROUP lOCATIONGROUP = new LOCATIONGROUP();
lOCATIONGROUP = (LOCATIONGROUP)Session["lOCATION"];
a_locationReport.Visible = true;
a_transferMoney.Visible = false;
a_foodItems.Visible = false;
a_editTransfer.Visible = true;
a_dailyReport.Visible = false;
//a_dailyReport.HRef = "ReportLocationWiseDaily.aspx";
a_compliance.Visible = false;
a_agentWiseReport.Visible = false;
a_agentCommReport.Visible = false;
a_administrator.Visible = false;
}
else
{
AGENT aGENT = new AGENT();
aGENT = (AGENT)Session["aGENT"];
if (aGENT.AGENTID == 4) //for admin
{
//a_transferMoney.Visible = false;
//a_dailyReport.HRef = "ReportAgentWiseDaily.aspx";
}
else
{
a_transferMoney.Visible = true;
a_locationReport.Visible = true;
a_foodItems.Visible = true;
a_editTransfer.Visible = true;
a_dailyReport.Visible = true;
//a_dailyReport.HRef = "ReportLocationWiseDaily.aspx";
a_compliance.Visible = false;
a_agentWiseReport.Visible = false;
a_agentCommReport.Visible = false;
a_administrator.Visible = false;
}
}
}
else
{
Session.RemoveAll(); Response.Redirect("LogInPage.aspx");
}
}
public bool UpdateLOCATIONGROUP(LOCATIONGROUP lOCATIONGROUP)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateLOCATIONGROUP", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@LOCATIONGROUPID", SqlDbType.Int).Value = lOCATIONGROUP.LOCATIONGROUPID;
cmd.Parameters.Add("@ADDEDDATE", SqlDbType.DateTime).Value = lOCATIONGROUP.ADDEDDATE;
cmd.Parameters.Add("@GROUPNAME", SqlDbType.NVarChar).Value = lOCATIONGROUP.GROUPNAME;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public LOCATIONGROUP GetLOCATIONGROUPFromReader(IDataReader reader)
{
try
{
LOCATIONGROUP lOCATIONGROUP = new LOCATIONGROUP
(
(int)reader["LOCATIONGROUPID"],
(DateTime)reader["ADDEDDATE"],
reader["GROUPNAME"].ToString()
);
return(lOCATIONGROUP);
}
catch (Exception ex)
{
return(null);
}
}
protected void lbSelect_Click(object sender, EventArgs e)
{
try
{
LinkButton linkButton = new LinkButton();
linkButton = (LinkButton)sender;
int id;
id = Convert.ToInt32(linkButton.CommandArgument);
LOCATIONGROUP locationGroup = LOCATIONGROUPManager.GetLOCATIONGROUPByID(id);
if (locationGroup != null)
{
txtGROUPNAME.Text = locationGroup.GROUPNAME;
hdnGroupID.Value = locationGroup.LOCATIONGROUPID.ToString();
btnAdd.Visible = false;
btnUpdate.Visible = true;
}
}
catch { }
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
LOCATIONGROUP lOCATIONGROUP = new LOCATIONGROUP();
lOCATIONGROUP.ADDEDDATE = DateTime.Now;
lOCATIONGROUP.GROUPNAME = txtGROUPNAME.Text;
int resutl = LOCATIONGROUPManager.InsertLOCATIONGROUP(lOCATIONGROUP);
if (resutl > 0)
{
lblErr.Text = "successfully added!";
btnClear_Click(null, null);
showLOCATIONGROUPGrid();
}
}
catch (Exception ex)
{
lblErr.Text = ex.Message;
}
}
private void showLOCATIONMAPPINGGrid()
{
gvLOCATIONMAPPING.DataSource = LOCATIONMAPPINGManager.GetAllLOCATIONMAPPINGs();
gvLOCATIONMAPPING.DataBind();
foreach (GridViewRow gvr in gvLOCATIONMAPPING.Rows)
{
Label lblLOCATIONID = gvr.FindControl("lblLOCATIONID") as Label;
Label lblLOCATIONGROUPID = gvr.FindControl("lblLOCATIONGROUPID") as Label;
LOCATION location = LOCATIONManager.GetLOCATIONByID(int.Parse(lblLOCATIONID.Text));
if (location != null)
{
lblLOCATIONID.Text = location.COUNTRY + ", " + location.CITY + ", " + location.BRANCH;
}
LOCATIONGROUP locationGroup = LOCATIONGROUPManager.GetLOCATIONGROUPByID(int.Parse(lblLOCATIONGROUPID.Text));
if (locationGroup != null)
{
lblLOCATIONGROUPID.Text = locationGroup.GROUPNAME;
}
}
}
private void loadLogin()
{
if (Session["userType"] != null && (Session["aGENT"] != null || Session["lOCATION"] != null))
{
if (Session["userType"].ToString() == "Location")
{
LOCATIONGROUP lOCATIONGROUP = new LOCATIONGROUP();
lOCATIONGROUP = (LOCATIONGROUP)Session["lOCATION"];
lblAgentName.Text = lOCATIONGROUP.GROUPNAME.ToString();
}
else
{
AGENT aGENT = new AGENT();
aGENT = (AGENT)Session["aGENT"];
lblAgentName.Text = aGENT.AGENTNAME.ToString();
}
}
else
{
Session.RemoveAll(); Response.Redirect("LogInPage.aspx");
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
LOCATIONGROUP lOCATIONGROUP = new LOCATIONGROUP();
lOCATIONGROUP = LOCATIONGROUPManager.GetLOCATIONGROUPByID(Int32.Parse(hdnGroupID.Value));
LOCATIONGROUP tempLOCATIONGROUP = new LOCATIONGROUP();
tempLOCATIONGROUP.LOCATIONGROUPID = lOCATIONGROUP.LOCATIONGROUPID;
tempLOCATIONGROUP.ADDEDDATE = DateTime.Now;
tempLOCATIONGROUP.GROUPNAME = txtGROUPNAME.Text;
bool result = LOCATIONGROUPManager.UpdateLOCATIONGROUP(tempLOCATIONGROUP);
if (result == true)
{
lblErr.Text = "successfully updated!";
btnClear_Click(null, null);
showLOCATIONGROUPGrid();
}
}
catch (Exception ex)
{
lblErr.Text = ex.Message;
}
}
public static bool UpdateLOCATIONGROUP(LOCATIONGROUP lOCATIONGROUP)
{
SqlLOCATIONGROUPProvider sqlLOCATIONGROUPProvider = new SqlLOCATIONGROUPProvider();
return(sqlLOCATIONGROUPProvider.UpdateLOCATIONGROUP(lOCATIONGROUP));
}
public static int InsertLOCATIONGROUP(LOCATIONGROUP lOCATIONGROUP)
{
SqlLOCATIONGROUPProvider sqlLOCATIONGROUPProvider = new SqlLOCATIONGROUPProvider();
return(sqlLOCATIONGROUPProvider.InsertLOCATIONGROUP(lOCATIONGROUP));
}
