public List <Project.Entity.Clients> getClients(long PIN, long User_ID, string UserRole) { objResponse Response = new objResponse(); List <Project.Entity.Clients> clients = new List <Project.Entity.Clients>(); try { SqlParameter[] sqlParameter = new SqlParameter[3]; sqlParameter[0] = new SqlParameter("@PIN", SqlDbType.BigInt, 10); sqlParameter[0].Value = PIN; sqlParameter[1] = new SqlParameter("@User_ID", SqlDbType.BigInt, 10); sqlParameter[1].Value = User_ID; sqlParameter[2] = new SqlParameter("@UserRole", SqlDbType.NVarChar, 10); sqlParameter[2].Value = UserRole; DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetClients", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA); if (Response.ResponseData.Tables[0].Rows.Count > 0) { Response.ErrorCode = 0; foreach (DataRow dr in Response.ResponseData.Tables[0].Rows) { Project.Entity.Clients objClient = new Project.Entity.Clients(); objClient.Client_ID_Auto_PK = Convert.ToInt64(dr["Client_ID_Auto_PK"]); objClient.Name = Convert.ToString(dr["Name"]); objClient.Date = Convert.ToDateTime(dr["Date"]); objClient.Email = Convert.ToString(dr["Email"]); objClient.SkypeNo = Convert.ToString(dr["SkypeNo"]); objClient.Status = Convert.ToString(dr["Status"]); objClient.AssignTO_Name = Convert.ToString(dr["AssignToUser"]); clients.Add(objClient); } } else { Response.ErrorCode = 2001; Response.ErrorMessage = "There is an Error. Please Try After some time."; } } catch (Exception ex) { Response.ErrorCode = 3001; Response.ErrorMessage = ex.Message.ToString(); BAL.Common.LogManager.LogError("getClient", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); } return(clients); }
public ActionResult AdminDashboard_V_2() { DashboardModel objDashboardModel = new DashboardModel(); objResponse Response = new objResponse(); session = new SessionHelper(); try { Response = objHomeManager.GetAdminDashboardData(Convert.ToInt64(session.UserSession.PIN)); if (Response.ErrorCode == 0) { objDashboardModel.TotalLeads = Response.ResponseData.Tables[0].Rows[0][0].ToString(); objDashboardModel.TotalDeals = Response.ResponseData.Tables[1].Rows[0][0].ToString(); objDashboardModel.TotalClients = Response.ResponseData.Tables[2].Rows[0][0].ToString(); objDashboardModel.TotalDealsRevenue = Response.ResponseData.Tables[3].Rows[0][0].ToString(); objDashboardModel.LeadsTradition = Response.ResponseData.Tables[4].Rows[0][0].ToString(); objDashboardModel.DealsTraditions = Response.ResponseData.Tables[5].Rows[0][0].ToString(); objDashboardModel.ClientsTraditions = Response.ResponseData.Tables[6].Rows[0][0].ToString(); objDashboardModel.DealsRevenueTraditions = Response.ResponseData.Tables[7].Rows[0][0].ToString(); objDashboardModel.LeadsPercentageChange = Response.ResponseData.Tables[8].Rows[0][0].ToString(); objDashboardModel.DealsPercentageChange = Response.ResponseData.Tables[9].Rows[0][0].ToString(); objDashboardModel.ClientsPercentageChange = Response.ResponseData.Tables[10].Rows[0][0].ToString(); objDashboardModel.DealsRevenuePercentageChange = Response.ResponseData.Tables[11].Rows[0][0].ToString(); objDashboardModel.TaskCompletedPercentageToday = Response.ResponseData.Tables[12].Rows[0][0].ToString(); objDashboardModel.TaskCompletedPercentageYesterday = Response.ResponseData.Tables[13].Rows[0][0].ToString(); if (Response.ResponseData.Tables[14].Rows.Count > 0) { foreach (DataRow dr in Response.ResponseData.Tables[14].Rows) { Opportunities objOpp = new Opportunities(); objOpp.Source = dr["Source"].ToString(); objOpp.RelateTo_Name = dr["RealtedTo"].ToString(); objOpp.Amount = dr["Amount"].ToString(); objOpp.Stage = dr["Stage"].ToString(); objOpp.Opportunity_Owner_Name = dr["Op_owner"].ToString(); objOpp.AssignTO_Name = dr["AssignToName"].ToString(); objDashboardModel.TopFiveDeals.Add(objOpp); } } if (Response.ResponseData.Tables[15].Rows.Count > 0) { foreach (DataRow dr in Response.ResponseData.Tables[15].Rows) { Source objSource = new Source(); objSource.Source_Name = dr["Source_Text"].ToString(); objSource.TotalLeads = dr["TotalLeads"].ToString(); objDashboardModel.TopThreeSources.Add(objSource); } } if (Response.ResponseData.Tables[16].Rows.Count > 0) { foreach (DataRow dr in Response.ResponseData.Tables[16].Rows) { Project.Entity.Clients objClient = new Project.Entity.Clients(); objClient.Client_ID_Auto_PK = Convert.ToInt64(dr["Client_ID_Auto_PK"]); objClient.Name = Convert.ToString(dr["Name"]); objClient.Date = Convert.ToDateTime(dr["Date"]); objClient.Email = Convert.ToString(dr["Email"]); objClient.SkypeNo = Convert.ToString(dr["SkypeNo"]); objClient.Status = Convert.ToString(dr["Status"]); objDashboardModel.Contacts.Add(objClient); } } return(View(objDashboardModel)); } else { return(View(objDashboardModel)); } } catch (Exception ex) { BAL.Common.LogManager.LogError("GetOpportunityLostByMonth Post Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); return(View(objDashboardModel)); } }
public objResponse UpdateClient(Project.Entity.Clients objClient, long LogedUser) { objResponse Response = new objResponse(); try { SqlParameter[] sqlParameter = new SqlParameter[17]; sqlParameter[0] = new SqlParameter("@Name", SqlDbType.NVarChar, 80); sqlParameter[0].Value = objClient.Name; sqlParameter[1] = new SqlParameter("@CompanyName", SqlDbType.NVarChar, 80); sqlParameter[1].Value = objClient.CompanyName; sqlParameter[2] = new SqlParameter("@Email", SqlDbType.NVarChar, 50); sqlParameter[2].Value = objClient.Email; sqlParameter[3] = new SqlParameter("@Contact", SqlDbType.NVarChar, 13); sqlParameter[3].Value = objClient.ContactNo; sqlParameter[4] = new SqlParameter("@Skype", SqlDbType.NVarChar, 13); sqlParameter[4].Value = objClient.SkypeNo; sqlParameter[5] = new SqlParameter("@Zipcode", SqlDbType.NVarChar, 8); sqlParameter[5].Value = objClient.ZipCode; sqlParameter[6] = new SqlParameter("@CreatedBy", SqlDbType.BigInt, 10); sqlParameter[6].Value = LogedUser; sqlParameter[7] = new SqlParameter("@CreatedDate", SqlDbType.DateTime, 50); sqlParameter[7].Value = DateTime.Now; sqlParameter[8] = new SqlParameter("@AddressLine1", SqlDbType.NVarChar, 100); sqlParameter[8].Value = objClient.AddressLine1; sqlParameter[9] = new SqlParameter("@AddressLine2", SqlDbType.NVarChar, 100); sqlParameter[9].Value = objClient.AddressLine2; sqlParameter[10] = new SqlParameter("@State", SqlDbType.NVarChar, 80); sqlParameter[10].Value = objClient.State; sqlParameter[11] = new SqlParameter("@Country", SqlDbType.NVarChar, 80); sqlParameter[11].Value = objClient.Country; sqlParameter[12] = new SqlParameter("@Altername_Email", SqlDbType.NVarChar, 60); sqlParameter[12].Value = objClient.Alternate_Email; sqlParameter[13] = new SqlParameter("@Source", SqlDbType.NVarChar, 40); sqlParameter[13].Value = objClient.Source; sqlParameter[14] = new SqlParameter("@City", SqlDbType.NVarChar, 50); sqlParameter[14].Value = objClient.City; sqlParameter[15] = new SqlParameter("@Client_ID_Auto_PK", SqlDbType.BigInt, 50); sqlParameter[15].Value = objClient.Client_ID_Auto_PK; sqlParameter[16] = new SqlParameter("@JobDescription", SqlDbType.NVarChar, 100); sqlParameter[16].Value = objClient.jobDescription; DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_UpdateClient", sqlParameter, DB_CONSTANTS.ConnectionString_ERP_CRUZATA); if (Response.ResponseData.Tables[0].Rows.Count > 0) { Response.ErrorCode = 0; Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString(); } else { Response.ErrorCode = 2001; Response.ErrorMessage = "There is an Error. Please Try After some time."; } } catch (Exception ex) { Response.ErrorCode = 3001; Response.ErrorMessage = ex.Message.ToString(); BAL.Common.LogManager.LogError("UpdateClient", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); } return(Response); }