public vw_ShadeCards GetShadeCardsFromVWByShadeId(int ShadeId)
{
using (var ctx = new DBAJEntities())
{
return(ctx.vw_ShadeCards.Where(c => c.ShadeId == ShadeId).FirstOrDefault());
}
}
public List <User> GetAllUsers()
{
using (var ctx = new DBAJEntities())
{
return(ctx.Users.ToList());
}
}
public void Update(User oUser)
{
try
{
using (var ctx = new DBAJEntities())
{
ctx.Entry(oUser).State = EntityState.Modified;
ctx.SaveChanges();
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.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)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
catch (Exception ex)
{
throw ex;
}
}
public bool MoveShades(ShadeCard oSelectedShade, ShadeCard oAffectedShade)
{
try
{
using (var ctx = new DBAJEntities())
{
int?SelectedOrderId = oSelectedShade.DisplayOrder;
int?affectOrderId = oAffectedShade.DisplayOrder;
//selected shade
oSelectedShade.DisplayOrder = affectOrderId;
ctx.Entry(oSelectedShade).State = EntityState.Modified;
//affected shade
oAffectedShade.DisplayOrder = SelectedOrderId;
ctx.Entry(oAffectedShade).State = EntityState.Modified;
ctx.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public List <vw_ShadeCards> GetAllShadeCardsFromView()
{
using (var ctx = new DBAJEntities())
{
return(ctx.vw_ShadeCards.OrderBy(c => c.DisplayOrder).ToList());
}
}
public User Create(User oUser)
{
try
{
using (var ctx = new DBAJEntities())
{
oUser.UserId = Guid.NewGuid();
ctx.Users.Add(oUser);
ctx.SaveChanges();
return(oUser);
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.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)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
catch (Exception ex)
{
throw ex;
}
}
public string GetGridData(GridSettings grid)
{
try
{
using (var ctx = new DBAJEntities())
{
var query = ctx.JariCompanies.AsQueryable();
int count;
var data = query.GridCommonSettings(grid, out count);
var result = new
{
total = (int)Math.Ceiling((double)count / grid.PageSize),
page = grid.PageIndex,
records = count,
rows = (from c in data
select new
{
c.JariCompanyId,
c.JariCompanyName,
c.CreateDate,
c.ActivationEndDate,
Action = c.JariCompanyId
}).ToArray()
};
return(JsonConvert.SerializeObject(result, new IsoDateTimeConverter()));
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <vw_Users> GetAllVWUsers()
{
using (var ctx = new DBAJEntities())
{
return(ctx.vw_Users.ToList());
}
}
public string GetGridData(GridSettings grid)
{
try
{
using (var ctx = new DBAJEntities())
{
var query = ctx.YarnTypes.AsQueryable();
int count;
var data = query.GridCommonSettings(grid, out count);
var result = new
{
total = (int)Math.Ceiling((double)count / grid.PageSize),
page = grid.PageIndex,
records = count,
rows = (from e in data
select new
{
e.YarnTypeId,
e.YarnTypeName,
e.YarnColorCode,
}).ToArray()
};
return(JsonConvert.SerializeObject(result, new IsoDateTimeConverter()));
}
}
catch (Exception ex)
{
throw ex;
}
}
//public string GetGridData(GridSettings grid, int JariCompanyId = 0)
//{
// try
// {
// using (var ctx = new DBAJEntities())
// {
// var query = ctx.vw_Users.AsQueryable();
// if (JariCompanyId != 0)
// {
// query = query.Where(k => k.JariCompanyId == JariCompanyId);
// }
// else
// {
// string RoleGroupName = Convert.ToString(En_Role_Group.AJ);
// List<int> lstRole = ctx.Roles.Where(r => r.RoleGroup == RoleGroupName).Select(r => r.RoleId).ToList();
// query = query.Where(u => lstRole.Contains(u.RoleId));
// }
// int count;
// var data = query.GridCommonSettings(grid, out count);
// var result = new
// {
// total = (int)Math.Ceiling((double)count / grid.PageSize),
// page = grid.PageIndex,
// records = count,
// rows = (from u in data
// select new
// {
// u.UserId,
// u.RoleId,
// u.JariCompanyId,
// u.FirstName,
// u.LastName,
// u.Email,
// u.Mobile,
// u.Phone,
// u.Password,
// u.Status,
// u.ModifiedBy,
// u.ModifiedOn,
// u.JariCompanyName,
// u.CreateDate,
// u.ActivationEndDate,
// u.RoleGroup,
// u.RoleName,
// Action = u.UserId
// }).ToArray()
// };
// return JsonConvert.SerializeObject(result, new IsoDateTimeConverter());
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public string GetGridData(GridSettings grid)
{
try
{
using (var ctx = new DBAJEntities())
{
var query = ctx.vw_Users.AsQueryable();
string RoleGroupName = Convert.ToString(En_Role_Group.Company);
List <int> lstRole = ctx.Roles.Where(r => r.RoleGroup == RoleGroupName).Select(r => r.RoleId).ToList();
query = query.Where(u => lstRole.Contains(u.RoleId));
int count;
var data = query.GridCommonSettings(grid, out count);
var result = new
{
total = (int)Math.Ceiling((double)count / grid.PageSize),
page = grid.PageIndex,
records = count,
rows = (from u in data
select new
{
u.UserId,
u.RoleId,
u.JariCompanyId,
u.FirstName,
u.LastName,
u.Email,
u.Mobile,
u.Phone,
u.Password,
u.Status,
u.ModifiedBy,
u.ModifiedOn,
u.JariCompanyName,
u.CreateDate,
u.ActivationEndDate,
u.RoleGroup,
u.RoleName,
Action = u.UserId
}).ToArray()
};
return(JsonConvert.SerializeObject(result, new IsoDateTimeConverter()));
}
}
catch (Exception ex)
{
throw ex;
}
}
public FinanceSale GetById(Guid id)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.FinanceSales.Where(c => c.FinanceSaleId == id).FirstOrDefault());
}
}
catch (Exception)
{
throw;
}
}
public List <JariCompany> GetAllCompanies()
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.JariCompanies.OrderBy(c => c.JariCompanyName).ToList());
}
}
catch (Exception)
{
throw;
}
}
public EmbroideryFirmPriceSetting GetById(int id)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.EmbroideryFirmPriceSettings.Where(c => c.EmbroideryFirmPriceSettingsId == id).FirstOrDefault());
}
}
catch (Exception)
{
return(null);
}
}
public List <Lookup> GetAllLookups()
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.Lookups.OrderBy(c => c.LookupId).ToList());
}
}
catch (Exception)
{
throw;
}
}
//Get User details by Name
public List <Role> GetByRoleGroup(string RoleGroup)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.Roles.Where(p => p.RoleGroup == RoleGroup).OrderBy(c => c.RoleName).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
//public string GetGridData(GridSettings grid)
//{
// try
// {
// using (var ctx = new DBAJEntities())
// {
// var query = ctx.FinanceSales.AsQueryable();
// int count;
// var data = query.GridCommonSettings(grid, out count);
// var result = new
// {
// total = (int)Math.Ceiling((double)count / grid.PageSize),
// page = grid.PageIndex,
// records = count,
// rows = (from e in data
// select new
// {
// FinanceSaleId = e.FinanceSaleId,
// Week = e.Week,
// Month = e.Month,
// Year = e.Year,
// FromDate = (e.FromDate == null ? "" : e.FromDate.Value.ToString("MM/dd/yyyy")),
// ToDate = (e.ToDate == null ? "" : e.ToDate.Value.ToString("MM/dd/yyyy")),
// TotalInvCases = e.TotalInvCases,
// InvoicedAmt = e.InvoicedAmt.Value.ToString("C"),
// Action = e.FinanceSaleId
// }).ToArray()
// };
// return JsonConvert.SerializeObject(result, new IsoDateTimeConverter());
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//public string GetFinanceCaseGridData(GridSettings grid, DateTime? FromDate = null, DateTime? ToDate = null)
//{
// try
// {
// using (var ctx = new DBAJEntities())
// {
// string Complete = En_Case_Status.Complete.ToString();
// var query = new List<vw_FinanceCases>().AsQueryable();
// if (FromDate != null && ToDate != null)
// {
// //ToDate = ToDate.Value.AddDays(1);
// int month = FromDate.Value.Date.Month;
// int year = FromDate.Value.Date.Year;
// query = ctx.vw_FinanceCases.Where(c => c.Status == Complete && c.Month == month && c.Year == year).AsQueryable();
// //query = ctx.vw_FinanceCases.Where(c => c.Status == Complete && (c.CompleteOn >= FromDate && c.CompleteOn <= ToDate)).AsQueryable();
// }
// else
// {
// query = ctx.vw_FinanceCases.Where(c => c.Status == Complete).AsQueryable();
// }
// int count;
// var data = query.GridCommonSettings(grid, out count);
// var result = new
// {
// total = (int)Math.Ceiling((double)count / grid.PageSize),
// page = grid.PageIndex,
// records = count,
// rows = (from e in data
// select new
// {
// CaseId = e.CaseId,
// CaseIdLookup = e.CaseIdLookup.ToUpper(),
// ClinicId = e.ClinicId,
// ClinicLocationId = e.ClinicLocationId,
// PatientId = e.PatientId,
// Status = e.Status,
// CaseInvStatus = e.CaseInvStatus,
// TranHeaderId = e.TranHeaderId,
// InvoiceNumber = (e.InvoiceNumber == null ? "" : e.InvoiceNumber),
// TransDate = (e.TransDate == null ? "" : Util.ConvertUTCtoCST(e.TransDate.Value).ToString("MM/dd/yyyy")),
// CompleteOn = (e.CompleteOn == null) ? "" : Util.ConvertUTCtoCST(e.CompleteOn.Value).ToString("MM/dd/yyyy"),
// ClinicName = e.ClinicName,
// ClinicLocationName = e.ClinicLocationName,
// PatientName = e.PatientName,
// IsStatRequest = e.IsStatRequest,
// Week = e.Week,
// Month = e.Month,
// Year = e.Year,
// ClinicianName = e.ClinicianName,
// SpecialistName = e.SpecialistName,
// CaseAmount = ((e.CaseAmount == null || e.CaseAmount < 0) ? "$0.00" : Convert.ToDecimal(e.CaseAmount).ToString("C")),
// Action = e.CaseId,
// CaseTypeName = e.CaseTypeName
// }).ToArray()
// };
// return JsonConvert.SerializeObject(result, new IsoDateTimeConverter());
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public FinanceSale GetByFromToDate(DateTime FromDate, DateTime ToDate)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.FinanceSales.Where(c => c.FromDate == FromDate && c.ToDate == ToDate).FirstOrDefault());
}
}
catch (Exception)
{
throw;
}
}
//public string GetGridDataByClinicId(GridSettings grid, Guid ClinicId)
//{
// try
// {
// using (var ctx = new DBAJEntities())
// {
// List<TranJournalModel> lstTranModel = new List<TranJournalModel>();
// decimal Balance = 0;
// foreach (var item in ctx.vw_TranJournal.Where(c => c.ClinicId == ClinicId).ToList())
// {
// TranJournalModel oTranJournalModel = new TranJournalModel();
// oTranJournalModel.RowNumber = item.RowNumber;
// oTranJournalModel.TranJournalId = item.TranJournalId;
// oTranJournalModel.TranHeaderId = item.TranHeaderId;
// oTranJournalModel.ClinicId = item.ClinicId;
// oTranJournalModel.ClinicLocationId = item.ClinicLocationId;
// oTranJournalModel.Reference = item.Reference;
// oTranJournalModel.TranJournalNotes = item.TranJournalNotes;
// oTranJournalModel.CR = item.CR;
// oTranJournalModel.DR = item.DR;
// oTranJournalModel.CreatedOn = item.CreatedOn;
// oTranJournalModel.TranType = item.TranType;
// oTranJournalModel.ClinicName = item.ClinicName;
// oTranJournalModel.LocationName = item.LocationName;
// oTranJournalModel.Amount = Convert.ToDecimal(item.CR - item.DR);
// Balance += oTranJournalModel.Amount;
// oTranJournalModel.Balance = Balance;
// lstTranModel.Add(oTranJournalModel);
// }
// var query = lstTranModel.AsQueryable();
// int count;
// var data = query.GridCommonSettings(grid, out count);
// Decimal dec = new Decimal(-1234.4321);
// System.Globalization.CultureInfo culture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US");
// culture.NumberFormat.CurrencyNegativePattern = 1;
// String str = String.Format(culture, "{0:C}", dec);
// var result = new
// {
// total = (int)Math.Ceiling((double)count / grid.PageSize),
// page = grid.PageIndex,
// records = count,
// rows = (from e in data
// select new
// {
// RowNumber = e.RowNumber,
// TranJournalId = e.TranJournalId,
// TranHeaderId = e.TranHeaderId,
// ClinicId = e.ClinicId,
// ClinicName = e.ClinicName,
// ClinicLocationId = e.ClinicLocationId,
// LocationName = e.LocationName,
// Reference = e.Reference,
// TranJournalNotes = e.TranJournalNotes,
// CR = e.CR,
// DR = e.DR,
// CreatedOn = Util.ConvertUTCtoCST(e.CreatedOn.Value).ToString("MM/dd/yyyy"),
// TranType = e.TranType,
// Amount = String.Format(culture, "{0:C}", e.Amount),
// Balance = String.Format(culture, "{0:C}", e.Balance)
// }).ToArray()
// };
// return JsonConvert.SerializeObject(result, new IsoDateTimeConverter());
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public TranJournal GetByTranHeaderId(Guid id)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.TranJournals.Where(c => c.TranHeaderId == id).FirstOrDefault());
}
}
catch (Exception)
{
throw;
}
}
public List <YarnType> GetAllYarnTypes()
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.YarnTypes.OrderBy(c => c.YarnTypeName).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public YarnType GetById(int YarnTypeId)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.YarnTypes.Where(p => p.YarnTypeId == YarnTypeId).FirstOrDefault());
}
}
catch (Exception ex)
{
throw ex;
}
}
public EmbroideryFirmLocation GetById(Guid Id)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.EmbroideryFirmLocations.Where(p => p.EmbroideryFirmLocationId == Id).FirstOrDefault());
}
}
catch (Exception ex)
{
throw ex;
}
}
public ShadeCard GetById(int ShadeId)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.ShadeCards.Where(p => p.ShadeId == ShadeId).FirstOrDefault());
}
}
catch (Exception ex)
{
throw ex;
}
}
public Role GetByRoleName(string RoleName)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.Roles.Where(p => p.RoleName == RoleName).FirstOrDefault());
}
}
catch (Exception ex)
{
throw ex;
}
}
public SiteConfig GetById(int SiteConfigId)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.SiteConfigs.Where(c => c.SiteConfigId == SiteConfigId).FirstOrDefault());
}
}
catch (Exception)
{
throw;
}
}
public Lookup GetById(int LookupId)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.Lookups.Where(c => c.LookupId == LookupId).FirstOrDefault());
}
}
catch (Exception)
{
throw;
}
}
public List <ShadeCard> GetAllShadeCards()
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.ShadeCards.OrderBy(c => c.DisplayOrder).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public SiteConfig GetByName(string Name)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.SiteConfigs.Where(c => c.Name == Name).FirstOrDefault());
}
}
catch (Exception)
{
throw;
}
}
public User GetByEmail(string EmaiId)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.Users.Where(p => p.Email == EmaiId).FirstOrDefault());
}
}
catch (Exception ex)
{
throw ex;
}
}
public JariCompany GetById(int CompanyId)
{
try
{
using (var ctx = new DBAJEntities())
{
return(ctx.JariCompanies.Where(c => c.JariCompanyId == CompanyId).FirstOrDefault());
}
}
catch (Exception)
{
throw;
}
}
public void Update(SiteConfig oSiteConfig)
{
try
{
using (var ctx = new DBAJEntities())
{
ctx.Entry(oSiteConfig).State = EntityState.Modified;
ctx.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
public void Create(SiteConfig oSiteConfig)
{
try
{
using (var ctx = new DBAJEntities())
{
ctx.SiteConfigs.Add(oSiteConfig);
ctx.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
