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