public MakeSachetViewModel GenereteSacheteForm()
{
IEnumerable <ClientPrefix> prefixes = this.Context.ClientPrefixes.OrderBy(p => p.PrefixName);
if (!prefixes.Any())
{
var prefix = new ClientPrefix()
{
PrefixName = "SF"
};
this.Context.ClientPrefixes.Add(prefix);
this.Context.SaveChanges();
prefixes = this.Context.ClientPrefixes.OrderBy(p => p.PrefixName);
}
IEnumerable <ClientPrefixViewModel> prefixesVm =
Mapper.Map <IEnumerable <ClientPrefix>, IEnumerable <ClientPrefixViewModel> >(prefixes);
MakeSachetViewModel vm = new MakeSachetViewModel();
vm.ClientPrefixes = prefixesVm;
return(vm);
}
public void AssignPrefixes(AssignPrefixBm assignPrefixBm)
{
SugarUser user = this.Context.SugarUsers.FirstOrDefault(u => u.Id == assignPrefixBm.Id);
if (user == null)
{
user = this.Context.SugarUsers.FirstOrDefault();
}
user.ClientPrefix = assignPrefixBm.ClientPrefix;
this.Context.SugarUsers.AddOrUpdate(user);
this.Context.SaveChanges();
var prefForUpdate =
this.Context.ClientPrefixes.FirstOrDefault(p => p.PrefixName == assignPrefixBm.ClientPrefix);
if (prefForUpdate == null)
{
prefForUpdate = new ClientPrefix();
prefForUpdate.PrefixName = "DEF";
}
prefForUpdate.SugarUser = user;
this.Context.ClientPrefixes.AddOrUpdate(prefForUpdate);
this.Context.SaveChanges();
}
public void CreatePrefix(CreatePrefixBm createPrefixBm)
{
ClientPrefix prefix = new ClientPrefix();
prefix.PrefixName = createPrefixBm.PrefixName.ToUpper();
this.Context.ClientPrefixes.Add(prefix);
this.Context.SaveChanges();
}
public void CreatePrefix(CreatePrefixBm createPrefixBm)
{
ClientPrefix prefix = new ClientPrefix();
SugarUser admin = this.Context.SugarUsers.Find(1);
prefix.PrefixName = createPrefixBm.PrefixName.ToUpper();
this.Context.ClientPrefixes.Add(prefix);
try
{
this.Context.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Debug.WriteLine("Entity of type {0} in state {1} has the following validation errors: ",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
catch (DbUpdateException exe)
{
var sb = new StringBuilder();
sb.AppendLine($"DbUpdateException error details - {exe?.InnerException?.InnerException?.Message}");
foreach (var eve in exe.Entries)
{
sb.AppendLine($"Entity of type {eve.Entity.GetType().Name} in state {eve.State} could not be updated");
}
var result = sb.ToString();
throw;
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
throw;
}
}
public void CreateSachet(MakeSachetBm makeSachetBm)
{
Counter lastCounter;
ClientPrefix prefix = this.Context.ClientPrefixes.FirstOrDefault(pr => pr.PrefixName == makeSachetBm.ClientPrefix);
if ((lastCounter = this.Context.Counters.OrderByDescending(c => c.Id).FirstOrDefault()) == null)
{
lastCounter = new Counter();
lastCounter.Value = 1;
}
SugarSachet sugarModel = new SugarSachet();
sugarModel = Mapper.Map <MakeSachetBm, SugarSachet>(makeSachetBm);
sugarModel.ClientPrefix = prefix;
HttpPostedFileBase fileImg = makeSachetBm.ImgFile;
HttpPostedFileBase filePdf = makeSachetBm.PdfFile;
if (fileImg.ContentLength > 0)
{
string imgName = Path.GetFileName(fileImg.FileName);
if (!imgName.EndsWith(".jpg") && !imgName.EndsWith(".png"))
{
throw new ArgumentNullException();
}
string pathImg = Path.Combine(HttpContext.Current.Server.MapPath("~/UploadedFiles"), imgName);
fileImg.SaveAs(pathImg);
}
if (filePdf.ContentLength > 0)
{
string pdfName = Path.GetFileName(filePdf.FileName);
if (!pdfName.EndsWith(".pdf"))
{
throw new ArgumentNullException();
}
string pathPdf = Path.Combine(HttpContext.Current.Server.MapPath("~/UploadedFiles"), pdfName);
filePdf.SaveAs(pathPdf);
}
sugarModel.ImageUrl = makeSachetBm.ImgFile.FileName;
sugarModel.PdfUrl = makeSachetBm.PdfFile.FileName;
sugarModel.UniqueNumber = makeSachetBm.ClientPrefix + "/" + makeSachetBm.PaperWidth.ToString() + "/" +
lastCounter.Value.ToString();
lastCounter.Value++;
this.Context.Counters.Add(lastCounter);
this.Context.SaveChanges();
this.Context.SugarSachets.Add(sugarModel);
this.Context.SaveChanges();
}
