public bool HardDeleteSupport(int SupportId, string userId = null)
{
using (var _context = new AdminPortalEntities())
{
if (userId != null)
{
var support = _context.SupportMasters.SingleOrDefault(s => s.SupportId == SupportId && s.UserId == userId);
if (support != null)
{
_context.SupportMasters.Remove(support);
_context.SaveChanges();
return(true);
}
return(false);
}
else
{
var support = _context.SupportMasters.SingleOrDefault(s => s.SupportId == SupportId);
if (support != null)
{
_context.SupportMasters.Remove(support);
_context.SaveChanges();
return(true);
}
return(false);
}
}
}
public bool SetExpenseAttachment(ExpenseAttachment expensedoc)
{
using (var _context = new AdminPortalEntities())
{
_context.ExpenseAttachments.Add(expensedoc);
_context.SaveChanges();
expensedoc.FileName = "(" + expensedoc.Id + ")" + expensedoc.FileName;
_context.ExpenseAttachments.Attach(expensedoc);
_context.Entry(expensedoc).State = EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
public bool CreateLoa(LOA loa)
{
using (var _context = new AdminPortalEntities())
{
_context.LOAs.Add(loa);
_context.SaveChanges();
loa.LoaCode = "LOA" + (1100 + loa.LoaId).ToString();
_context.LOAs.Attach(loa);
_context.Entry(loa).State = EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
public bool CreateTimeSheet(TimeSheetsMaster timeSheet)
{
using (var _context = new AdminPortalEntities())
{
_context.TimeSheetsMasters.Add(timeSheet);
_context.SaveChanges();
timeSheet.TimeSheetCode = "TS" + (1100 + timeSheet.TimeSheetID).ToString();
_context.TimeSheetsMasters.Attach(timeSheet);
_context.Entry(timeSheet).State = EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
//public string GenerateSupportCode()
//{
// using (var _context = new AdminPortalEntities())
// {
// var lastsupportid = _context.SupportMasters.OrderByDescending(o => o.SupportId).FirstOrDefault();
// int lastsupid = 0;
// if (lastsupportid != null)
// {
// lastsupid= lastsupportid.SupportId;
// //return lastsupportid.SupportId ;
// }
// return "100125405-" + (1100 + lastsupid + 1).ToString();
// }
//}
public bool SetSupportAttachment(SupportAttachment supportdoc)
{
using (var _context = new AdminPortalEntities())
{
_context.SupportAttachments.Add(supportdoc);
_context.SaveChanges();
supportdoc.FileName = "(" + supportdoc.Id + ")" + supportdoc.FileName;
_context.SupportAttachments.Attach(supportdoc);
_context.Entry(supportdoc).State = EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
public bool CreateExpense(ExpenseMaster expense)
{
using (var _context = new AdminPortalEntities())
{
_context.ExpenseMasters.Add(expense);
_context.SaveChanges();
expense.ExpenseCode = "Ex" + (1100 + expense.ExpenseId).ToString();
_context.ExpenseMasters.Attach(expense);
_context.Entry(expense).State = EntityState.Modified;
_context.SaveChanges();
//_context.ExpenseSummaries.AddRange(expense.ExpenseSummaries);
//_context.SaveChanges();
return(true);
}
}
public void CreateSupport(SupportMaster support)
{
using (var _context = new AdminPortalEntities())
{
_context.SupportMasters.Add(support);
_context.SaveChanges();
support.SupportCode = "ST-" + DateTime.Now.ToString("MM") + DateTime.Now.ToString("yyyy") + "-" + (1100 + support.SupportId).ToString();
_context.SupportMasters.Attach(support);
_context.Entry(support).State = EntityState.Modified;
_context.SaveChanges();
//int Sid = support.SupportId;
//return Sid;
}
}
public bool DeleteClientDocumentById(string UserId, int FileId, int ClientId)
{
using (var _context = new AdminPortalEntities())
{
////RecruitmentClientDocument recruitmentClientDoc = _context.RecruitmentClientDocuments.Where(x => x.Id == FileId).FirstOrDefault();
////_context.RecruitmentClientDocuments.Remove(recruitmentClientDoc);
RecruitmentClient recruitmentClientDoc = _context.RecruitmentClients.Where(x => x.Id == ClientId).FirstOrDefault();
recruitmentClientDoc.ModifiedUserId = UserId;
recruitmentClientDoc.ModifiedDate = System.DateTime.Now;
switch (FileId)
{
case 1:
recruitmentClientDoc.ClientDocument1 = null;
recruitmentClientDoc.DocumentName1 = null;
break;
case 2:
recruitmentClientDoc.ClientDocument2 = null;
recruitmentClientDoc.DocumentName2 = null;
break;
}
_context.Entry(recruitmentClientDoc).State = EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
public void RemoveExpenseSummary(int id)
{
using (var _context = new AdminPortalEntities())
{
var expenseSummary = _context.ExpenseSummaries.Where(x => x.ExpenseId == id).FirstOrDefault();
_context.ExpenseSummaries.Remove(expenseSummary);
_context.SaveChanges();
}
}
public void UpdateExpenseSummary(ExpenseSummary es)
{
using (var _context = new AdminPortalEntities())
{
_context.ExpenseSummaries.Attach(es);
_context.Entry(es).State = EntityState.Modified;
_context.SaveChanges();
}
}
//private readonly AdminPortalEntities _context;
//public ProductService(AdminPortalEntities context) { _context = context; }
public bool CreateNewProduct(Product product)
{
using (var _context = new AdminPortalEntities())
{
_context.Products.Add(product);
_context.SaveChanges();
return(true);
}
}
public bool CreateNewUserInfo(UserInfo user)
{
using (var _context = new AdminPortalEntities())
{
_context.UserInfoes.Add(user);
_context.SaveChanges();
return(true);
}
}
public bool CreateNewUser(AspNetUser user)
{
using (var _context = new AdminPortalEntities())
{
_context.AspNetUsers.Add(user);
_context.SaveChanges();
return(true);
}
}
public bool CreateExpenseSummary(ExpenseSummary summary)
{
using (var _context = new AdminPortalEntities())
{
_context.ExpenseSummaries.Add(summary);
_context.SaveChanges();
return(true);
}
}
public bool UpdateClientDocument(List <RecruitmentClientDocument> recruitmentClientDocument)
{
using (var _context = new AdminPortalEntities())
{
_context.RecruitmentClientDocuments.AddRange(recruitmentClientDocument);
_context.SaveChanges();
return(true);
}
}
public bool CreateTimeSheetSummary(List <TimeSheetSummary> summaries)
{
using (var _context = new AdminPortalEntities())
{
_context.TimeSheetSummaries.AddRange(summaries);
_context.SaveChanges();
return(true);
}
}
public bool UpdateTimeSheet(TimeSheetsMaster timeSheetsMaster)
{
using (var _context = new AdminPortalEntities())
{
_context.TimeSheetsMasters.Attach(timeSheetsMaster);
_context.Entry(timeSheetsMaster).State = EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
public bool UpdateRecruitment(Recruitment recruitment)
{
using (var _context = new AdminPortalEntities())
{
_context.Recruitments.Attach(recruitment);
_context.Entry(recruitment).State = EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
public bool SetRecruitmentDocument(RecruitmentDocument recruitmentdoc)
{
using (var _context = new AdminPortalEntities())
{
_context.RecruitmentDocuments.Add(recruitmentdoc);
_context.SaveChanges();
//int Rid = recruitment.RecruitmentId;
return(true);
}
}
public bool UpdateLOA(LOA loa)
{
using (var _context = new AdminPortalEntities())
{
_context.LOAs.Attach(loa);
_context.Entry(loa).State = EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
public int SetRecruitment(Recruitment recruitment)
{
using (var _context = new AdminPortalEntities())
{
_context.Recruitments.Add(recruitment);
_context.SaveChanges();
int Rid = recruitment.RecruitmentId;
return(Rid);
}
}
public bool UpdateSupport(SupportMaster support)
{
using (var _context = new AdminPortalEntities())
{
_context.SupportMasters.Attach(support);
_context.Entry(support).State = EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
public bool UpdateProduct(Product product)
{
using (var _context = new AdminPortalEntities())
{
_context.Products.Attach(product);
_context.Entry(product).State = EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
public bool SoftDeleteUserInfo(UserInfo userInfo)
{
using (var _context = new AdminPortalEntities())
{
_context.UserInfoes.Attach(userInfo);
_context.Entry(userInfo).State = EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
public bool HardDeleteExpense(int id)
{
using (var _context = new AdminPortalEntities())
{
var summaries = _context.ExpenseSummaries.Where(s => s.ExpenseId == id);
if (summaries != null)
{
_context.ExpenseSummaries.RemoveRange(summaries);
_context.SaveChanges();
}
var expense = _context.ExpenseMasters.SingleOrDefault(s => s.ExpenseId == id);
if (expense != null)
{
_context.ExpenseMasters.Remove(expense);
_context.SaveChanges();
}
return(true);
}
}
public bool SoftDeleteRecruitment(Recruitment employeerecord)
{
using (var _context = new AdminPortalEntities())
{
_context.Recruitments.Attach(employeerecord);
_context.Entry(employeerecord).State = EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
public bool HardDeleteLOA(int id)
{
using (var _context = new AdminPortalEntities())
{
var loa = _context.LOAs.SingleOrDefault(s => s.LoaId == id);
if (loa != null)
{
_context.LOAs.Remove(loa);
_context.SaveChanges();
}
return(true);
}
}
public bool HardDeleteProduct(int productId)
{
using (var _context = new AdminPortalEntities())
{
var product = _context.Products.SingleOrDefault(s => s.ProductId == productId);
if (product != null)
{
_context.Products.Remove(product);
_context.SaveChanges();
}
return(true);
}
}
public bool DeleteSupportDocumentFile(int id)
{
using (var _context = new AdminPortalEntities())
{
var supportAttachment = _context.SupportAttachments.SingleOrDefault(s => s.Id == id);
if (supportAttachment != null)
{
_context.SupportAttachments.Remove(supportAttachment);
_context.SaveChanges();
}
return(true);
}
}
public bool HardDeleteSummaries(int timeSheetId)
{
using (var _context = new AdminPortalEntities())
{
var summaries = _context.TimeSheetSummaries.Where(s => s.TimeSheetID == timeSheetId);
if (summaries != null)
{
_context.TimeSheetSummaries.RemoveRange(summaries);
_context.SaveChanges();
}
return(true);
}
}