public bool ComplainInfoReply(string issueid, string respnse) { try { var currentUser = User.Identity.Name; db.syssupcomprplies.Add(new syssupcomprply { agentid = currentUser, userid = "", issueid = issueid, reply = respnse, remarks = DateTime.Now.ToString("MM-dd-yyyy h:mmtt"), status = "checking" }); db.syssupcomps.FirstOrDefault(s => s.issueid.Equals(issueid)).status = "replied"; db.SaveChanges(); return(true); } catch { return(false); } }
private void sysLog(string msg, string action) { var newObj = new syssuplog { userid = User.Identity.GetUserId(), sysaction = msg, sysdate = DateTime.Now.ToString(), status = action }; db.syssuplogs.Add(newObj); db.SaveChanges(); }
public bool DeleteRanking(string reqid) { try { var rnk = db.reqlists.FirstOrDefault(s => s.reqid.Equals(reqid)); db.reqlists.Remove(rnk); db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool SubmitRankDL(string reqid) { var currentUser = User.Identity.Name; if (!ModelState.IsValid) { return(false); } var objPO = db.reqlists.Where(e => e.sid.Equals(currentUser) && e.reqid.Contains(reqid)).FirstOrDefault(); objPO.sts = "downloaded"; db.SaveChanges(); //sysLog("Download Ranking Request : " + reqid, "Ranking"); return(true); }
public async Task <bool> AgentSubmit(rPerson model) { var uUser = model.name + model.region; var isExist = db.userapps.FirstOrDefault(s => s.userid.Equals(uUser)); if (isExist != null) { return(false); } var newAID = model.name + model.region; var user = new User { UserName = newAID, Email = newAID + "@danubeco.com", Region = model.region }; var result = await UserManager.CreateAsync(user, model.password); if (!result.Succeeded) { return(false); } var currentUser = await UserManager.FindByEmailAsync(newAID + "@danubeco.com"); await UserManager.AddToRolesAsync(currentUser.Id, model.role); db.userapps.Add(new userapp() { userid = newAID, name = model.name, role = model.role, status = "activated", login = DateTime.Today, password = model.password }); db.SaveChanges(); return(true); }
public static void Log(string msg, string action, string user) { dnbmssqlEntities db = new dnbmssqlEntities(); var newObj = new syssuplog { userid = user, sysaction = msg, sysdate = DateTime.Now.ToString(), status = action }; db.syssuplogs.Add(newObj); db.SaveChanges(); }
void ProcessParallelThread() { var Files = rProcess.GetFileToFolder(rProcess.tmpFolder, "pdf"); foreach (var xFile in Files) { try { var ftp = new ftp(@"ftp://188.121.43.20/services.danubeco.com/", "ranking"); // Upload PDF using FTP to Server Folder -> supplierx var result = ftp.Upload(Path.Combine("ranking", xFile.Name), Path.Combine(new RANKProcess().tmpFolder, xFile.Name)); if (result.Success) { var reqIDD = Path.GetFileNameWithoutExtension(xFile.Name); var newObj = db.reqlists.FirstOrDefault(s => s.reqid.Equals(reqIDD)); if (newObj.sts.Equals("processing")) { newObj.sts = "processed"; newObj.lnk = xFile.Name; db.SaveChanges(); } rProcess.moveToBckFolder(xFile); updateLog(xFile, "Success", Color.Green); } else { rProcess.moveToErrFolder(xFile); updateLog(xFile, "ErrorFTP", Color.Red); } } catch (Exception ex) { rProcess.moveToErrFolder(xFile); updateLog(xFile, "ErrorFile : " + ex.Message, Color.Red); } } }
public OperationResult _getReqSList(string rStatus) { OperationResult op = new OperationResult(); try { var db = new dnbmssqlEntities(); var reqQQ = db.reqlists.Where(s => s.sts.Equals(rStatus) && s.rtype.Equals("sku")); var reqCnt = reqQQ.Count(); if (reqCnt.Equals(0)) { op.Success = false; return(op); } foreach (var item in reqQQ) { var objreq = db.ViewRankingSKURequests.FirstOrDefault(s => s.reqid.Equals(item.reqid)); new CSV().CreateCSV(new string[] { "002", objreq.sid.Substring(6, 3), "SKU", objreq.sid.Substring(0, 6), objreq.ffrom.Replace("-", ""), objreq.tto.Replace("-", ""), objreq.reqid, item.reqid.Substring(19, Convert.ToInt32(objreq.reqid.Length - 19)), objreq.dreq.Replace("-", ""), DateTime.Now.ToString("HH:mm:ss").Replace(":", ""), "0", "0", "0", "0", "0", objreq.sku1 }); item.sts = "processing"; } db.SaveChanges(); db.Dispose(); op.Success = true; op.AddMessage(reqCnt + " sku has been created"); return(op); } catch (Exception ex) { op.Success = false; op.AddMessage(ex.Message.ToString()); return(op); } }
public bool SubmitPO(string pono) { dnbmssqlEntities db = new dnbmssqlEntities(); UserManager <User> userManager = new UserManager <User>(new UserStore <User>(new ApplicationDbContext())); var currentUser = User.Identity.Name.Substring(0, 6); var objPO = db.poes.Where(e => e.sid.Equals(currentUser) && e.pono.Contains(pono)).FirstOrDefault(); objPO.filestatus = "Downloaded"; db.SaveChanges(); sysLog("Download PO : " + pono, "Purchasing Order"); return(true); }
private void Bg_DoWork() { dnbmssqlEntities db = new dnbmssqlEntities(); var smslist = db.sms.Distinct().ToList <sm>(); foreach (var item in smslist) { var supp = item.sid + "-" + item.region; try { var msg = supp + " : you have approved P.O. dated : " + DateTime.Now.ToString("yyyy-MM-dd") + " Visit http://services.danubeco.com for more info. Thank you!"; var result = new SMS().SendSMS(msg, item.icurrent); _sysLog(supp + result.MessageList[0].ToString(), Color.Violet, StatusType.Sys); } catch { _sysLog(supp + " error in sending SMS", Color.Red, StatusType.Err); } item.status = "Sent"; smsList.Add(item); } db.SaveChanges(); var smsArch = Convert.ToBoolean(db.spsmsarchive()); if (smsArch) { _sysLog("SMS archived..", Color.Green, StatusType.Sys); } else { _sysLog("SMS error..", Color.Red, StatusType.Sys); } }
public async Task <string> AddAgent() { var user = new User { UserName = "******", Email = "ryan" + "@danubeco.com", Region = "JED" }; var result = await UserManager.CreateAsync(user, "qwe123QQ@@"); if (!result.Succeeded) { return("mali"); } var currentUser = await UserManager.FindByEmailAsync("*****@*****.**"); await UserManager.AddToRolesAsync(currentUser.Id, "Administrator"); try { db.userapps.Add(new userapp() { userid = "devqq", name = "Ryan Ayala", role = "Administrator", status = "activated", login = DateTime.Today, password = "******" }); db.SaveChanges(); return("ok"); } catch (Exception ex) { return(ex.ToString()); } }
private void processValidation() { dnbmssqlEntities db = new dnbmssqlEntities(); var smslist = db.suppliermobileactivtions.Distinct().ToList(); foreach (var item in smslist.Where(s => s.status.Equals("pending"))) { try { var sms = new xSms().GetCode(6); item.codesms = sms; item.datetimesent = string.Format("{0:dd-MM-yyyy hh:mm:ss}", DateTime.Now); var msg = "Requested an activation code " + sms + " for mobile registration."; var result = new SMS().SendSMS(msg, item.mobile); if (result.Success) { RichTxt(rtBox, item.mobile + " : " + sms + " : success.", Color.Green); item.status = "request"; } else { RichTxt(rtBox, item.mobile + " : " + sms + " : error csms.", Color.Red); item.status = "error"; } } catch { RichTxt(rtBox, item.mobile + " : error.", Color.Red); } } db.SaveChanges(); }
public void SupplierInfo(rX supplier) { // Supplier var supname = db.suppliers.FirstOrDefault(s => s.sid.Equals(supplier.idd)); if (supname == null) { db.suppliers.Add(new ADO.supplier { sid = supplier.idd, name = supplier.name }); db.SaveChanges(); } SupplierRegion(supplier); }
public void ProcessParallelThread() { // Get all PDF -> _mdr var Files = FolderPO.GetAllFile(FolderPO.tmpFolder, "pdf"); dnbmssqlEntities db = new dnbmssqlEntities(); foreach (var xFile in Files) { try { #region Convert FileInfo to PDF Object // Split PDF Filename into Object var pdf = SplitPdf(xFile); #endregion #region FTP Processes // Set ftp values var ftp = new ftp(@"ftp://188.121.43.20/services.danubeco.com/", "supplier"); // Upload PDF using FTP to Server Folder -> supplierx var result = ftp.Upload(Path.Combine("supplier", xFile.Name), Path.Combine(FolderPO.tmpFolder, xFile.Name)); if (result.Success) { #region Set PO Object // ----------------------------------------------- PO --------------------------------------------------------- var newPO = new po { sid = pdf.sid, pono = pdf.pono, region = pdf.region, location = pdf.location, division = pdf.division, link = xFile.Name, filestatus = "Available", released = DateTime.Now.ToString("yyyy-MM-dd"), expiration = DateTime.Now.AddDays(7).ToString("yyyy-MM-dd"), isexpired = "no" }; #endregion #region Store PO Object in Database var isExist = db.poes.FirstOrDefault(p => p.pono.Equals(newPO.pono)); if (isExist != null) { isExist.filestatus = "Updated"; isExist.link = newPO.link; } else { db.poes.Add(newPO); } #endregion #region Set SMS // ----------------------------------------------- SMS --------------------------------------------------------- var isExists = db.sms.FirstOrDefault(x => x.sid.Equals(newPO.sid) && x.region.Equals(newPO.region)); if (isExists == null) { var user = db.supplierregions.FirstOrDefault(s => s.sid.Equals(newPO.sid) && s.region.Equals(newPO.region)); if (user != null) { if (user.sms.Equals("y")) { db.sms.Add(new sm { sid = newPO.sid, region = newPO.region, icurrent = user.mobile, timesent = DateTime.Now.ToString(), status = "waiting" }); } } } #endregion #region Store & Backup File + Log // save changes to Database db.SaveChanges(); // move files to backup folder FolderPO.moveToBckFolder(xFile); // write log ni rtbox updateLog(xFile, "Success", Color.Green); #endregion } else { #region Backup File + Log // move to error folder FolderPO.moveToErrFolder(xFile); updateLog(xFile, "ErrorFTP", Color.Red); #endregion } #endregion } catch (Exception ex) { // move to error folder FolderPO.moveToErrFolder(xFile); updateLog(xFile, "ErrorFile" + ex.Message, Color.Red); } } }