public ActionResult AjaxAssignLead(string Lead_ID, string User_ID)
{
objResponse Response = new objResponse();
session = new Common.SessionHelper();
LeadsModel model = new LeadsModel();
try
{
string[] Lead_ID_PK = Lead_ID.Split(',');
for (int i = 1; i < Lead_ID_PK.Length; i++)
{
if (Lead_ID_PK[i].ToString() != "")
{
Response = objLeadsManager.AssignLead(Convert.ToInt64(Lead_ID_PK[i]), Convert.ToInt64(User_ID), Convert.ToInt64(session.UserSession.PIN));
if (Response.ErrorCode != 0)
{
break;
}
}
}
model.leads = objLeadsManager.getNewLeads(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(session.UserSession.UserId), session.UserSession.UserType);
return(View("NewLeads", model));
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("AjaxAssignLead Contro", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult test()
{
session = new SessionHelper();
LeadsModel objLeadmodel = new LeadsModel();
try
{
objLeadmodel.leads = objLeadsManager.getLeads(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(session.UserSession.UserId), session.UserSession.UserType);
UserManager objUserManager = new UserManager();
List <Users> UserList = new List <Users>();
UserList = objUserManager.GetUsers(session.UserSession.PIN);
List <SelectListItem> list2 = new List <SelectListItem>();
list2.Add(new SelectListItem {
Value = "0", Text = "Choose A User"
});
foreach (var user in UserList)
{
list2.Add(new SelectListItem {
Value = user.User_ID_PK.ToString(), Text = user.FullName
});
}
ViewBag.Users = list2;
// ViewBag.leads = objLeadmodel.leads;
return(View(objLeadmodel));
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("MLeadHome Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(View(objLeadmodel));
}
}
public IEnumerable <LeadsModel> GetAllLeads(string UserId)
{
List <LeadsModel> objList = new List <LeadsModel>();
using (SqlConnection con = new SqlConnection(_connectionString))
{
using (SqlCommand sqlCommand = new SqlCommand(_connectionString, con))
{
try
{
if (sqlCommand.Connection.State != System.Data.ConnectionState.Open)
{
sqlCommand.Connection.Open();
}
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
sqlCommand.CommandText = Database.GET_ALL_LEADS;
//sqlCommand.Parameters.Add(new SqlParameter("UserId", UserId));
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
LeadsModel obj = new LeadsModel();
obj.Id = Convert.ToInt32(sqlDataReader["Id"]);
obj.Name = sqlDataReader["Name"].ToString();
obj.Email = sqlDataReader["Email"].ToString();
obj.PrimaryNumber = sqlDataReader["PrimaryNumber"].ToString();
obj.SecoundryNumber = sqlDataReader["SecoundryNumber"].ToString();
obj.Address = sqlDataReader["Address"].ToString();
obj.LeadType = sqlDataReader["LeadType"].ToString();
obj.City = sqlDataReader["City"].ToString();
obj.Project = sqlDataReader["Project"].ToString();
obj.Phase = sqlDataReader["Phase"].ToString();
obj.Block = sqlDataReader["Block"].ToString();
obj.PropertyType = sqlDataReader["PropertyType"].ToString();
obj.HomeType = sqlDataReader["HomeType"].ToString();
obj.MinBudget = Convert.ToDecimal(sqlDataReader["MinBudget"]);
obj.MaxBudget = Convert.ToDecimal(sqlDataReader["MaxBudget"]);
obj.MinArea = Convert.ToDecimal(sqlDataReader["MinArea"]);
obj.MaxArea = Convert.ToDecimal(sqlDataReader["MaxArea"]);
obj.AreaType = sqlDataReader["AreaType"].ToString();
obj.LeadPriority = sqlDataReader["LeadPriority"].ToString();
obj.ClientType = sqlDataReader["ClientType"].ToString();
obj.AllocatedUser = sqlDataReader["AllocatedUser"].ToString();
obj.Beds = Convert.ToInt32(sqlDataReader["Beds"]);
obj.Source = sqlDataReader["Source"].ToString();
obj.CreatedOn = sqlDataReader["CreatedOn"].ToString();
objList.Add(obj);
}
sqlDataReader.Close();
sqlCommand.Dispose();
return(objList);
}
catch (Exception ex)
{
return(objList);
}
}
}
}
public ActionResult AddRelatedEvent(string Title, string StartDate, string EndDate, string RelatedTo, string RelatedTable, string uColour)
{
objResponse Response = new objResponse();
session = new SessionHelper();
BAL.Calender.CalenderManager objCalender = new BAL.Calender.CalenderManager();
try
{
List <string> temp1 = new List <string>();
List <string> temp2 = new List <string>();
temp1 = StartDate.Split(' ').ToList();
temp2 = EndDate.Split(' ').ToList();
DateTime fromDate = Convert.ToDateTime(temp1[0].Split('-').ToList()[2] + "/" + temp1[0].Split('-').ToList()[0] + "/" + temp1[0].Split('-').ToList()[1] + " " + temp1[1] + " " + temp1[2]);
DateTime toDate = Convert.ToDateTime(temp2[0].Split('-').ToList()[2] + "/" + temp2[0].Split('-').ToList()[0] + "/" + temp2[0].Split('-').ToList()[1] + " " + temp2[1] + " " + temp2[2]).AddDays(1);
// DateTime fromDate = Convert.ToDateTime(StartDate);
// DateTime toDate = Convert.ToDateTime(EndDate).AddDays(1);
//DateTime toDate = Convert.ToDateTime(EndDate);
// Response = objCalender.AddNewEvent(Convert.ToInt32(EventId), Title, fromDate, toDate, uColour, RelatedTo, RelatedTable, Convert.ToInt64(session.UserSession.UserId), Convert.ToInt64(session.UserSession.PIN));
Response = objCalender.AddNewEvent(Title, fromDate, toDate, uColour, RelatedTo, RelatedTable, session.UserSession.UserId, Convert.ToInt64(session.UserSession.PIN));
if (Response.ErrorCode == 0)
{
if (RelatedTable == "LEAD")
{
LeadsModel objLeadModel = new LeadsModel();
objLeadModel.Events = objEventManager.getEventsByRelateToID(Convert.ToInt64(session.UserSession.PIN), session.UserSession.UserId, Convert.ToInt64(RelatedTo), RelatedTable);
return(View("AjaxEvents", objLeadModel));
}
else if (RelatedTable == "OPPORTUNITY")
{
OpportunityModel objOppoModel = new OpportunityModel();
objOppoModel.Events = objEventManager.getEventsByRelateToID(Convert.ToInt64(session.UserSession.PIN), session.UserSession.UserId, Convert.ToInt64(RelatedTo), RelatedTable);
return(View("AjaxEvents", objOppoModel));
}
else
{
ClientModel objClientModel = new ClientModel();
objClientModel.Events = objEventManager.getEventsByRelateToID(Convert.ToInt64(session.UserSession.PIN), session.UserSession.UserId, Convert.ToInt64(RelatedTo), RelatedTable);
return(View("AjaxEvents", objClientModel));
}
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("AddRelatedEvent conto Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
//LIST IndexOpportunity
public ActionResult IndexOpportunity(string SortingCol, string SortType)
{
List <LeadsModel> LeadList = new List <LeadsModel>();
string Dbconnection = ConfigurationManager.ConnectionStrings["LeadConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(Dbconnection))
{
con.Open();
SqlCommand Com = new SqlCommand("USP_SALES_MANAGEMENT_Op_SelectAll", con);
Com.CommandType = CommandType.StoredProcedure;
//Com.Parameters.AddWithValue("@SortingCol", SortingCol);
//Com.Parameters.AddWithValue("@SortType", SortType);
//if (SortType == "ASC")
//{
// SortType = "DESC";
//}
//else
//{
// SortType = "ASC";
//}
//ViewBag.sorttype = SortType;
SqlDataReader Sqlreader = Com.ExecuteReader();
while (Sqlreader.Read())
{
var customer = new LeadsModel();
customer.LeadId = Convert.ToInt32(Sqlreader["LeadId"]);
customer.Photo = Sqlreader["Photo"].ToString();
customer.FirstName = Sqlreader["FirstName"].ToString();
customer.LastName = Sqlreader["LastName"].ToString();
customer.DateOfBirth = Convert.ToDateTime(Sqlreader["DateOfBirth"]);
customer.Gender = Sqlreader["Gender"].ToString();
customer.CurrentAddress = Sqlreader["CurrentAddress"].ToString();
customer.PermanentAddress = Sqlreader["PermanentAddress"].ToString();
customer.MobileNumber = Convert.ToInt64(Sqlreader["MobileNumber"]);
customer.EmailId = Sqlreader["EmailId"].ToString();
customer.City = Sqlreader["City"].ToString();
customer.State = Sqlreader["State"].ToString();
customer.Country = Sqlreader["Country"].ToString();
customer.Title = Sqlreader["Title"].ToString();
customer.LeadSource = Sqlreader["LeadSource"].ToString();
customer.MeetingDate = Convert.ToDateTime(Sqlreader["MeetingDate"]);
customer.CreatedDate = Convert.ToDateTime(Sqlreader["CreatedDate"]);
customer.Type = Sqlreader["Type"].ToString();
customer.JobTitle = Sqlreader["JobTitle"].ToString();
customer.CompanyWebsite = Sqlreader["CompanyWebsite"].ToString();
customer.CompanyName = Sqlreader["CompanyName"].ToString();
LeadList.Add(customer);
}
return(View(LeadList));
}
}
public ActionResult Edit(int?LeadId)
{
//ViewBag.Designations = employeeDbAccess.GetEmployeeDesignations();
//var Edit = employeeDbAccess.GetIdEdit(Id);
ViewBag.LeadSourceList = GetLeadSourceList();
ViewBag.CityList = GetCityList();
ViewBag.StateList = GetStateList();
ViewBag.CountryList = GetCountryList();
ViewBag.TypeList = GetTypeList();
LeadsModel customer = new LeadsModel();
List <LeadsModel> LeadList = new List <LeadsModel>();
string Dbconnection = ConfigurationManager.ConnectionStrings["LeadConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(Dbconnection))
{
con.Open();
SqlCommand Com = new SqlCommand("USP_SALES_MANAGEMENT_SelectAllbyId", con);
Com.CommandType = CommandType.StoredProcedure;
Com.Parameters.AddWithValue("@LeadId", LeadId);
SqlDataReader Sqlreader = Com.ExecuteReader();
while (Sqlreader.Read())
{
customer.LeadId = Convert.ToInt32(Sqlreader["LeadId"]);
customer.Photo = Sqlreader["Photo"].ToString();
customer.FirstName = Sqlreader["FirstName"].ToString();
customer.LastName = Sqlreader["LastName"].ToString();
customer.DateOfBirth = Convert.ToDateTime(Sqlreader["DateOfBirth"]);
customer.Gender = Sqlreader["Gender"].ToString();
customer.CurrentAddress = Sqlreader["CurrentAddress"].ToString();
customer.PermanentAddress = Sqlreader["PermanentAddress"].ToString();
customer.MobileNumber = Convert.ToInt64(Sqlreader["MobileNumber"]);
customer.EmailId = Sqlreader["EmailId"].ToString();
customer.Country = Sqlreader["Country"].ToString();
customer.CountryName = Sqlreader["CountryName"].ToString();
customer.State = Sqlreader["State"].ToString();
customer.StateName = Sqlreader["StateName"].ToString();
customer.City = Sqlreader["City"].ToString();
customer.CityName = Sqlreader["CityName"].ToString();
customer.Title = Sqlreader["Title"].ToString();
customer.LeadSource = Sqlreader["LeadSource"].ToString();
customer.LeadSourceName = Sqlreader["LeadSourceName"].ToString();
customer.MeetingDate = Convert.ToDateTime(Sqlreader["MeetingDate"]);
customer.Type = Sqlreader["Type"].ToString();
customer.TypeName = Sqlreader["TypeName"].ToString();
customer.JobTitle = Sqlreader["JobTitle"].ToString();
customer.CompanyWebsite = Sqlreader["CompanyWebsite"].ToString();
customer.CompanyName = Sqlreader["CompanyName"].ToString();
LeadList.Add(customer);
}
return(View(customer));
}
}
public ActionResult Create()
{
LeadsModel DropdownList = new LeadsModel()
{
LeadSourceList = GetLeadSourceList(),
CountryList = GetCountryList(),
StateList = GetStateList(),
CityList = GetCityList(),
TypeList = GetTypeList()
};
return(View(DropdownList));
}
public bool UpdateLead(LeadsModel lead)
{
lead.AllocatedUser = User.Identity.Name;
try
{
var obj = repository.UpdateLead(lead);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult NotRepliedLeads()
{
session = new SessionHelper();
LeadsModel model = new LeadsModel();
try
{
model.leads = objLeadsManager.getNotRepliedLeads(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(session.UserSession.UserId), session.UserSession.UserType);
return(View(model));
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("NotRepliedLeads Post Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult AjaxActivity(string LeadId)
{
LeadsModel objLeadModel = new LeadsModel();
session = new SessionHelper();
try
{
objLeadModel.Activity = UtilityManager.getActivityByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(LeadId), "LEAD");
return(View(objLeadModel));
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("AjaxActivity Post Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult Create(LeadsModel model, HttpPostedFileBase file)
{
LeadsModel DropdownList = new LeadsModel()
{
LeadSourceList = GetLeadSourceList(),
CountryList = GetCountryList(),
StateList = GetStateList(),
CityList = GetCityList(),
TypeList = GetTypeList()
};
{
Connection();
SqlCommand Command = new SqlCommand("SP_Lead_Insert", con);
Command.CommandType = CommandType.StoredProcedure;
con.Open();
//Command.Parameters.AddWithValue("@Photo", model.Photo);
Command.Parameters.AddWithValue("@FirstName", model.FirstName);
Command.Parameters.AddWithValue("@LastName", model.LastName);
Command.Parameters.AddWithValue("@DateOfBirth", model.DateOfBirth);
Command.Parameters.AddWithValue("@Gender", model.Gender);
Command.Parameters.AddWithValue("@CurrentAddress", model.CurrentAddress);
Command.Parameters.AddWithValue("@PermanentAddress", model.PermanentAddress);
Command.Parameters.AddWithValue("@MobileNumber", model.MobileNumber);
Command.Parameters.AddWithValue("@EmailId", model.EmailId);
Command.Parameters.AddWithValue("@Country", model.Country);
Command.Parameters.AddWithValue("@State", model.State);
Command.Parameters.AddWithValue("@City", model.City);
Command.Parameters.AddWithValue("@Title", model.Title);
Command.Parameters.AddWithValue("@LeadSource", model.LeadSource);
Command.Parameters.AddWithValue("@MeetingDate", model.MeetingDate);
Command.Parameters.AddWithValue("@Type", model.Type);
Command.Parameters.AddWithValue("@JobTitle", model.JobTitle);
Command.Parameters.AddWithValue("@CompanyName", model.CompanyName);
Command.Parameters.AddWithValue("@CompanyWebSite", model.CompanyWebsite);
if (file != null && file.ContentLength > 0)
{
string filename = Path.GetFileName(file.FileName);
string imgpath = Path.Combine(Server.MapPath("~/Lead-Images/"), filename);
file.SaveAs(imgpath);
}
Command.Parameters.AddWithValue("@Photo", "~/Lead-Images/" + file.FileName);
Command.ExecuteNonQuery();
con.Close();
ViewBag.Message = "LEAD CREATE SUCCESSFULLY :)";
return(View(DropdownList));
}
}
public ActionResult AjaxAddTask(string Titele, string RelateTo, string Description, string notificationFlag, string AssignTo, string RelatedTable)
{
objResponse Response = new objResponse();
session = new SessionHelper();
try
{
if (AssignTo == "0")
{
AssignTo = session.UserSession.UserId.ToString();
}
Response = objTaskManager.AddTask(Titele, Convert.ToInt64(RelateTo), Description, notificationFlag, "Planed", session.UserSession.UserId, Convert.ToInt64(session.UserSession.PIN), AssignTo, RelatedTable);
if (Response.ErrorCode == 0)
{
if (RelatedTable == "LEAD")
{
LeadsModel objLeadModel = new LeadsModel();
objLeadModel.Task = objTaskManager.getTasksByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(RelateTo), session.UserSession.UserId, RelatedTable);
return(View("AjaxTasks", objLeadModel));
}
else if (RelatedTable == "OPPORTUNITY")
{
OpportunityModel objOppoModel = new OpportunityModel();
objOppoModel.Task = objTaskManager.getTasksByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(RelateTo), session.UserSession.UserId, RelatedTable);
return(View("AjaxTasks", objOppoModel));
}
else
{
ClientModel objClientModel = new ClientModel();;
objClientModel.Task = objTaskManager.getTasksByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(RelateTo), session.UserSession.UserId, RelatedTable);
return(View("AjaxTasks", objClientModel));
}
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("AjaxAddTask conto Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int?LeadId, LeadsModel model)
{
string Dbconnection = ConfigurationManager.ConnectionStrings["LeadConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(Dbconnection))
{
con.Open();
SqlCommand cmd = new SqlCommand("USP_SALES_MANAGEMENT_Delete", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@LeadId", LeadId);
cmd.ExecuteNonQuery();
con.Close();
return(RedirectToAction("Index"));
}
}
public ActionResult DeleteDoc(string Doc_ID_PK, string FileName, string FileID, string RelatedTable, string RelateToID)
{
objResponse response = new objResponse();
session = new SessionHelper();
try
{
response = objDocManager.DeleteDocument(Convert.ToInt64(Doc_ID_PK), Convert.ToInt64(session.UserSession.PIN));
if (response.ErrorCode == 0)
{
string Doc = "DOC0" + session.UserSession.UserId.ToString() + "_" + FileID + "_" + FileName;
string newFilePath = Server.MapPath(ConfigurationManager.AppSettings["Doc_Dir"]) + Doc;
if (System.IO.File.Exists(newFilePath))
{
System.IO.File.Delete(newFilePath);
}
if (RelatedTable == "LEAD")
{
LeadsModel objLeadModel = new LeadsModel();
objLeadModel.Doc = objDocManager.getDocsRelatedToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(RelateToID), "LEAD", session.UserSession.UserId);
return(View("AjaxDoc", objLeadModel));
}
else if (RelatedTable == "OPPORTUNITY")
{
OpportunityModel objOppoModel = new OpportunityModel();
objOppoModel.Doc = objDocManager.getDocsRelatedToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(RelateToID), RelatedTable, session.UserSession.UserId);
return(View("AjaxOppoDoc", objOppoModel));
}
else
{
ClientModel objClientModel = new ClientModel();
objClientModel.Doc = objDocManager.getDocsRelatedToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(RelateToID), RelatedTable, session.UserSession.UserId);
return(View("AjaxClientDoc", objClientModel));
}
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("DeleteDoc Post Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult NewLead(LeadsModel LED)
{
if (ismodel)
{
using (context = new BPOContext())
{
Leads led = new Leads()
{
Emp_ID = LED.Emp_ID,
ID = LED.ID,
No_Of_Leads = LED.No_Of_Leads
};
context.Leads.Add(led);
context.SaveChanges();
}
}
return(View());
}
public ActionResult Edit(int?LeadId, LeadsModel model, HttpPostedFileBase file)
{
string Dbconnection = ConfigurationManager.ConnectionStrings["LeadConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(Dbconnection))
{
con.Open();
SqlCommand Command = new SqlCommand("USP_SALES_MANAGEMENT_Update", con);
Command.CommandType = CommandType.StoredProcedure;
//Command.Parameters.AddWithValue("@Photo", model.Photo);
Command.Parameters.AddWithValue("@LeadId", model.LeadId);
Command.Parameters.AddWithValue("@FirstName", model.FirstName);
Command.Parameters.AddWithValue("@LastName", model.LastName);
Command.Parameters.AddWithValue("@DateOfBirth", model.DateOfBirth);
Command.Parameters.AddWithValue("@Gender", model.Gender);
Command.Parameters.AddWithValue("@CurrentAddress", model.CurrentAddress);
Command.Parameters.AddWithValue("@PermanentAddress", model.PermanentAddress);
Command.Parameters.AddWithValue("@MobileNumber", model.MobileNumber);
Command.Parameters.AddWithValue("@EmailId", model.EmailId);
Command.Parameters.AddWithValue("@Country", model.Country);
Command.Parameters.AddWithValue("@State", model.State);
Command.Parameters.AddWithValue("@City", model.City);
Command.Parameters.AddWithValue("@Title", model.Title);
Command.Parameters.AddWithValue("@LeadSource", model.LeadSource);
Command.Parameters.AddWithValue("@MeetingDate", model.MeetingDate);
Command.Parameters.AddWithValue("@Type", model.Type);
Command.Parameters.AddWithValue("@Job Title", model.JobTitle);
Command.Parameters.AddWithValue("@CompanyName", model.CompanyName);
Command.Parameters.AddWithValue("@CompanyWebSite", model.CompanyWebsite);
if (file != null && file.ContentLength > 0)
{
string filename = Path.GetFileName(file.FileName);
string imgpath = Path.Combine(Server.MapPath("~/Lead-Images/"), filename);
file.SaveAs(imgpath);
}
Command.Parameters.AddWithValue("@Photo", "~/Lead-Images/" + file.FileName);
Command.ExecuteNonQuery();
con.Close();
return(RedirectToAction("Index"));
}
}
public ActionResult DeleteEvents(string Events_ID, string RelatedTable, string RelateToID)
{
objResponse Response = new objResponse();
session = new SessionHelper();
try
{
Response = objEventManager.DeleteEvent(Convert.ToInt64(Events_ID), Convert.ToInt64(RelateToID), RelatedTable, Convert.ToInt64(session.UserSession.UserId), Convert.ToInt64(session.UserSession.PIN));
if (Response.ErrorCode == 0)
{
if (RelatedTable == "LEAD")
{
LeadsModel objLeadModel = new LeadsModel();
objLeadModel.Events = objEventManager.getEventsByRelateToID(Convert.ToInt64(session.UserSession.PIN), session.UserSession.UserId, Convert.ToInt64(RelateToID), RelatedTable);
return(View("AjaxEvents", objLeadModel));
}
else if (RelatedTable == "OPPORTUNITY")
{
OpportunityModel objOppoModel = new OpportunityModel();
objOppoModel.events = objEventManager.getEventsByRelateToID(Convert.ToInt64(session.UserSession.PIN), session.UserSession.UserId, Convert.ToInt64(RelateToID), RelatedTable);
return(View("AjaxEvents", objOppoModel));
}
else
{
ClientModel objClientModel = new ClientModel();
objClientModel.Events = objEventManager.getEventsByRelateToID(Convert.ToInt64(session.UserSession.PIN), session.UserSession.UserId, Convert.ToInt64(RelateToID), RelatedTable);
return(View("AjaxEvents", objClientModel));
}
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("DeleteEvents conto Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult AjaxAddNote(string RelateTo, string Note, string RelatedTable)
{
objResponse Response = new objResponse();
session = new SessionHelper();
try
{
Response = objNoteManager.AddNote(Convert.ToInt64(RelateTo), Note, session.UserSession.UserId, Convert.ToInt64(session.UserSession.PIN), RelatedTable);
if (Response.ErrorCode == 0)
{
if (RelatedTable == "LEAD")
{
LeadsModel objLeadModel = new LeadsModel();
objLeadModel.Notes = objNoteManager.getNotesByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(RelateTo), session.UserSession.UserId, RelatedTable);
return(View("AjaxLeadNotes", objLeadModel));
}
else if (RelatedTable == "OPPORTUNITY")
{
OpportunityModel objOppoModel = new OpportunityModel();
objOppoModel.Notes = objNoteManager.getNotesByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(RelateTo), session.UserSession.UserId, RelatedTable);
return(View("AjaxOppoNotes", objOppoModel));
}
else
{
ClientModel objClientModel = new ClientModel();
objClientModel.Notes = objNoteManager.getNotesByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(RelateTo), session.UserSession.UserId, RelatedTable);
return(View("AjaxClientNote", objClientModel));
}
}
else
{
return(Json("Fail", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("AjaxAddNote conto Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("Fail", JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateLeadDetails(string LeadID, string status, string Note, string Followupdate)
{
session = new SessionHelper();
objResponse Response = new objResponse();
try
{
DateTime FollowUp = BAL.Helper.Helper.ConvertToDateNullable(Followupdate, "dd/MM/yyyy");
Response = objLeadsManager.UpdateLeadDetails(Convert.ToInt64(LeadID), status, Note, FollowUp, session.UserSession.UserId);
if (Response.ErrorCode == 0)
{
LeadsModel model = new LeadsModel();
model.leads = objLeadsManager.getLeads(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(session.UserSession.UserId), session.UserSession.UserType);
//if (status == "NEW")
//{
// return View("NewLeads", model);
//}
//else if (status == "WORKING")
//{
// return View("WorkingLeads", model);
//}
//else
//{
// return View("WorkingLeads", model);
//}
return(Json("success", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
ViewBag.Error_Msg = ex.Message.ToString();;
BAL.Common.LogManager.LogError("UpdateLeadDetils Contro", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateLeads(LeadsModel objLeadmodel)
{
objResponse Response = new objResponse();
Project.Entity.Leads objLead = new Entity.Leads();
session = new SessionHelper();
List <TextValue> source = new List <TextValue>();
source = UtilityManager.GetSourceForDropDown(Convert.ToInt64(session.UserSession.PIN), "Client", "Source");
List <SelectListItem> list = new List <SelectListItem>();
list.Add(new SelectListItem {
Value = "0", Text = "Choose a Source"
});
foreach (var cat in source)
{
list.Add(new SelectListItem {
Value = cat.Value, Text = cat.Text
});
}
string route = "/Leads/ViewLead?sessionid=" + Guid.NewGuid().ToString() + "&Leadid=" + objLeadmodel.Lead_ID;
try
{
//objLead.Date = BAL.Helper.Helper.ConvertToDateNullable(objLeadmodel.Date, "dd/MM/yyyy");
// objLead.FollowUpDate = BAL.Helper.Helper.ConvertToDateNullable(objLeadmodel.FollowUpDate, "dd/MM/yyyy");
objLead.Name = objLeadmodel.Name;
objLead.CompanyName = objLeadmodel.CompanyName;
objLead.Email = objLeadmodel.Email;
objLead.ContactNo = objLeadmodel.ContactNo;
objLead.SkypeNo = objLeadmodel.SkypeNo;
objLead.ZipCode = objLeadmodel.ZipCode;
objLead.AddressLine1 = objLeadmodel.AddressLine1;
objLead.AddressLine2 = objLeadmodel.AddressLine2;
objLead.City = objLeadmodel.City;
objLead.State = objLeadmodel.State;
objLead.Country = objLeadmodel.Country;
objLead.Alternate_Email = objLeadmodel.Alternate_Email;
objLead.Source = objLeadmodel.Source;
objLead.JobDescription = objLeadmodel.JobDescription;
objLead.Lead_ID_Auto_PK = objLeadmodel.Lead_ID;
session = new SessionHelper();
Response = objLeadsManager.UpdateLead(objLead, session.UserSession.UserId);
if (Response.ErrorCode == 0)
{
ViewBag.Source_List = list;
// return RedirectToRoute("LeadHome");
//return RedirectToRoute("ViewLead");
//return View(objLeadmodel);
return(Redirect(route));
}
else
{
ViewBag.Error_Msg = Response.ErrorMessage;
ViewBag.Source_List = list;
// return RedirectToRoute("LeadHome");
//return RedirectToRoute("ViewLead");
return(View(objLeadmodel));
}
}
catch (Exception ex)
{
ViewBag.Error_Msg = Response.ErrorMessage;
ViewBag.Source_List = list;
BAL.Common.LogManager.LogError("UpdateLead Post Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
// return RedirectToRoute("LeadHome");
//return RedirectToRoute("ViewLead");
return(View(objLeadmodel));
}
}
public ActionResult UpdateLeads(string Lead_ID_Pk)
{
objResponse Response = new objResponse();
LeadsModel model = new LeadsModel();
session = new SessionHelper();
List <TextValue> source = new List <TextValue>();
source = objSetingManager.GetDropDownListing("Lead", "Source", Convert.ToInt64(session.UserSession.PIN));
List <SelectListItem> list = new List <SelectListItem>();
list.Add(new SelectListItem {
Value = "0", Text = "Choose a Source"
});
foreach (var cat in source)
{
list.Add(new SelectListItem {
Value = cat.Value, Text = cat.Text
});
}
try
{
Response = objLeadsManager.getLeadForUpdate(Convert.ToInt64(Lead_ID_Pk));
if (Response.ErrorCode == 0)
{
model.Lead_ID = Convert.ToInt64(Response.ResponseData.Tables[0].Rows[0]["Lead_ID_Auto_PK"]);
model.Name = Response.ResponseData.Tables[0].Rows[0]["Name"].ToString();
model.CompanyName = Response.ResponseData.Tables[0].Rows[0]["CompanyName"].ToString();
model.Email = Response.ResponseData.Tables[0].Rows[0]["Email"].ToString();
model.Alternate_Email = Response.ResponseData.Tables[0].Rows[0]["Alternate_Email"].ToString();
model.ContactNo = Response.ResponseData.Tables[0].Rows[0]["ContactNo"].ToString();
model.SkypeNo = Response.ResponseData.Tables[0].Rows[0]["SkypeNo"].ToString();;
model.AddressLine1 = Response.ResponseData.Tables[0].Rows[0]["AddressLine1"].ToString();
model.AddressLine2 = Response.ResponseData.Tables[0].Rows[0]["AddressLine2"].ToString();
model.City = Response.ResponseData.Tables[0].Rows[0]["City"].ToString();;
model.State = Response.ResponseData.Tables[0].Rows[0]["State"].ToString();
model.Country = Response.ResponseData.Tables[0].Rows[0]["Country"].ToString();
model.ZipCode = Response.ResponseData.Tables[0].Rows[0]["Zipcode"].ToString();
model.Source = Response.ResponseData.Tables[0].Rows[0]["Source"].ToString();
model.JobDescription = Response.ResponseData.Tables[0].Rows[0]["JobDescription"].ToString();
ViewBag.Source_List = list;
return(View(model));
}
else
{
ViewBag.Source_List = list;
return(View(model));
}
}
catch (Exception ex)
{
ViewBag.Source_List = list;
BAL.Common.LogManager.LogError("UpdateLeads Get Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(View(model));
}
}
public ActionResult ViewLead(string sessionid, string Leadid)
{
MeetingManager objMeetingManager = new MeetingManager();
TaskManager objTaskManager = new TaskManager();
DocumentManager objDocManager = new DocumentManager();
NoteManager objNoteManager = new NoteManager();
EventManager objEventManager = new EventManager();
objResponse Response = new objResponse();
session = new SessionHelper();
List <TextValue> source = new List <TextValue>();
source = objSetingManager.GetDropDownListing("Lead", "Source", Convert.ToInt64(session.UserSession.PIN));
List <SelectListItem> list = new List <SelectListItem>();
list.Add(new SelectListItem {
Value = "0", Text = "Choose a Source"
});
foreach (var cat in source)
{
list.Add(new SelectListItem {
Value = cat.Value, Text = cat.Text
});
}
UserManager objUserManager = new UserManager();
List <Users> UserList = new List <Users>();
UserList = objUserManager.GetUsers(session.UserSession.PIN);
LeadsModel objLeadModel = new LeadsModel();
try
{
Response = objLeadsManager.ViewLeads(Leadid);
if (Response.ErrorCode == 0)
{
objLeadModel.Lead_ID = Convert.ToInt64(Leadid);
objLeadModel.Date = Convert.ToString(Response.ResponseData.Tables[0].Rows[0]["Date"]);
objLeadModel.FollowUpDate = Convert.ToString(Response.ResponseData.Tables[0].Rows[0]["FutureFollowUp"]);
objLeadModel.Name = Convert.ToString(Response.ResponseData.Tables[0].Rows[0]["Name"]);
objLeadModel.CompanyName = Convert.ToString(Response.ResponseData.Tables[0].Rows[0]["CompanyName"]);
objLeadModel.Email = Convert.ToString(Response.ResponseData.Tables[0].Rows[0]["Email"]);
objLeadModel.ContactNo = Convert.ToString(Response.ResponseData.Tables[0].Rows[0]["ContactNo"]);
objLeadModel.SkypeNo = Convert.ToString(Response.ResponseData.Tables[0].Rows[0]["SkypeNo"]);
objLeadModel.Status = Convert.ToString(Response.ResponseData.Tables[0].Rows[0]["Status"]);
objLeadModel.Source = Convert.ToString(Response.ResponseData.Tables[0].Rows[0]["Source"]);
objLeadModel.AddressLine1 = Response.ResponseData.Tables[0].Rows[0]["AddressLine1"].ToString();
objLeadModel.AddressLine2 = Response.ResponseData.Tables[0].Rows[0]["AddressLine2"].ToString();
objLeadModel.City = Response.ResponseData.Tables[0].Rows[0]["City"].ToString();;
objLeadModel.State = Response.ResponseData.Tables[0].Rows[0]["State"].ToString();
objLeadModel.Country = Response.ResponseData.Tables[0].Rows[0]["Country"].ToString();
objLeadModel.ZipCode = Response.ResponseData.Tables[0].Rows[0]["Zipcode"].ToString();
objLeadModel.JobDescription = Response.ResponseData.Tables[0].Rows[0]["JobDescription"].ToString();
objLeadModel.Alternate_Email = Response.ResponseData.Tables[0].Rows[0]["Alternate_Email"].ToString();
objLeadModel.CreatedBy = Response.ResponseData.Tables[0].Rows[0]["Owner"].ToString();
// objLeadModel.Events = objMeetingManager.getMeetingsByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(Leadid), session.UserSession.UserId);
objLeadModel.Events = objEventManager.getEventsByRelateToID(Convert.ToInt64(session.UserSession.PIN), session.UserSession.UserId, Convert.ToInt64(Leadid), "LEAD");
objLeadModel.Activity = UtilityManager.getActivityByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(Leadid), "LEAD");
objLeadModel.Task = objTaskManager.getTasksByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(Leadid), session.UserSession.UserId, "LEAD");
objLeadModel.Doc = objDocManager.getDocsRelatedToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(Leadid), "LEAD", session.UserSession.UserId);
objLeadModel.Notes = objNoteManager.getNotesByRelateToID(Convert.ToInt64(session.UserSession.PIN), Convert.ToInt64(Leadid), session.UserSession.UserId, "LEAD");
ViewBag.Source_List = list;
ViewBag.Users = UserList;
return(View(objLeadModel));
}
else
{
ViewBag.Source_List = list;
ViewBag.Users = UserList;
ViewBag.Error_Msg = "There is error in Fetching Lead Details";
return(View(objLeadModel));
}
}
catch (Exception ex)
{
ViewBag.Source_List = list;
ViewBag.Users = UserList;
ViewBag.Error_Msg = ex.Message.ToString();;
BAL.Common.LogManager.LogError("ViewLead Contro", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(View(objLeadModel));
}
}
public ActionResult ManageLead(LeadsModel objLeadmodel)
{
objResponse Response = new objResponse();
Project.Entity.Leads objLead = new Entity.Leads();
session = new SessionHelper();
List <TextValue> source = new List <TextValue>();
source = objSetingManager.GetDropDownListing("Lead", "Source", Convert.ToInt64(session.UserSession.PIN));
List <SelectListItem> list = new List <SelectListItem>();
list.Add(new SelectListItem {
Value = "0", Text = "Choose a Source"
});
foreach (var cat in source)
{
list.Add(new SelectListItem {
Value = cat.Value, Text = cat.Text
});
}
try
{
objLead.Date = DateTime.Now;
objLead.Name = objLeadmodel.Name;
objLead.CompanyName = objLeadmodel.CompanyName;
objLead.Email = objLeadmodel.Email;
objLead.ContactNo = objLeadmodel.ContactNo;
objLead.SkypeNo = objLeadmodel.SkypeNo;
objLead.Category_ID = objLeadmodel.Category.ToString();
objLead.ZipCode = objLeadmodel.ZipCode;
objLead.AddressLine1 = objLeadmodel.AddressLine1;
objLead.AddressLine2 = objLeadmodel.AddressLine2;
objLead.City = objLeadmodel.City;
objLead.State = objLeadmodel.State;
objLead.Country = objLeadmodel.Country;
objLead.Alternate_Email = objLeadmodel.Alternate_Email;
objLead.Source = objLeadmodel.Source;
objLead.JobDescription = objLeadmodel.JobDescription;
session = new SessionHelper();
Response = objLeadsManager.AddLead(objLead, Convert.ToInt64(session.UserSession.UserId), Convert.ToInt64(session.UserSession.PIN));
if (Response.ErrorCode == 0)
{
if (Response.ErrorMessage != "Lead with same Email Already Exists")
{
return(RedirectToRoute("LeadHome"));
}
else
{
ViewBag.Error_Msg = Response.ErrorMessage;
ViewBag.Source_List = list;
return(View());
}
}
else
{
ViewBag.Error_Msg = Response.ErrorMessage;
ViewBag.Source_List = list;
return(View());
}
}
catch (Exception ex)
{
ViewBag.Error_Msg = Response.ErrorMessage;
ViewBag.Source_List = list;
BAL.Common.LogManager.LogError("ManageLead Post Method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(View());
}
}
public ActionResult AddNewDoc()
{
objResponse Response = new objResponse();
session = new SessionHelper();
try
{
Int64 RelateToID = Convert.ToInt64(Request.Form["RelateTo"]);
string RelatedTable = Request.Form["RelatedTable"].ToString();
string Title = Request.Form["Title"].ToString();
string fname;
Guid FileID = System.Guid.NewGuid();
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = file.FileName;
}
string newFileName = "DOC0" + session.UserSession.UserId.ToString() + "_" + FileID.ToString() + "_" + fname;
string newFilePath = Server.MapPath(ConfigurationManager.AppSettings["Doc_Dir"]) + newFileName;
file.SaveAs(newFilePath);
Response = objDocManager.AddDoc(Title, RelateToID, fname, FileID.ToString(), session.UserSession.UserId, session.UserSession.PIN, RelatedTable);
if (Response.ErrorCode == 0)
{
if (RelatedTable == "LEAD")
{
LeadsModel objLeadModel = new LeadsModel();
objLeadModel.Doc = objDocManager.getDocsRelatedToID(Convert.ToInt64(session.UserSession.PIN), RelateToID, RelatedTable, session.UserSession.UserId);
return(View("AjaxDoc", objLeadModel));
}
else if (RelatedTable == "OPPORTUNITY")
{
OpportunityModel objOppoModel = new OpportunityModel();
objOppoModel.Doc = objDocManager.getDocsRelatedToID(Convert.ToInt64(session.UserSession.PIN), RelateToID, RelatedTable, session.UserSession.UserId);
return(View("AjaxOppoDoc", objOppoModel));
}
else
{
ClientModel objClientModel = new ClientModel();
objClientModel.Doc = objDocManager.getDocsRelatedToID(Convert.ToInt64(session.UserSession.PIN), RelateToID, RelatedTable, session.UserSession.UserId);
return(View("AjaxClientDoc", objClientModel));
}
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
return(Json("", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
BAL.Common.LogManager.LogError("AddNewDoc Post method", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
return(Json("fail", JsonRequestBehavior.AllowGet));
}
}
