public List<CarsInfo.SalesInfo> SalesAgentLogin(string Username, string Password, string CenterCode)
{
List<SalesInfo> objSalesList = new List<SalesInfo>();
CarsBL.Transactions.MobileBL objReg = new CarsBL.Transactions.MobileBL();
DataSet dsGetCenterInfo = objReg.GetCenterData(CenterCode);
if (dsGetCenterInfo.Tables.Count > 0)
{
if (dsGetCenterInfo.Tables[0].Rows.Count > 0)
{
if (dsGetCenterInfo.Tables[0].Rows[0]["AgentCenterStatus"].ToString() == "1")
{
DataSet dsUserDetails = new DataSet();
dsUserDetails = objReg.HotLeadsPerformLogin(Username, Password, CenterCode);
if (dsUserDetails.Tables.Count > 0)
{
if (dsUserDetails.Tables[0].Rows.Count > 0)
{
string AgentCenterCode = dsUserDetails.Tables[0].Rows[0]["AgentCenterCode"].ToString();
string CenterID = dsUserDetails.Tables[0].Rows[0]["AgentCenterID"].ToString();
string AgentName = dsUserDetails.Tables[0].Rows[0]["AgentUFirstName"].ToString();
DataSet dsDatetime = objReg.GetDatetime();
DateTime dtNow = Convert.ToDateTime(dsDatetime.Tables[0].Rows[0]["Datetime"].ToString());
string Date = dtNow.ToString("MM/dd/yyyy hh:mm tt");
DataSet dsData = objReg.GetAllSalesByCenterForTicker(Convert.ToInt32(CenterID));
DataSet dsAllCenters = objReg.GetAllCenterSalesByCenterForTicker(Convert.ToInt32(CenterID));
int TotalSales = Convert.ToInt32(dsData.Tables[0].Compute("sum(Count)", ""));
Double TotalAmount = Convert.ToDouble(dsData.Tables[0].Compute("sum(TotalAmount)", ""));
string Totalsales = TotalSales.ToString() + " ($" + string.Format("{0:0.00}", TotalAmount).ToString() + ")";
if (dsData.Tables.Count > 0)
{
if (dsData.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsData.Tables[0].Rows.Count; i++)
{
SalesInfo objsalesInfo = new SalesInfo();
objsalesInfo.Date = Date.ToString();
objsalesInfo.MainCenter = AgentCenterCode.ToString();
objsalesInfo.SalesAgentName = dsData.Tables[0].Rows[i]["SaleAgent"].ToString();
objsalesInfo.AgentSales = dsData.Tables[0].Rows[i]["Count"].ToString();
Double AgentSalesAmount = Convert.ToDouble(dsData.Tables[0].Rows[i]["TotalAmount"].ToString());
objsalesInfo.AgentSalesAmount = string.Format("{0:0.00}", AgentSalesAmount).ToString();
objsalesInfo.CenterCode = AgentCenterCode.ToString();
objsalesInfo.CenterSalesAmount = string.Format("{0:0.00}", TotalAmount).ToString();
objsalesInfo.CenterSalesCount = TotalSales.ToString();
objSalesList.Add(objsalesInfo);
}
}
}
if (dsAllCenters.Tables.Count > 0)
{
if (dsAllCenters.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsAllCenters.Tables[0].Rows.Count; i++)
{
SalesInfo objsalesInfo = new SalesInfo();
objsalesInfo.Date = Date.ToString();
objsalesInfo.MainCenter = AgentCenterCode.ToString();
objsalesInfo.CenterCode = dsAllCenters.Tables[0].Rows[i]["Center"].ToString();
Double CenterSalesAmount = Convert.ToDouble(dsAllCenters.Tables[0].Rows[i]["TotalAmount"].ToString());
objsalesInfo.CenterSalesAmount = string.Format("{0:0.00}", CenterSalesAmount).ToString();
objsalesInfo.CenterSalesCount = dsAllCenters.Tables[0].Rows[i]["Count"].ToString();
objSalesList.Add(objsalesInfo);
}
}
}
}
}
}
}
}
return objSalesList;
}
public List <CarsInfo.SalesInfo> SalesAgentLogin(string Username, string Password, string CenterCode)
{
List <SalesInfo> objSalesList = new List <SalesInfo>();
CarsBL.Transactions.MobileBL objReg = new CarsBL.Transactions.MobileBL();
DataSet dsGetCenterInfo = objReg.GetCenterData(CenterCode);
if (dsGetCenterInfo.Tables.Count > 0)
{
if (dsGetCenterInfo.Tables[0].Rows.Count > 0)
{
if (dsGetCenterInfo.Tables[0].Rows[0]["AgentCenterStatus"].ToString() == "1")
{
DataSet dsUserDetails = new DataSet();
dsUserDetails = objReg.HotLeadsPerformLogin(Username, Password, CenterCode);
if (dsUserDetails.Tables.Count > 0)
{
if (dsUserDetails.Tables[0].Rows.Count > 0)
{
string AgentCenterCode = dsUserDetails.Tables[0].Rows[0]["AgentCenterCode"].ToString();
string CenterID = dsUserDetails.Tables[0].Rows[0]["AgentCenterID"].ToString();
string AgentName = dsUserDetails.Tables[0].Rows[0]["AgentUFirstName"].ToString();
DataSet dsDatetime = objReg.GetDatetime();
DateTime dtNow = Convert.ToDateTime(dsDatetime.Tables[0].Rows[0]["Datetime"].ToString());
string Date = dtNow.ToString("MM/dd/yyyy hh:mm tt");
DataSet dsData = objReg.GetAllSalesByCenterForTicker(Convert.ToInt32(CenterID));
DataSet dsAllCenters = objReg.GetAllCenterSalesByCenterForTicker(Convert.ToInt32(CenterID));
int TotalSales = Convert.ToInt32(dsData.Tables[0].Compute("sum(Count)", ""));
Double TotalAmount = Convert.ToDouble(dsData.Tables[0].Compute("sum(TotalAmount)", ""));
string Totalsales = TotalSales.ToString() + " ($" + string.Format("{0:0.00}", TotalAmount).ToString() + ")";
if (dsData.Tables.Count > 0)
{
if (dsData.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsData.Tables[0].Rows.Count; i++)
{
SalesInfo objsalesInfo = new SalesInfo();
objsalesInfo.Date = Date.ToString();
objsalesInfo.MainCenter = AgentCenterCode.ToString();
objsalesInfo.SalesAgentName = dsData.Tables[0].Rows[i]["SaleAgent"].ToString();
objsalesInfo.AgentSales = dsData.Tables[0].Rows[i]["Count"].ToString();
Double AgentSalesAmount = Convert.ToDouble(dsData.Tables[0].Rows[i]["TotalAmount"].ToString());
objsalesInfo.AgentSalesAmount = string.Format("{0:0.00}", AgentSalesAmount).ToString();
objsalesInfo.CenterCode = AgentCenterCode.ToString();
objsalesInfo.CenterSalesAmount = string.Format("{0:0.00}", TotalAmount).ToString();
objsalesInfo.CenterSalesCount = TotalSales.ToString();
objSalesList.Add(objsalesInfo);
}
}
}
if (dsAllCenters.Tables.Count > 0)
{
if (dsAllCenters.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsAllCenters.Tables[0].Rows.Count; i++)
{
SalesInfo objsalesInfo = new SalesInfo();
objsalesInfo.Date = Date.ToString();
objsalesInfo.MainCenter = AgentCenterCode.ToString();
objsalesInfo.CenterCode = dsAllCenters.Tables[0].Rows[i]["Center"].ToString();
Double CenterSalesAmount = Convert.ToDouble(dsAllCenters.Tables[0].Rows[i]["TotalAmount"].ToString());
objsalesInfo.CenterSalesAmount = string.Format("{0:0.00}", CenterSalesAmount).ToString();
objsalesInfo.CenterSalesCount = dsAllCenters.Tables[0].Rows[i]["Count"].ToString();
objSalesList.Add(objsalesInfo);
}
}
}
}
}
}
}
}
return(objSalesList);
}
