public ActionResult Index([Bind(Include = "ProductsCapabilityId,CompanyId,Name,Description,CreatedBy,CreatedDate,ModifiedBy,ModifiedDate")] ProductsCapability productsCapability)
{
ViewBag.productsCapabilities = db.ProductsCapabilities.Where(a => a.CompanyId == productsCapability.CompanyId).ToList();
ViewBag.CompanyId = productsCapability.CompanyId;
if (ModelState.IsValid)
{
if (productsCapability.ProductsCapabilityId == 0)
{
productsCapability.CreatedDate = DateTime.Now;
productsCapability.ModifiedDate = DateTime.Now;
db.ProductsCapabilities.Add(productsCapability);
}
else
{
var record = db.ProductsCapabilities.FirstOrDefault(a => a.ProductsCapabilityId == productsCapability.ProductsCapabilityId);
record.Name = productsCapability.Name;
record.CompanyId = productsCapability.CompanyId;
record.ModifiedDate = DateTime.Now;
db.Entry(record).State = EntityState.Modified;
}
db.SaveChanges();
return(RedirectToAction("Index", new { companyId = productsCapability.CompanyId }));
}
return(View(productsCapability));
}
//[ActionName("Login")]
//public HttpResponseMessage Login(string UserName,string Password)
public HttpResponseMessage Login()
{
string UserName = HttpContext.Current.Request.Form["UserName"];
string Password = HttpContext.Current.Request.Form["Password"];
string DeviceType = HttpContext.Current.Request.Form["DeviceType"];
string DeviceToken = HttpContext.Current.Request.Form["DeviceToken"];
var response = new LoginResponse();
response.Flag = "false";
response.UserId = 0;
if (!string.IsNullOrEmpty(UserName) && !string.IsNullOrEmpty(Password))
{
if (Membership.ValidateUser(UserName, Password))
{
MembershipUser currentUser = Membership.GetUser(UserName);
Guid currentUserId = new Guid(currentUser.ProviderUserKey.ToString());
var userrecord = _db.ProformaUsers.FirstOrDefault(a => a.AspUserId == currentUserId);
if (null != userrecord)
{
//bool IsPasswordValid = BCrypt.Net.BCrypt.Verify(Password, userrecord.Password);
// if (IsPasswordValid)
// {
userrecord.IsActive = true;
userrecord.DeviceType = DeviceType;
userrecord.DeviceToken = DeviceToken;
_db.Entry(userrecord).State = System.Data.Entity.EntityState.Modified;
_db.SaveChanges();
response.Flag = "true";
response.MESSAGE = "Login successful";
response.UserId = Convert.ToInt32(userrecord.UserID);
//}
// else
// {
// response.MESSAGE = "Invalid Password";
// }
}
else
{
response.MESSAGE = "Invalid Email Address";
}
}
else
{
response.MESSAGE = "Login fail";
}
}
else
{
response.MESSAGE = "Login fail";
}
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
public JsonResult SaveEvent(string EventInfo)
{
var serializer = new JavaScriptSerializer();
var eventInfo = serializer.Deserialize(EventInfo, typeof(ProformaEventsModel));
ProformaEventsModel model = (dynamic)(eventInfo);
Event _event = new Event();
if (model.EventId > 0)
{
_event = _db.Events.FirstOrDefault(a => a.EventId == model.EventId);
_event.ModifiedDate = DateTime.Now;
}
else
{
_event.CreatedDate = DateTime.Now;
_event.EventSubHeading = "";
}
_event.EventTitle = model.EventTitle;
_event.Description = model.EventDescription;
_event.EventSubHeading = model.ShortDescription;
//_event.EventEndDate = model.EventEndDate;
//_event.EventStartDate = model.EventStartDate;
_event.Image = "http://psgapp.proforma.com//Uploads/" + model.EventImage;
_event.Status = "Active";
if (model.EventId > 0)
{
_db.Entry(_event).State = EntityState.Modified;
}
else
{
_db.Events.Add(_event);
}
_db.SaveChanges();
ProformaEventResponseModel response = new ProformaEventResponseModel();
response.EventId = _event.EventId;
response.EventStartDate = _event.EventStartDate;
response.EventEndDate = _event.EventEndDate;
response.Description = _event.Description;
response.EventTitle = _event.EventTitle;
response.EventImage = _event.Image;
response.Message = "Success";
return(Json(response, JsonRequestBehavior.AllowGet));
}
// [ActionName("DeleteUserNotification")]
public HttpResponseMessage DeleteUserNotification(long UserId, long NotificationId)
{
DeleteNotificationModel _DeleteNotification = new DeleteNotificationModel();
_DeleteNotification.MESSAGE = "Delete User Notification";
_DeleteNotification.Flag = "false";
var _NotificationToDelete = _db.UserNotifications.FirstOrDefault(a => a.UserId == UserId && a.NotificationId == NotificationId);
if (null != _NotificationToDelete)
{
_DeleteNotification.Flag = "true";
_DeleteNotification.NotificationId = NotificationId;
_NotificationToDelete.Status = Status.Deleted.ToString();
_NotificationToDelete.ModifiedBy = UserId;
_NotificationToDelete.ModifiedDate = DateTime.Now;
_db.Entry(_NotificationToDelete).State = EntityState.Modified;
_db.SaveChanges();
_DeleteNotification.DeleteStatus = "Notification deleted successfully";
}
else
{
_DeleteNotification.DeleteStatus = "Notification was not found";
}
return(Request.CreateResponse(HttpStatusCode.OK, _DeleteNotification));
}
public ActionResult ProformaProgramsPartial(ProformaProgramModel model)
{
var record = new ProformaProgram();
if (model.ProformaProgramId > 0)
{
record = _db.ProformaPrograms.FirstOrDefault(a => a.ProformaProgramId == model.ProformaProgramId);
}
record.Name = model.Name;
record.CompanyId = model.CompanyId;
if (model.ProformaProgramId == 0)
{
record.CreatedDate = DateTime.Now;
_db.ProformaPrograms.Add(record);
}
else
{
record.ModifiedDate = DateTime.Now;
_db.Entry(record).State = EntityState.Modified;
}
_db.SaveChanges();
ProformaProgramModel _ProformaProgramModel = GetProFormaPrograms(model.CompanyId);
return(PartialView(_ProformaProgramModel));
}
public ActionResult RegisterExistingUsers()
{
// Attempt to register the user
var lstUsers = _db.ProformaUsers.Where(u => u.AspUserId == null).ToList();
foreach (var user in lstUsers)
{
MembershipCreateStatus createStatus;
MembershipUser newUser = Membership.CreateUser(user.Email, "Proforma2016!", "", "question", "answer", true, out createStatus);
if (null != newUser)
{
user.AspUserId = new Guid(newUser.ProviderUserKey.ToString());
_db.Entry(user).State = System.Data.Entity.EntityState.Modified;
_db.SaveChanges();
}
}
return(View());
}
public ActionResult UpdateCompanyInfo()
{
var _Companies = _db.Companies.ToList();
if (_Companies != null || _Companies.Count() > 0)
{
foreach (var com in _Companies)
{
var _Company = _db.Companies.FirstOrDefault(a => a.CompanyId == com.CompanyId);
string address = com.StreetAddress.Trim() + "+" + com.City.Trim() + "+" + com.ZipCode.Trim() + "+" + com.State.Trim();
var latlng = GetLatitudeLongitute(address);
if (!string.IsNullOrEmpty(latlng))
{
var arrlatlng = latlng.Split(new[] { '_' }).ToList();
_Company.Latitude = Convert.ToDecimal(arrlatlng[0]);
_Company.Longitude = Convert.ToDecimal(arrlatlng[1]);
}
_db.Entry(_Company).State = EntityState.Modified;
_db.SaveChanges();
}
}
return(View());
}
public ActionResult CompanyProgramsNProducts()
{
string[] stringSeparators = new string[] { ",", ". ", "\n", ";" };
SourcingGuideDevEntities _db = new SourcingGuideDevEntities();
var companies = _db.Companies.ToList();
foreach (var comp in companies)
{
//Manage Proforma Programs
var proformaProgram = comp.ProformaPrograms;
if (!string.IsNullOrEmpty(proformaProgram))
{
var lstProformaPrograms = proformaProgram.Split(stringSeparators, StringSplitOptions.RemoveEmptyEntries); // proformaProgram.Split(new[] { ",", ". ", "\n", ";" }).ToList();
foreach (var pp in lstProformaPrograms)
{
var strProformaProgram = pp.Trim();
if (!string.IsNullOrEmpty(strProformaProgram))
{
var _ProformaProgram = _db.ProformaPrograms.FirstOrDefault(p => p.CompanyId == comp.CompanyId && p.Name == strProformaProgram);
if (null == _ProformaProgram)
{
_ProformaProgram = new ProformaProgram();
_ProformaProgram.CompanyId = comp.CompanyId;
_ProformaProgram.Name = strProformaProgram;
_ProformaProgram.CreatedDate = DateTime.Now;
_db.ProformaPrograms.Add(_ProformaProgram);
}
else
{
_ProformaProgram.Name = strProformaProgram;
_ProformaProgram.ModifiedDate = DateTime.Now;
_db.Entry(_ProformaProgram).State = EntityState.Modified;
}
}
}
}
//Manage ProductsCapabilities
var productsCapability = comp.ProductsNCapabilities;
if (!string.IsNullOrEmpty(productsCapability))
{
var lstProductsCapabilities = productsCapability.Split(stringSeparators, StringSplitOptions.RemoveEmptyEntries); //productsCapability.Split(new[] { ',', '. ', '\n', ';' }).ToList();
foreach (var pc in lstProductsCapabilities)
{
var strProductsCapability = pc.Trim();
if (!string.IsNullOrEmpty(strProductsCapability))
{
var _ProductsCapability = _db.ProductsCapabilities.FirstOrDefault(p => p.CompanyId == comp.CompanyId && p.Name == strProductsCapability);
if (null == _ProductsCapability)
{
_ProductsCapability = new ProductsCapability();
_ProductsCapability.CompanyId = comp.CompanyId;
_ProductsCapability.Name = strProductsCapability;
_ProductsCapability.CreatedDate = DateTime.Now;
_db.ProductsCapabilities.Add(_ProductsCapability);
}
else
{
_ProductsCapability.Name = strProductsCapability;
_ProductsCapability.ModifiedDate = DateTime.Now;
_db.Entry(_ProductsCapability).State = EntityState.Modified;
}
}
}
}
_db.SaveChanges();
}
ViewBag.OperationStatus = "ProformaPrograms/ProductsCapabilities updated successfully!";
return(View());
}
