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); }