public ActionResult DialogUpdateHSIP(Order_TB_Header value) { EmailJob email = new EmailJob(); context.Configuration.ProxyCreationEnabled = false; mascisEntities db_master = new mascisEntities(); Order_TB_Header table = db_master.Order_TB_Header.FirstOrDefault(o => o.OrderNumber == value.OrderNumber); TempData["OrderNumber"] = value.OrderNumber; TempData["FacilityCode"] = value.FacilityCode; TempData["StartDate"] = value.StartDate; TempData["EndDate"] = value.EndDate; value.OrderTypeId = 2; value.OrderStatusId = 1; value.EditedDate = DateTime.Now; value.EditedBy = new UserManagement().getCurrentuser(); db_master.Entry(table).CurrentValues.SetValues(value); db_master.Entry(table).State = EntityState.Modified; db_master.SaveChanges(); if (value.FinalSubmission == true && value.RFSO_SentBackTofacility == false) { email.OrderSentToScto(value.FacilityCode, value.OrderNumber, "TB"); } if (value.FinalSubmission == true && value.RFSO_SentBackTofacility == true) { email.OrderReSentToScto(value.FacilityCode, value.OrderNumber, "TB"); } return(Json(value, JsonRequestBehavior.AllowGet)); }
public Boolean UpdateSAP(string order_no) { try { var x = GetRecordByKey(order_no); if (x != null) { x.OrderNumber = order_no; //x.FacilityCode = mFacilityCode; //x.DatePrepared = mDatePrepared; //x.EditedBy = new UserManagement().getCurrentuser(); //x.EditedDate = DateTime.Now; //x.DateExpected = mDateExpected; x.OrderStatusId = 4; //x.OrderStatusIdChangedBy = new UserManagement().getCurrentuser(); //x.OrderStatusIdDateChanged = DateTime.Now; context.Entry(x).State = EntityState.Modified; context.SaveChanges(); ////SaveLog(x); } //Send Out Confirmation Notifications to the facility //EmailJob obx = new EmailJob(); //if (x.OrderStatusId == 4) //{ // obx.SendEmailSAP(x.FacilityCode, x.OrderNumber); //} return(true); } catch (Exception x) { throw (x); } }
public ActionResult SaveExpectedReport(LMIS_ExpectedReport value, string fc, string productcategory, string startdate, string enddate) { DateTime sDate = DateTime.ParseExact(startdate, "dd/MM/yyyy", null); DateTime eDate = DateTime.ParseExact(enddate, "dd/MM/yyyy", null); int facility = int.Parse(fc); int pc = int.Parse(productcategory); context.Configuration.ProxyCreationEnabled = false; mascisEntities db_master = new mascisEntities(); LMIS_ExpectedReport table = db_master.LMIS_ExpectedReport.FirstOrDefault(o => o.facility_code == facility && o.product_category == pc && o.start_date == sDate && o.end_date == eDate); ExpectedReports obj = new ExpectedReports(); if (table == null) { //db.Entry(table).CurrentValues.SetValues(value); obj.facility_code = facility; obj.product_category = pc; obj.start_date = sDate; obj.end_date = eDate; //db_master.SaveChanges(); } else { //db.Entry(table).CurrentValues.SetValues(value); obj.facility_code = facility; obj.product_category = pc; obj.start_date = sDate; obj.end_date = eDate; db_master.Entry(table).State = EntityState.Modified; context.Entry(table).CurrentValues.SetValues(table); } obj.Update(); return(Json(value, JsonRequestBehavior.AllowGet)); //return RedirectToAction("DataSourceRFSO"); }
public Boolean Update() { try { var x = GetRecordByKey(mOrderNumber, mID); if (x != null) { x.OrderNumber = mOrderNumber; x.FacilityCode = mFacilityCode; x.StartDate = mStartDate; x.EndDate = mEndDate; x.ID = mID; x.Quantity = mQuantity; context.Entry(x).State = EntityState.Modified; context.SaveChanges(); } else { Save(); } return(true); } catch (Exception x) { throw (x); } }
public Boolean UpdateSAP(string order_no) { try { var x = GetRecordByKey(order_no); if (x != null) { x.OrderNumber = order_no; //x.FacilityCode = mFacilityCode; //x.DatePrepared = mDatePrepared; //x.EditedBy = new UserManagement().getCurrentuser(); //x.EditedDate = DateTime.Now; //x.DateExpected = mDateExpected; x.OrderStatusId = 4; //x.OrderStatusIdChangedBy = new UserManagement().getCurrentuser(); //x.OrderStatusIdDateChanged = DateTime.Now; context.Entry(x).State = EntityState.Modified; context.SaveChanges(); ////SaveLog(x); } return(true); } catch (Exception x) { throw (x); } }
public async Task <ActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { if (Request["FacilityList"] != null && Request["FacilityList"] != string.Empty) { string facility = Request["FacilityList"].ToString(); model.FacilityId = System.Convert.ToInt32(facility); } if (Request["UserTypeList"] != null && Request["UserTypeList"] != string.Empty) { string user_type = Request["UserTypeList"].ToString(); model.UserTypeId = System.Convert.ToInt32(user_type); } var hased = MD5Hash(model.Password); var user = new ApplicationUser { UserName = model.UserName, Email = model.Email, PhoneNumber = model.PhoneNumber, Name = model.Name, UserTypeId = System.Convert.ToInt32(model.UserTypeId), FacilityId = model.FacilityId, MD5Hash = hased, LockoutEnabled = false }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { //await SignInManager.SignInAsync(user, isPersistent: false, rememberBrowser: false); if (Request["RolesList"] != null && Request["RolesList"] != string.Empty) { string user_role = Request["RolesList"].ToString(); model.UserRole = user_role; } await this.UserManager.AddToRoleAsync(user.Id, model.UserRole); var contact = db.fo_contact_person.FirstOrDefault(o => o.cp_name.Trim() == model.Name.Trim()); if (contact != null) { contact.User_ID = user.Id; db.Entry(contact).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } // For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>"); return(RedirectToAction("Register", "Account")); } AddErrors(result); } // If we got this far, something failed, redisplay form return(View(model)); }
public ActionResult Edit([Bind(Include = "Id,Subject,Description,StartTime,EndTime,AllDay,Recurrence,RecurrenceRule,VenueCode,ParticipationInvitee,ParticipationAttendee,ExpectedOutput,Objective,ActivityClassificationId,OrganId,DirectorateId,SectorId,SourceOfFundingId,FundingTypeId,PublicHoliday,CostEstimates,MeetingType,Approved_By,Date_Approved,Added_By,Date_Added,City,ActivityImplemented,ActivityImplementedComment,ApprovedActivity,IsBlockAppointment,BlockForAll,ActivityForwarded,Organizer")] ScheduleEvent scheduleEvent) { if (ModelState.IsValid) { db.Entry(scheduleEvent).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(scheduleEvent)); }
public ActionResult DialogUpdateMAULT(Order_MAULT_Header value) { context.Configuration.ProxyCreationEnabled = false; mascisEntities db_master = new mascisEntities(); Order_MAULT_Header table = db_master.Order_MAULT_Header.FirstOrDefault(o => o.OrderNumber == value.OrderNumber); TempData["OrderNumber"] = value.OrderNumber; value.OrderStatusId = 1; value.ProductCategoryId = 13; value.EditedDate = DateTime.Now; value.EditedBy = new UserManagement().getCurrentuser(); db_master.Entry(table).CurrentValues.SetValues(value); db_master.Entry(table).State = EntityState.Modified; db_master.SaveChanges(); //if (value.FinalSubmission == true && value.RFSO_SentBackTofacility == false) //{ // obx.SendEmail(value.FacilityCode, value.OrderNumber); //} return(Json(value, JsonRequestBehavior.AllowGet)); }
public ActionResult DialogInsert(A_Product value /*, string testdata, string testdata2, string testdata3*/) { try { var _feedback = db.A_Product.FirstOrDefault(f => f.product_code == value.product_code); db.Configuration.ProxyCreationEnabled = false; if (_feedback == null) { db.A_Product.Add(value); } else { db.Entry(_feedback).CurrentValues.SetValues(value); db.Entry(_feedback).State = EntityState.Modified; } if (value.Basic_Unit == 0) { value.Basic_Unit = null; } var recsaved = db.SaveChanges(); // msg = value.product_description + " Saved Successfully"; return(Json(new { msg = "Successfully added " + value.product_description, JsonRequestBehavior.AllowGet })); } catch (Exception ex) { throw ex; } // return Json(msg, JsonRequestBehavior.AllowGet); }
public ActionResult BatchUpdateSMC(string key, List <Order_SMC_SLM_Physical_Count> changed, List <Order_SMC_SLM_Physical_Count> added, List <Order_SMC_SLM_Physical_Count> deleted) { mascisEntities dbCase = new mascisEntities(); //Performing insert operation if (added != null && added.Count() > 0) { foreach (var temp in added) { string iDate = temp.DateOfPhysicalCount.ToString(); DateTime oDate = DateTime.Parse(iDate); temp.DateOfPhysicalCount = oDate; dbCase.Order_SMC_SLM_Physical_Count.Add(temp); temp.Total = temp.Quantity_Dispensary; temp.DateAdded = DateTime.Now; temp.AddedBy = new UserManagement().getCurrentuser(); temp.record_status = true; } } dbCase.SaveChanges(); if (changed != null && changed.Count() > 0) { foreach (var temp in changed) { string iDate = temp.DateOfPhysicalCount.ToString(); DateTime oDate = DateTime.Parse(iDate); temp.DateOfPhysicalCount = oDate; Order_SMC_SLM_Physical_Count old = dbCase.Order_SMC_SLM_Physical_Count. FirstOrDefault(o => o.FacilityCode == temp.FacilityCode && o.DateOfPhysicalCount == temp.DateOfPhysicalCount && o.ProductCode == temp.ProductCode && o.BatchNo == temp.BatchNo); if (old != null) { dbCase.Entry(old).CurrentValues.SetValues(temp); temp.Total = temp.Quantity_Dispensary; temp.DateAdded = DateTime.Now; temp.AddedBy = new UserManagement().getCurrentuser(); temp.record_status = true; } else { dbCase.Order_SMC_SLM_Physical_Count.Add(temp); temp.Total = temp.Quantity_Dispensary; temp.DateAdded = DateTime.Now; temp.AddedBy = new UserManagement().getCurrentuser(); temp.record_status = true; } } } dbCase.SaveChanges(); //Performing delete operation if (deleted != null && deleted.Count() > 0) { foreach (var temp in deleted) { dbCase.Order_SMC_SLM_Physical_Count.Remove(dbCase.Order_SMC_SLM_Physical_Count.FirstOrDefault(o => o.FacilityCode == temp.FacilityCode && o.DateOfPhysicalCount == temp.DateOfPhysicalCount && o.ProductCode == temp.ProductCode && o.BatchNo == temp.BatchNo)); } } dbCase.SaveChanges(); //return RedirectToAction("BatchDataSMC"); var data = 0; return(Json(data, JsonRequestBehavior.AllowGet)); }
//public ActionResult BatchDataKount(DataManager dataManager) //{ // IEnumerable DataSource = context.WebTemplate_ARV_PhysicalCount.ToList(); // DataResult result = new DataResult(); // result.result = DataSource; // result.count = context.WebTemplate_ARV_PhysicalCount.Count(); // return Json(result.count, JsonRequestBehavior.AllowGet); //} public int SavePC(int FacilityCode, DateTime DateOfPhysicalCount, int product_code, string BatchNo, string Quantity_Dispensary, string Quantity_Store, DateTime?ExpiryDate, string Total, string Comment) { order_hiv_rapid_test_kit_PhysicalCount obj = new order_hiv_rapid_test_kit_PhysicalCount(); int recstat = 0; obj.FacilityCode = FacilityCode; obj.DateOfPhysicalCount = DateOfPhysicalCount; obj.product_code = System.Convert.ToInt32(product_code); obj.BatchNo = BatchNo; if (Quantity_Dispensary != null && !string.IsNullOrEmpty(Quantity_Dispensary)) { obj.Quantity_Dispensary = System.Convert.ToDouble(Quantity_Dispensary); } if (Quantity_Store != null && !string.IsNullOrEmpty(Quantity_Store)) { obj.Quantity_Store = System.Convert.ToDouble(Quantity_Store); } obj.ExpiryDate = ExpiryDate; if (Total != null && !string.IsNullOrEmpty(Total)) { obj.Total = System.Convert.ToDouble(Total); } obj.Comment = Comment; try { //Check for the existance of the record var ca = context.order_hiv_rapid_test_kit_PhysicalCount.FirstOrDefault(c => c.FacilityCode == FacilityCode && c.DateOfPhysicalCount == DateOfPhysicalCount && c.product_code == product_code && c.BatchNo == BatchNo); if (ca == null) { context.order_hiv_rapid_test_kit_PhysicalCount.Add(obj); obj.DateAdded = DateTime.Now; obj.AddedBy = new UserManagement().getCurrentuser(); recstat = context.SaveChanges(); // recstat = obj.household_number; } else { order_hiv_rapid_test_kit_PhysicalCount table = context.order_hiv_rapid_test_kit_PhysicalCount.FirstOrDefault(c => c.FacilityCode == FacilityCode && c.DateOfPhysicalCount == DateOfPhysicalCount && c.product_code == product_code && c.BatchNo == BatchNo); // obj.household_number = ca.household_number ; context.Entry(table).CurrentValues.SetValues(obj); obj.DateAdded = DateTime.Now; obj.AddedBy = new UserManagement().getCurrentuser(); context.Entry(table).State = EntityState.Modified; recstat = context.SaveChanges(); //recstat = ca.household_number; } } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } return(recstat); }
public ActionResult SaveScto(string scto, string Telephone, string Tel, string email, string userid, int _type) { var result = string.Empty; if (_type == 1) { if (string.IsNullOrEmpty(scto)) { result = "Please type in the scto"; } else { var userexits = db.fo_SCTO_ContactPerson.FirstOrDefault(e => e.SCTO == scto); if (userexits == null) { var _userid = db.fo_SCTO_ContactPerson.FirstOrDefault(e => e.UserId == userid); if (_userid == null) { fo_SCTO_ContactPerson person = new fo_SCTO_ContactPerson(); person.SCTO = scto; person.SCTO_Email = email; person.SCTO_TelNo1 = Telephone; person.SCTO_TelNo2 = Tel; person.UserId = userid; db.fo_SCTO_ContactPerson.Add(person); try { db.SaveChanges(); result = scto + " Was saved successfully"; } catch (Exception ex) { result = ex.Message.ToString(); } } else { result = "This user was already saved as " + _userid.SCTO; } } else { result = "This SCTO name already exists"; } } } else if (_type == 2) { var userexits = db.fo_SCTO_ContactPerson.FirstOrDefault(e => e.SCTO == scto); if (userexits != null) { fo_SCTO_ContactPerson person = new fo_SCTO_ContactPerson(); person.SCTO = scto; person.SCTO_Email = email; person.SCTO_TelNo1 = Telephone; person.SCTO_TelNo2 = Tel; person.UserId = userid; try { db.Entry(userexits).CurrentValues.SetValues(person); db.Entry(userexits).State = EntityState.Modified; db.SaveChanges(); result = scto + " was updated successfully"; } catch (Exception ex) { result = ex.Message.ToString(); } } } return(Json(result, JsonRequestBehavior.AllowGet)); }