public List <SalesModel> getNewClients(DateTime stDate, DateTime endDate)
{
DateTime today = DateTime.Now.Date;
db = new dashrdku_database();
List <CandidateMaster> candidates = db.CandidateMasters.Where(c => c.Date >= stDate.Date && c.Date <= endDate.Date).ToList();
List <SalesModel> newCandidates = new List <SalesModel>();
foreach (CandidateMaster candidate in candidates)
{
newCandidates.Add(new SalesModel()
{
CandidateId = candidate.CandidateId,
CandidateName = candidate.CandidateName,
CandidateStatus = candidate.CandidateStatus,
Date = candidate.Date,
EmailId = candidate.EmailId,
MarketingStartDate = candidate.MarketingStartDate,
MobileNumber = candidate.MobileNumber,
PaidAmount = candidate.PaidAmount,
PaymentStatus = candidate.PaymentStatus,
RecurringType = candidate.RecurringType.RecurringTitle,
SalesAssociate = candidate.UserAccountDetail.FullName,
Service = candidate.SalesServiceMaster.ServiceName,
Remarks = candidate.Remarks,
Technology = candidate.TechnologyMaster.TechTitle,
TotalAmount = candidate.TotalAmount,
VisaStatus = candidate.VisaStatus
});
}
return(newCandidates);
}
public List <ExpertCVModel> getData()
{
dashrdku_database db = new dashrdku_database();
var data = db.CandidateMasters.ToList();
List <ExpertCVModel> expertCVModels = new List <ExpertCVModel>();
foreach (CandidateMaster candidate in data)
{
ExpertCVModel model = new ExpertCVModel();
model.CandidateId = candidate.CandidateId;
model.CandidateName = candidate.CandidateName;
model.CandidateStatus = candidate.CandidateStatus;
model.Date = candidate.Date;
model.EmailId = candidate.EmailId;
model.MarketingStartDate = candidate.MarketingStartDate;
model.MobileNumber = candidate.MobileNumber;
model.PaidAmount = candidate.PaidAmount;
model.PaymentStatus = candidate.PaymentStatus;
model.RecurringTitle = db.RecurringTypes.Find(candidate.RefRecurringTypeId).RecurringTitle;
model.SalesAssociateName = db.UserAccountDetails.Find(candidate.RefSalesAssociate).RocketName;
model.ServiceName = db.SalesServiceMasters.Find(candidate.RefServiceId).ServiceName;
model.Remarks = candidate.Remarks;
model.TechnologyName = db.TechnologyMasters.Find(candidate.TechnologyId).TechTitle;
model.TotalAmount = candidate.TotalAmount;
model.VisaStatus = candidate.VisaStatus;
expertCVModels.Add(model);
}
return(expertCVModels);
}
public ActionResult ChangeStatus(string status, int cid, string message)
{
try
{
dashrdku_database db = new dashrdku_database();
FollowUpMaster model = new FollowUpMaster();
UserInfoModel user = Session["userInfo"] as UserInfoModel;
model.RefCandidateId = cid;
model.FollowUpBy = user.UserRocketName;
model.FollowUpDate = DateTime.Now.Date;
model.FollowUpTime = DateTime.Now.TimeOfDay;
model.FollowUpMessage = message;
model.FollowUpStatus = status;
db.FollowUpMasters.Add(model);
db.SaveChanges();
TempData["alert"] = new AlertBoxModel()
{
Type = "Success", Message = "Follow Up Message Saved!"
};
}
catch (Exception ex)
{
TempData["alert"] = new AlertBoxModel()
{
Type = "Error", Message = ex.Message
};
}
return(RedirectToAction("GetTimeLine2"));
}
public List <CandidateDetailBoardModel> GetDetails()
{
List <CandidateDetailBoardModel> candidateDetails = new List <CandidateDetailBoardModel>();
dashrdku_database db = new dashrdku_database();
List <CandidateMaster> list = db.CandidateMasters.Where(a => a.CandidateStatus != "Deleted").ToList();
for (int i = 0; i < list.Count / 2; i++)
{
CandidateDetailBoardModel m = new CandidateDetailBoardModel();
m = GetCandidate(list[i].CandidateId);
if (m.CandidateName == "" || m.CandidateName.ToLower().Contains("other"))
{
continue;
}
;
candidateDetails.Add(m);
}
return(candidateDetails);
}
