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);
}
}
}