public JsonResult ChangePassword(RegisterUserModel reg)
{
var user = db.USERs.Where(c => c.ID == reg.ID).FirstOrDefault();
user.Password = reg.Password;
db.Entry(user).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(Json(new { status = "Ok", code = 400, msg = "Password Changed" }, JsonRequestBehavior.AllowGet));
}
public JsonResult AddNewUser(RegisterUserModel rgsterUserformdata)
{
if (Session["UserId"] == null)
{
return(Json(new { status = "Ok", code = 401, msg = "Unauthorized Access", data = User }, JsonRequestBehavior.AllowGet));
}
else
{
#region Adduser
//checking validation
//if (ModelState.IsValid)
//{
try
{
//assigning form data to table model
var rgsteruser = new USER();
rgsteruser.FirstName = rgsterUserformdata.FirstName;
rgsteruser.Email = rgsterUserformdata.Email;
rgsteruser.UserName = rgsterUserformdata.UserName;
rgsteruser.Password = rgsterUserformdata.Password;
rgsteruser.ProfilePicPath = rgsterUserformdata.PicturePath;
rgsteruser.IsActive = true;
rgsteruser.Status = "Active";
rgsteruser.DateCreated = DateTime.Now;
rgsteruser.CreatedBy = Convert.ToInt32(Session["UserId"].ToString());
rgsteruser.RoleId = 2;
if (rgsterUserformdata.ProfilePictureFile != null)
{
UploadProfilePicture(rgsterUserformdata);
}
rgsteruser.ProfilePicPath = rgsterUserformdata.PicturePath;
//insert to daatbase
db.USERs.Add(rgsteruser);
db.SaveChanges();
return(Json(new { status = "Ok", code = 200, msg = "No User Found", data = User }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
//if any error
return(Json(new { status = "Bad Gateway", code = 400, msg = "Failed" + ex.Message, data = "" }, JsonRequestBehavior.AllowGet));
}
//}
//else
//{
// //Validation Failed
// return Json(new { status = "Bad Gateway", code = 400, msg = "Validation Failed", data = "" }, JsonRequestBehavior.AllowGet);
//}
#endregion
}
}
public void AddNotification(NotificationModel nmodel)
{
notification nm = new notification();
nm.NotificationText = nmodel.NotificationText;
nm.N_To = nmodel.N_To;
nm.N_from = nmodel.N_from;
nm.IsRead = false;
nm.dateCreated = DateTime.Now;
db = new LeadCRMEntities();
db.notifications.Add(nm);
db.SaveChanges();
}
public JsonResult DeleteNotification()
{
int userid = Convert.ToInt32(Session["UserId"].ToString());
var notifications = db.notifications.Where(p => p.N_To == userid && p.IsRead == false).OrderByDescending(p => p.ID).ToList();
foreach (notification n in notifications)
{
n.IsRead = true;
db.Entry(n).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
return(Json(new { code = 200 }, JsonRequestBehavior.AllowGet));
}
//public static DataTable ToDataTable<T>(List<T> items)
//{
// DataTable dataTable = new DataTable(typeof(T).Name);
// //Get all the properties
// PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
// foreach (PropertyInfo prop in Props)
// {
// //Defining type of data column gives proper data table
// var type = (prop.PropertyType.IsGenericType && prop.PropertyType.GetGenericTypeDefinition() == typeof(Nullable<>) ? Nullable.GetUnderlyingType(prop.PropertyType) : prop.PropertyType);
// //Setting column names as Property names
// dataTable.Columns.Add(prop.Name, type);
// }
// foreach (T item in items)
// {
// var values = new object[Props.Length];
// for (int i = 0; i < Props.Length; i++)
// {
// //inserting property values to datatable rows
// values[i] = Props[i].GetValue(item, null);
// }
// dataTable.Rows.Add(values);
// }
// return dataTable;
//}
public bool insertBulk(List <LeadModel> m)
{
try
{
if (m.Count > 0)
{
foreach (LeadModel emp in m)
{
string da = "20-07-15";
Lead objlm = new Lead();
objlm.AssignedToUSerID = 2;
objlm.Budget = emp.Budget;
objlm.ClientName = emp.ClientName;
objlm.ContactNo = emp.ContactNo;
objlm.Created_By = emp.Created_By;
objlm.DateCreated = emp.DateCreated;
objlm.Email = emp.Email;
objlm.IntialRequirements = emp.IntialRequirements;
objlm.IPAddress = emp.IPAddress;
objlm.Is_Active = emp.Is_Active;
objlm.LastStatus = emp.LastStatus;
objlm.LeadDate = DateTime.Now;
objlm.LeadStatus = emp.LeadStatus;
objlm.LeadTime = emp.LeadTime;
objlm.LeadType = emp.LeadTypeID;
objlm.Location = emp.Location;
objlm.NextPlan = emp.NextPlan;
objlm.Status = emp.Status;
objlm.TimeZone = emp.TimeZoneID;
db.Leads.Add(objlm);
}
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
return(false);
}
}
public JsonResult AddNewLead(LeadModel newlead)
{
if (Session["UserId"] == null)
{
return(Json(new { status = "Ok", code = 401, msg = "Unauthorized Access", data = "" }, JsonRequestBehavior.AllowGet));
}
else
{
#region AddLead
//checking validation
//if (ModelState.IsValid)
//{
try
{
if (newlead.ID <= 0 || newlead.ID == null)
{
//assigning form data to table model
var newleadrgstr = new Lead();
newleadrgstr.ClientName = newlead.ClientName;
newleadrgstr.LeadDate = newlead.LeadDate;
newleadrgstr.LeadTime = newlead.LeadTime;
newleadrgstr.LeadType = newlead.LeadTypeID;
newleadrgstr.ContactNo = newlead.ContactNo;
newleadrgstr.Email = newlead.Email;
newleadrgstr.TimeZone = newlead.TimeZoneID;
newleadrgstr.Location = newlead.Location;
newleadrgstr.IPAddress = newlead.IPAddress;
newleadrgstr.LeadStatus = newlead.LeadStatus;
newleadrgstr.Budget = newlead.Budget;
newleadrgstr.NextPlan = newlead.NextPlan;
newleadrgstr.LastStatus = newlead.LastStatus;
newleadrgstr.IntialRequirements = newlead.IntialRequirements;
newleadrgstr.AssignedToUSerID = newlead.AssignedToUSerID;
newleadrgstr.DateCreated = DateTime.Now;
newleadrgstr.Is_Active = true;
newleadrgstr.Status = "Active";
newleadrgstr.Created_By = Convert.ToInt32(Session["UserId"]);
//var adminId = Convert.ToInt32(Session["UserId"].ToString());
//var user = db.USERs.Where(c => c.ID == newlead.AssignedToUSerID).FirstOrDefault();
////var admin = db.USERs.Where(c => c.ID == adminId).FirstOrDefault();
//var mes = "Dear " + user.UserName + " a lead has been assigned to you";
//var body = "<p>Email From: {0} ({1})</p><p>Message:</p><p>{2}</p>";
//var message = new MailMessage();
//message.To.Add(new MailAddress(user.Email)); // replace with valid value
//message.From = new MailAddress("*****@*****.**"); // replace with valid value
//message.Subject = "You have been assigned a Lead";
//message.Body = string.Format(body, "Rashid Rahim", "*****@*****.**", mes);
//message.IsBodyHtml = true;
//using (var smtp = new SmtpClient())
//{
// var credential = new NetworkCredential
// {
// UserName = "******", // replace with valid value
// Password = "******" // replace with valid value
// };
// smtp.Credentials = credential;
// smtp.Host = "smtp-mail.outlook.com";
// smtp.Port = 587;
// smtp.EnableSsl = true;
// smtp.SendMailAsync(message);
//}
//insert to daatbase
db.Leads.Add(newleadrgstr);
db.SaveChanges();
NotificationModel nm = new NotificationModel();
nm.N_To = newlead.AssignedToUSerID;
nm.NotificationText = "You have Assigned to New Lead";
nm.N_from = Convert.ToInt32(Session["UserId"]);
nm.IsRead = false;
nm.dateCreated = DateTime.Now;
AddNotification(nm);
}
else
{
if (Convert.ToInt32(Session["RoleID"]) == 1)
{
var result = db.Leads.SingleOrDefault(b => b.ID == newlead.ID);
if (result != null)
{
result.ClientName = newlead.ClientName;
result.LeadDate = newlead.LeadDate;
result.LeadTime = newlead.LeadTime;
result.LeadType = newlead.LeadTypeID;
result.ContactNo = newlead.ContactNo;
result.Email = newlead.Email;
result.TimeZone = newlead.TimeZoneID;
result.Location = newlead.Location;
result.IPAddress = newlead.IPAddress;
result.LeadStatus = newlead.LeadStatus;
result.Budget = newlead.Budget;
result.NextPlan = newlead.NextPlan;
result.LastStatus = newlead.LastStatus;
result.IntialRequirements = newlead.IntialRequirements;
result.AssignedToUSerID = newlead.AssignedToUSerID;
result.DateCreated = DateTime.Now;
result.Is_Active = true;
result.Status = "Active";
result.Created_By = Convert.ToInt32(Session["UserId"]);
db.SaveChanges();
NotificationModel nm = new NotificationModel();
nm.N_To = newlead.AssignedToUSerID;
nm.NotificationText = "Lead has been Edited";
nm.N_from = Convert.ToInt32(Session["UserId"]);
nm.IsRead = false;
nm.dateCreated = DateTime.Now;
AddNotification(nm);
}
}
else
{
var result = db.Leads.SingleOrDefault(b => b.ID == newlead.ID);
if (result != null)
{
result.ClientName = newlead.ClientName;
result.LeadDate = newlead.LeadDate;
result.LeadTime = newlead.LeadTime;
result.LeadType = newlead.LeadTypeID;
result.ContactNo = newlead.ContactNo;
result.Email = newlead.Email;
result.TimeZone = newlead.TimeZoneID;
result.Location = newlead.Location;
result.IPAddress = newlead.IPAddress;
result.LeadStatus = newlead.LeadStatus;
result.Budget = newlead.Budget;
result.NextPlan = newlead.NextPlan;
result.LastStatus = newlead.LastStatus;
result.IntialRequirements = newlead.IntialRequirements;
result.AssignedToUSerID = newlead.AssignedToUSerID;
result.DateCreated = DateTime.Now;
result.Is_Active = true;
result.Status = "Active";
result.Created_By = Convert.ToInt32(Session["UserId"]);
db.SaveChanges();
// use fro notification for all Admin Roles
db = new LeadCRMEntities();
var adminslist = db.USERs.Where(p => p.RoleId == 1).ToList();
for (int i = 0; i < adminslist.Count; i++)
{
NotificationModel nm = new NotificationModel();
nm.N_To = adminslist[i].ID;
nm.NotificationText = "Lead has been Edited";
nm.N_from = Convert.ToInt32(Session["UserId"]);
nm.IsRead = false;
nm.dateCreated = DateTime.Now;
AddNotification(nm);
}
}
}
}
return(Json(new { status = "Ok", code = 200, msg = "No User Found", data = "" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
//if any error
return(Json(new { status = "Bad Gateway", code = 400, msg = "Failed" + ex.Message, data = "" }, JsonRequestBehavior.AllowGet));
}
//}
//else
//{
// //foreach (var eve in ModelState.EntityValidationErrors)
// //{
// // Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
// // eve.Entry.Entity.GetType().Name, eve.Entry.State);
// // foreach (var ve in eve.ValidationErrors)
// // {
// // Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
// // ve.PropertyName, ve.ErrorMessage);
// // }
// //}
// //Validation Failed
// return Json(new { status = "Bad Gateway", code = 400, msg = "Validation Failed", data = "" }, JsonRequestBehavior.AllowGet);
//}
#endregion
}
}