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