public Hashtable GetTransations(Hashtable htAddPlanParams, string username, string catid, string operator_id)
{
string whereString = "";
string from = htAddPlanParams["from"].ToString();
string to = htAddPlanParams["to"].ToString();
string msoid = htAddPlanParams["msoid"].ToString();
string showall = htAddPlanParams["showall"].ToString();
string searchParamStr = "";
if (from != null && from != "")
{
whereString += " dt >= '" + from + "' ";
searchParamStr += " <b>Transaction From : </b> " + from;
}
if (to != null && to != "")
{
whereString += " and dt <= '" + to + "' ";
searchParamStr += " <b>Transaction To : </b> " + to;
}
//if (catid == "2")
//{
//}
//else if (catid == "5")
//{
// whereString += " and DISTID= '" + operator_id + "' ";
//}
//if (catid == "3")
//{
// whereString += " and OPERID= '" + operator_id + "' ";
//}
//else
//{
if (catid == "11")
{
whereString += " and clustid= '" + operator_id + "' ";
}
else
{
whereString += " and PARENTID= '" + msoid + "' ";
}
// }
//else if (catid == "10")
//{
// whereString += " and hoid= '" + operator_id + "' ";
//}
/*else
* {
* }*/
Cls_Data_RptAddPlan_JV objDataRptAddPlan = new Cls_Data_RptAddPlan_JV();
Hashtable htResponse = new Hashtable();
htResponse.Add("htResponse", objDataRptAddPlan.GetTransations(whereString, username));
htResponse.Add("ParamStr", searchParamStr);
return(htResponse);
}
public Hashtable GetTransationsMSO(Hashtable htAddPlanParams, string username, string catid, string operator_id)
{
string whereString = "";
string from = htAddPlanParams["from"].ToString();
string to = htAddPlanParams["to"].ToString();
string Transactiontype = htAddPlanParams["Transactiontype"].ToString();
string Payterm = htAddPlanParams["Payterm"].ToString();
string plantype = htAddPlanParams["plantype"].ToString();
string searchParamStr = "";
if (from != null && from != "")
{
whereString += " dt >= '" + from + "' ";
searchParamStr += " <b>Transaction From : </b> " + from;
}
if (to != null && to != "")
{
whereString += " and dt <= '" + to + "' ";
searchParamStr += " <b>Transaction To : </b> " + to;
}
if (Transactiontype != "All")
{
whereString += " and planflag in('" + Transactiontype + "') ";
}
if (plantype != "All")
{
whereString += " and PlanType = '" + plantype + "' ";
}
if (Payterm != "All")
{
whereString += " and PAYTERM = '" + Payterm + "' ";
}
//if (catid == "2")
//{
// whereString += " and PARENTID= '" + operator_id + "' ";
//}
//else if (catid == "5")
//{
// whereString += " and DISTID= '" + operator_id + "' ";
//}
/*else if (catid == "3")
* {
* whereString += " and OPERID= '" + operator_id + "' ";
* }*/
if (catid == "10")
{
whereString += " and hoid= '" + operator_id + "' ";
}
/*else
* {
* }*/
Cls_Data_RptAddPlan_JV objDataRptAddPlan = new Cls_Data_RptAddPlan_JV();
Hashtable htResponse = new Hashtable();
htResponse.Add("htResponse", objDataRptAddPlan.GetTransationsMSO(whereString, username));
htResponse.Add("ParamStr", searchParamStr);
return(htResponse);
}
public Hashtable GetTransationsDet(Hashtable htAddPlanParams2, string username2)
{
string whereString = "";
string from = htAddPlanParams2["from"].ToString();
string to = htAddPlanParams2["to"].ToString();
string uid = htAddPlanParams2["uid"].ToString();
string loperid = htAddPlanParams2["loperid"].ToString();
string parentid = htAddPlanParams2["parentid"].ToString();
// string Msoid = htAddPlanParams2["msoperid"].ToString();
string search_type = htAddPlanParams2["search"].ToString().Trim();
string txtsearch = htAddPlanParams2["txtsearch"].ToString().Trim();
string showall = htAddPlanParams2["showall"].ToString();
string Plantype = htAddPlanParams2["Plantype"].ToString().Trim();
string Transtype = htAddPlanParams2["Transtype"].ToString();
string Payterm = htAddPlanParams2["Payterm"].ToString();
string searchParamStr = "";
if (from != null && from != "")
{
whereString += " dt >= '" + from + "' ";
searchParamStr += " <b>Transaction From : </b> " + from;
}
if (to != null && to != "")
{
whereString += " and dt <= '" + to + "' ";
searchParamStr += " <b>Transaction To : </b> " + to;
}
if (uid != null && uid != "" && showall != "0" && showall != "1")
{
whereString += " and uname = '" + uid + "' ";
}
if (showall == "1")
{
whereString += " and parentid='" + parentid.ToString() + "'";
}
if (showall == "2")
{
whereString += " and loperid = '" + loperid + "' ";
}
if (Transtype != "All" && Transtype != "")
{
whereString += " and flag in('" + Transtype + "') ";
}
if (Plantype != "All" && Plantype != "")
{
whereString += " and plntyp = '" + Plantype + "' ";
}
if (Payterm != "All" && Payterm != "")
{
whereString += " and payterm = '" + Payterm + "' ";
}
if (showall != null && showall != "")
{
whereString += " ";
}
if (txtsearch.Length > 0)
{
if (search_type == "0")
{
whereString += @" and upper(""Account No"")= upper('" + txtsearch + "')";
}
else if (search_type == "1")
{
whereString += @" and upper(vc)= upper('" + txtsearch + "')";
}
else if (search_type == "2")
{
whereString += @" and upper(""Lco Code"")= upper('" + txtsearch + "')";
}
}
Cls_Data_RptAddPlan_JV objDataRptAddPlan = new Cls_Data_RptAddPlan_JV();
Hashtable htResponse = new Hashtable();
htResponse.Add("htResponse", objDataRptAddPlan.GetTransationsDet(whereString, username2));
htResponse.Add("ParamStr", searchParamStr);
return(htResponse);
}
public Hashtable GetTransationsU(Hashtable htAddPlanParams1, string username1, string catid1, string operator_id1)
{
string whereString = "";
string from = htAddPlanParams1["from"].ToString();
string to = htAddPlanParams1["to"].ToString();
string lcoid = htAddPlanParams1["lcoid"].ToString();
string search_type = htAddPlanParams1["search"].ToString().Trim();
string txtsearch = htAddPlanParams1["txtsearch"].ToString().Trim();
string showall = htAddPlanParams1["showall"].ToString();
string Plantype = htAddPlanParams1["Plantype"].ToString().Trim();
string Transtype = htAddPlanParams1["Transtype"].ToString();
string Payterm = htAddPlanParams1["Payterm"].ToString();
string searchParamStr = "";
if (from != null && from != "")
{
whereString += " dt >= '" + from + "' ";
searchParamStr += " <b>Transaction From : </b> " + from;
}
if (to != null && to != "")
{
whereString += " and dt <= '" + to + "' ";
searchParamStr += " <b>Transaction To : </b> " + to;
}
if (Transtype != "All" && Transtype != "")
{
whereString += " and planflag in('" + Transtype + "') ";
}
if (Plantype != "All" && Plantype != "")
{
whereString += " and PlanType = '" + Plantype + "' ";
}
if (Payterm != "All" && Payterm != "")
{
whereString += " and PAYTERM = '" + Payterm + "' ";
}
if (catid1 == "3")
{
whereString += " and OPERID= '" + operator_id1 + "' ";
if (txtsearch.Length > 0)
{
if (search_type == "0")
{
whereString += @" and upper(""Account No"")= upper('" + txtsearch + "')";
}
else if (search_type == "1")
{
whereString += @" and upper(""VC/MAC Id"")= upper('" + txtsearch + "')";
}
else if (search_type == "2")
{
whereString += @" and upper(""Lco Code"")= upper('" + txtsearch + "')";
}
}
}
else
{
if (lcoid != null && lcoid != "" && showall != "0" && showall != "1")
{
whereString += " and lcoid = '" + lcoid + "' ";
}
}
if (showall != null && showall != "")
{
whereString += " ";
}
Cls_Data_RptAddPlan_JV objDataRptAddPlan = new Cls_Data_RptAddPlan_JV();
Hashtable htResponse = new Hashtable();
htResponse.Add("htResponse", objDataRptAddPlan.GetTransationsU(whereString, username1));
htResponse.Add("ParamStr", searchParamStr);
return(htResponse);
}
