public DataTable getLcodetails(string username, string catid, string operid)
{
string StrQry = "SELECT a.msoid, a.msoname, a.distid, a.distname, a.lcoid, a.lcocode, a.lconame, a.transdt, a.usercnt, a.cityname, a.statename,a.companyname, a.distributor, a.subdistributor" +
" FROM view_lcopre_userdet_det a";
if (catid == "2")
{
StrQry += " where a.msoid ='" + operid + "'";
}
if (catid == "5")
{
StrQry += " where a.distid ='" + operid + "'";
}
if (catid == "3" || catid == "11")
{
StrQry += " where a.lcoid ='" + operid + "'";
}
if (catid == "10")
{
StrQry += " where a.hoid ='" + operid + "'";
}
StrQry += " order by a.transdt desc";
cls_data_rptUserdetailsLcowise data = new cls_data_rptUserdetailsLcowise();
DataTable dt = data.GetLcodet(username, StrQry);
return(dt);
}
public DataTable getLcoSubRight_Details(string username, string catid, string operid)
{
string StrQry = "select * FROM view_UserBtn_Right where var_access_username='******' ";
cls_data_rptUserdetailsLcowise data = new cls_data_rptUserdetailsLcowise();
DataTable dt = data.GetLcodet(username, StrQry);
return(dt);
}
// ------ Added By RP on 25.12.2017 from LCO Sub User Details Dropdown
public DataTable getLcoSub(string username, string catid, string operid)
{
string StrQry = "select username,fname||' '||mname||' '||lname Name from view_Lcopre_user_det where operid='" + operid + "' and flag='Executive' ";
cls_data_rptUserdetailsLcowise data = new cls_data_rptUserdetailsLcowise();
DataTable dt = data.GetLcodet(username, StrQry);
return(dt);
}
public DataTable getLcouserdetails(string username, string operid, string Showall, string catid, string operatorid)
{
string StrQry = "";
StrQry = "SELECT a.userid, a.operid, a.username, a.userowner, a.fname, a.mname, a.lname, a.addr, a.code, a.brmpoid, a.ststeid, a.cityid, a.email, " +
" a.mobno, a.compcode, a.accno, a.insby, a.insdt, a.flag, a.balance, a.lcocode, a.DASAREA " +
" FROM view_Lcopre_user_det a";
if (Showall == "1")
{
if (catid == "3" || catid == "11")
{
StrQry += " where a.operid ='" + operatorid + "'";
}
else
{
StrQry += " where a.operid ='" + operid + "'";
}
}
else
{
if (catid == "2")
{
StrQry += " where a.parentid='" + operatorid + "'";
}
else if (catid == "5")
{
StrQry += " where a.distid='" + operatorid + "'";
}
else if (catid == "10")
{
StrQry += " where a.hoid='" + operatorid + "'";
}
}
cls_data_rptUserdetailsLcowise data = new cls_data_rptUserdetailsLcowise();
DataTable dt = data.GetLcodet(username, StrQry);
return(dt);
}
