public AdminModel getAdmin() { var result = new AdminModel(); using (var context = new AnaghaEnterprisesEntities()) { result = (from item in context.Admins join item1 in context.roles on item.RoleId equals item1.RoleId where item.UserName == this.UserName && item.Password == this.Password && item.IsActive == true select new AdminModel { AdminId = item.AdminId, UserName = item.UserName, Password = item.Password, Email = item.Email, Name = item.Name, IsActive = item.IsActive, RoleId = item.RoleId, CreatedDate = item.CreatedDate, RoleName = item1.RoleName }).FirstOrDefault(); } return(result); }
public bool Save() { try { using (var context = new AnaghaEnterprisesEntities()) { context.InvoiceLines.Add(new InvoiceLine() { InvoiceLineID = InvoiceLineID, InvoiceID = InvoiceID, Description = Description, Nos_Bag = Nos_Bag, Uom = Uom, Rate = Rate, Amount = Amount, Discount = Discount, TaxableValue = TaxableValue, CGST_Rate = CGST_Rate, CGST_Amount = CGST_Amount, SGST_Rate = SGST_Rate, SGST_Amount = SGST_Amount, IGST_Rate = IGST_Rate, IGST_Amount = IGST_Amount, Total = Total }); context.SaveChanges(); return(true); } } catch (Exception) { return(true); } }
public String GetRole(string username) { using (var context = new AnaghaEnterprisesEntities()) { var result = (from item in context.Admins join item1 in context.roles on item.RoleId equals item1.RoleId where item.UserName.Equals(username) select item1.RoleName).FirstOrDefault(); return(result); } }
public bool Delete() { try { var context = new AnaghaEnterprisesEntities(); var invoice = new Invoice() { InvoiceID = this.InvoiceID }; context.Invoices.Attach(invoice); context.Invoices.Remove(invoice); context.SaveChanges(); return(true); } catch (Exception ex) { throw new Exception("Unable to delete invoice", ex); } }
public bool save() { try { using (var context = new AnaghaEnterprisesEntities()) { context.Invoices.Add(new Invoice { InvoiceID = InvoiceID, InvoiceDate = InvoiceDate, PO_No = PO_No, TransportationMode = TransportationMode, Veh_No = Veh_No, LR_No = LR_No, LR_Date = LR_Date, DateTimeSupply = DateTimeSupply, CustomerName = CustomerName, GST_No = GST_No, PAN_No = PAN_No, CompanyAddress = CompanyAddress, ShippingAddress = ShippingAddress, Total_Nos_Kg = Total_Nos_Kg, Total_Nos_Bag = Total_Nos_Bag, TotalAmountBeforeTax = TotalAmountBeforeTax, Total_CGST = Total_CGST, Total_SGST = Total_SGST, Total_IGST = Total_IGST, Total_GST = Total_GST, TotalAmountAfterTax = TotalAmountAfterTax, TotalAfterRoundOff = TotalAfterRoundOff }); context.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public List <InvoiceModel> GetAllInvoice() { try { using (var context = new AnaghaEnterprisesEntities()) { return(context.Invoices.Select(m => new InvoiceModel { InvoiceID = m.InvoiceID, InvoiceDate = m.InvoiceDate, PO_No = m.PO_No, TransportationMode = m.TransportationMode, Veh_No = m.Veh_No, LR_No = m.LR_No, LR_Date = m.LR_Date, DateTimeSupply = m.DateTimeSupply, CustomerName = m.CustomerName, GST_No = m.GST_No, PAN_No = m.PAN_No, CompanyAddress = m.CompanyAddress, ShippingAddress = m.ShippingAddress, Total_Nos_Kg = m.Total_Nos_Kg, Total_Nos_Bag = m.Total_Nos_Bag, TotalAmountBeforeTax = m.TotalAmountBeforeTax, Total_CGST = m.Total_CGST, Total_SGST = m.Total_SGST, Total_IGST = m.Total_IGST, Total_GST = m.Total_GST, TotalAmountAfterTax = m.TotalAmountAfterTax, TotalAfterRoundOff = m.TotalAfterRoundOff }).ToList()); } } catch (Exception ex) { throw new Exception("Unable to get invoice list", ex); } }