public ActionResult Action(tblDistributor objSubmit) { if (objSubmit.ID == 0) { objSubmit.DateCreated = DateTime.Now; objSubmit.DateUpdated = DateTime.Now; objSubmit.IsDeleted = false; objSubmit.IsShow = true; distributorRepository.Add(objSubmit); } else { var obj = distributorRepository.GetById <tblDistributor>(objSubmit.ID); UpdateModel(obj); objSubmit.DateUpdated = DateTime.Now; distributorRepository.Update(obj); } return(Json(new { Error = false }, JsonRequestBehavior.AllowGet)); }
public ActionResult ApprovDealerList(string DealerList) { string Message = "Successfully Approved ..."; try { string[] Row = DealerList.Split('|'); string[] Col; string sPass = ""; StreamReader objReader; Stream objStream; string sSMS = "WelCome To Unitech ..."; foreach (string itm in Row) { Col = itm.Split(','); if (Col[0].ToString() != "") { tblDistributor o = (from a in db.tblDistributors where a.MstCode == Convert.ToInt32(Col[0]) select a).SingleOrDefault(); o.ApprovID = SessionMaster.UserID; db.SubmitChanges(); if (Col[1].ToString().Length == 10) { objStream = WebRequest.Create("http://216.245.209.132/rest/services/sendSMS/sendGroupSms?AUTH_KEY=8d2f63772eef7559f01d321c6868e5bb&message=" + sSMS + "&senderId=UNITEC&routeId=1&mobileNos=" + Col[1] + "&smsContentType=english").GetResponse().GetResponseStream(); objReader = new StreamReader(objStream); objReader.Close(); } } } } catch (Exception ex) { Message = ex.Message; } ///List<tblDistributor> oList = (from a in db.tblDistributors where a.DistributorID > 0 where (int?)a.ApprovID == 0 select a).ToList(); //return Json(oList, JsonRequestBehavior.AllowGet); return(Json(Message, JsonRequestBehavior.AllowGet)); }
public ActionResult AddDistributor(string txtName, string txtCity, string txtAddress, string txtNIC, string txtNTN, string txtMoblie, string txtContactNo, string txtReferredBy) { try { int assignedID = 0; string mob = txtMoblie.Replace("-", ""); mob = mob.Replace(" ", String.Empty); using (linqDBContext db = new linqDBContext()) { var q = (from us in db.tblRetails where us.name == "Distributors" select us.id).FirstOrDefault(); if (q > 0) { retailType = q; } var chk = (from us in db.tblUsers where us.userName == mob select us).FirstOrDefault(); if (chk != null) { return(Json(new JsonResult() { Data = 0 }, JsonRequestBehavior.AllowGet)); } else { Random rn = new Random(); string pwd = rn.Next(1000, 9999).ToString(); tblDistributor it = new tblDistributor(); it.Name = txtName; it.City = txtCity; it.Address = txtAddress; it.NIC = txtNIC; it.NTN = txtNTN; it.Moblie = mob; it.ContactNo = txtContactNo; it.ReferredBy = txtReferredBy; db.tblDistributors.Add(it); db.SaveChanges(); assignedID = it.id; tblUser u = new tblUser(); u.userName = mob; u.password = pwd; u.status = "Pending"; u.localID = assignedID; u.type = retailType; tblMessage tm = new tblMessage(); tm.message = "New User Created with User Name " + mob + " And Password " + pwd; tm.sent_time = DateTime.Now; tm.isSent = false; db.tblMessages.Add(tm); db.tblUsers.Add(u); db.SaveChanges(); return(Json(new JsonResult() { Data = assignedID }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }