public cls_common_responses DeleteWarehouse(int WarehouseID)
{
cls_common_responses clsCommonResponses = new cls_common_responses();
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
Warehouse entity = customErpEntities.Warehouse.Where <Warehouse>((Expression <Func <Warehouse, bool> >)(u => u.IDNUMBER == WarehouseID)).FirstOrDefault <Warehouse>();
if (entity == null)
{
clsCommonResponses.ResponseGenID = 0;
clsCommonResponses.ResponseCode = 400;
clsCommonResponses.ResponseMessage = "Something went wrong, please try again later.";
}
else
{
customErpEntities.Warehouse.Remove(entity);
customErpEntities.SaveChanges();
clsCommonResponses.ResponseGenID = 0;
clsCommonResponses.ResponseCode = 200;
clsCommonResponses.ResponseMessage = "Record Delete SuccessFully!!";
}
}
}
catch (Exception ex)
{
clsCommonResponses.ResponseGenID = 0;
clsCommonResponses.ResponseCode = 400;
clsCommonResponses.ResponseMessage = "Something went wrong, please try again later.";
}
return(clsCommonResponses);
}
public List <ItemVarient> GetItemVarients()
{
List <ItemVarient> itemVarientList1 = new List <ItemVarient>();
cls_user_responses clsUserResponses = new cls_user_responses();
List <ItemVarient> itemVarientList2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
List <ItemVarient> list = customErpEntities.ItemVarient.Select <ItemVarient, ItemVarient>((Expression <Func <ItemVarient, ItemVarient> >)(itm => itm)).ToList <ItemVarient>();
if (list.Count > 0)
{
foreach (ItemVarient itemVarient in list)
{
ItemVarient itemName = itemVarient;
Item obj = customErpEntities.Item.Where <Item>((Expression <Func <Item, bool> >)(itm => itm.IDNUMBER == itemName.ItemID)).FirstOrDefault <Item>();
if (obj != null)
{
itemName.ItemName = obj.ItemName;
itemName.ProductImage = obj.ItemImage;
itemName.ItemVarientName = obj.ItemName + " - " + itemName.Color + " - " + itemName.Size;
}
}
itemVarientList1 = list;
}
itemVarientList2 = itemVarientList1;
}
}
catch (Exception ex)
{
itemVarientList2 = itemVarientList1;
}
return(itemVarientList2);
}
public List <cls_user_responses> UserModule(string sp_name)
{
string baseUrl = Credentials.BaseUrl;
DateTime.Now.ToString("yyyyMMddHHmmssfff");
List <cls_user_responses> clsUserResponsesList1 = new List <cls_user_responses>();
cls_user_responses clsUserResponses1 = new cls_user_responses();
List <cls_user_responses> clsUserResponsesList2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
List <cls_user_responses> list = customErpEntities.Database.SqlQuery <cls_user_responses>(sp_name).ToList <cls_user_responses>();
if (list.Count <= 0)
{
clsUserResponses1.UserID = "";
clsUserResponses1.IDNUMBER = 0;
clsUserResponses1.UserName = "";
clsUserResponses1.EmailID = "";
clsUserResponses1.MobileNo = "";
clsUserResponses1.UserTypeName = "";
clsUserResponses1.BOD = "";
clsUserResponses1.Active = "";
clsUserResponsesList1.Add(clsUserResponses1);
}
else
{
foreach (cls_user_responses clsUserResponses2 in list)
{
clsUserResponses1.UserID = clsUserResponses2.UserID;
clsUserResponses1.UserName = !string.IsNullOrEmpty(clsUserResponses2.UserName) ? clsUserResponses2.UserName : "";
clsUserResponses1.EmailID = !string.IsNullOrEmpty(clsUserResponses2.EmailID) ? clsUserResponses2.EmailID : "";
clsUserResponses1.MobileNo = !string.IsNullOrEmpty(clsUserResponses2.MobileNo) ? clsUserResponses2.MobileNo : "";
clsUserResponses1.UserTypeName = !string.IsNullOrEmpty(clsUserResponses1.UserTypeName) ? clsUserResponses2.UserTypeName : "";
clsUserResponses1.Active = !string.IsNullOrEmpty(clsUserResponses1.Active) ? clsUserResponses2.Active : "";
clsUserResponsesList1.Add(clsUserResponses1);
}
}
clsUserResponsesList2 = list;
}
}
catch (Exception ex)
{
clsUserResponses1.UserID = "";
clsUserResponses1.IDNUMBER = 0;
clsUserResponses1.UserName = "";
clsUserResponses1.EmailID = "";
clsUserResponses1.MobileNo = "";
clsUserResponses1.UserTypeName = "";
clsUserResponses1.BOD = "";
clsUserResponses1.Active = "";
clsUserResponsesList1.Add(clsUserResponses1);
clsUserResponsesList2 = clsUserResponsesList1;
}
return(clsUserResponsesList2);
}
public List <Item> GetProducts()
{
List <Item> objList1 = new List <Item>();
cls_user_responses clsUserResponses = new cls_user_responses();
List <Item> objList2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
List <Item> list1 = customErpEntities.Item.Select <Item, Item>((Expression <Func <Item, Item> >)(itm => itm)).ToList <Item>();
if (list1.Count > 0)
{
foreach (Item obj in list1)
{
Item categoryName = obj;
Decimal num = new Decimal();
int? nullable1 = new int?(0);
List <ItemVarient> list2 = customErpEntities.ItemVarient.Where <ItemVarient>((Expression <Func <ItemVarient, bool> >)(itmvar => itmvar.ItemID == categoryName.IDNUMBER)).ToList <ItemVarient>();
if (list2.Count > 0)
{
categoryName.ItemVarients = list2;
}
Category category = customErpEntities.Category.Where <Category>((Expression <Func <Category, bool> >)(ct => (int?)ct.IDNUMBER == categoryName.CategoryID)).FirstOrDefault <Category>();
if (category != null)
{
categoryName.CategoryName = category.CategoryName;
}
List <ItemVarient> list3 = customErpEntities.ItemVarient.Where <ItemVarient>((Expression <Func <ItemVarient, bool> >)(ct => ct.ItemID == categoryName.IDNUMBER)).ToList <ItemVarient>();
if (list3 != null)
{
foreach (ItemVarient itemVarient in list3)
{
num += itemVarient.Inventory;
int?nullable2 = nullable1;
int?warehouseId = itemVarient.WarehouseID;
nullable1 = !(nullable2.HasValue & warehouseId.HasValue) ? new int?() : new int?(nullable2.GetValueOrDefault() + warehouseId.GetValueOrDefault());
}
categoryName.Total = num;
categoryName.ShanghaiTotal = nullable1;
}
}
objList1 = list1;
}
objList2 = objList1;
}
}
catch (Exception ex)
{
objList2 = objList1;
}
return(objList2);
}
public cls_common_responses CreateSales(
string sp_name,
Sales sales_requests)
{
cls_common_responses clsCommonResponses1 = new cls_common_responses();
cls_common_responses clsCommonResponses2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
foreach (cls_common_responses clsCommonResponses3 in customErpEntities.Database.SqlQuery <cls_common_responses>(sp_name + " @prmIDNUMBER, @prmCompanyID, @prmPONo, @prmSupplierID, @prmShippingName, @prmShippingAddress, @prmShippingCost, @prmPaymentType,@prmTotalQty, @prmSubTotal, @prmCurrency, @prmDeposite, @prmBBShippment, @prmIncoterms, @prmTotal, @prmCreatedBy", (object)new SqlParameter("@prmIDNUMBER", (object)sales_requests.IDNUMBER), (object)new SqlParameter("@prmCompanyID", (object)sales_requests.CompanyID), (object)new SqlParameter("@prmPONo", (object)sales_requests.SONO), (object)new SqlParameter("@prmSupplierID", (object)sales_requests.CustomerID), (object)new SqlParameter("@prmShippingName", (object)sales_requests.ShippingName), (object)new SqlParameter("@prmShippingAddress", (object)sales_requests.ShippingAddress), (object)new SqlParameter("@prmShippingCost", (object)sales_requests.ShippingCost), (object)new SqlParameter("@prmPaymentType", (object)sales_requests.PaymentType), (object)new SqlParameter("@prmTotalQty", (object)sales_requests.TotalQty), (object)new SqlParameter("@prmSubTotal", (object)sales_requests.SubTotal), (object)new SqlParameter("@prmCurrency", (object)sales_requests.Currency), (object)new SqlParameter("@prmDeposite", (object)sales_requests.Deposite), (object)new SqlParameter("@prmBBShippment", (object)sales_requests.BBShippment), (object)new SqlParameter("@prmIncoterms", (object)sales_requests.Incoterms), (object)new SqlParameter("@prmTotal", (object)sales_requests.Total), (object)new SqlParameter("@prmCreatedBy", (object)sales_requests.CreatedBy)))
{
if (clsCommonResponses3.ResponseCode == 200)
{
if (!SalesManager.saveStocks(sales_requests, clsCommonResponses3.ResponseGenID))
{
clsCommonResponses1.ResponseGenID = 0;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = "Something went wrong in Stock Insertion!!";
}
else
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
}
else if (clsCommonResponses3.ResponseCode != 400)
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
else
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
}
clsCommonResponses2 = clsCommonResponses1;
}
}
catch (Exception ex)
{
clsCommonResponses1.ResponseGenID = 0;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = "Something went wrong, please try again later.";
clsCommonResponses2 = clsCommonResponses1;
}
return(clsCommonResponses2);
}
public List <Purchase> GetPurchases()
{
List <Purchase> purchaseList1 = new List <Purchase>();
cls_user_responses clsUserResponses = new cls_user_responses();
List <Purchase> purchaseList2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
List <Purchase> list1 = customErpEntities.Purchase.Select <Purchase, Purchase>((Expression <Func <Purchase, Purchase> >)(itm => itm)).ToList <Purchase>();
foreach (Purchase purchase in list1)
{
Purchase supplierName = purchase;
List <PurchaseDetails> list2 = customErpEntities.PurchaseDetails.Where <PurchaseDetails>((Expression <Func <PurchaseDetails, bool> >)(pd => pd.PurchaseID == supplierName.IDNUMBER)).ToList <PurchaseDetails>();
if (list2.Count > 0)
{
foreach (PurchaseDetails purchaseDetails in list2)
{
PurchaseDetails itemName = purchaseDetails;
Item obj = customErpEntities.Item.Where <Item>((Expression <Func <Item, bool> >)(it => it.IDNUMBER == itemName.ItemID)).FirstOrDefault <Item>();
if (obj != null)
{
itemName.ItemName = obj.ItemName;
itemName.ProductImage = obj.ItemImage;
ItemVarient itemVarient = customErpEntities.ItemVarient.Where <ItemVarient>((Expression <Func <ItemVarient, bool> >)(itv => itv.IDNUMBER == itemName.ItemVarientID)).FirstOrDefault <ItemVarient>();
if (itemVarient != null)
{
itemName.Color = itemVarient.Color;
itemName.SKU = itemVarient.SKU;
itemName.UPC = itemVarient.UPC;
}
}
}
supplierName.PurchaseDetails = list2;
}
Supplier supplier = customErpEntities.Supplier.Where <Supplier>((Expression <Func <Supplier, bool> >)(sp => sp.IDNUMBER == supplierName.SupplierID)).FirstOrDefault <Supplier>();
if (supplier != null)
{
supplierName.SupplierName = supplier.SupplierName;
}
}
purchaseList1 = list1;
purchaseList2 = purchaseList1;
}
}
catch (Exception ex)
{
purchaseList2 = purchaseList1;
}
return(purchaseList2);
}
public List <Sales> GetSales()
{
List <Sales> salesList1 = new List <Sales>();
cls_user_responses clsUserResponses = new cls_user_responses();
List <Sales> salesList2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
List <Sales> list1 = customErpEntities.Sales.Select <Sales, Sales>((Expression <Func <Sales, Sales> >)(itm => itm)).ToList <Sales>();
foreach (Sales sales in list1)
{
Sales customerName = sales;
List <SalesDetails> list2 = customErpEntities.SalesDetails.Where <SalesDetails>((Expression <Func <SalesDetails, bool> >)(sl => sl.SalesID == customerName.IDNUMBER)).ToList <SalesDetails>();
if (list2.Count > 0)
{
foreach (SalesDetails salesDetails in list2)
{
SalesDetails itemName = salesDetails;
Item obj = customErpEntities.Item.Where <Item>((Expression <Func <Item, bool> >)(it => it.IDNUMBER == itemName.ItemID)).FirstOrDefault <Item>();
if (obj != null)
{
itemName.ItemName = obj.ItemName;
itemName.ProductImage = obj.ItemImage;
ItemVarient itemVarient = customErpEntities.ItemVarient.Where <ItemVarient>((Expression <Func <ItemVarient, bool> >)(itv => itv.IDNUMBER == itemName.ItemVarientID)).FirstOrDefault <ItemVarient>();
if (itemVarient != null)
{
itemName.Color = itemVarient.Color;
itemName.SKU = itemVarient.SKU;
itemName.UPC = itemVarient.UPC;
}
}
}
customerName.SalesDetails = list2;
}
Customer customer = customErpEntities.Customer.Where <Customer>((Expression <Func <Customer, bool> >)(cp => cp.IDNUMBER == customerName.CustomerID)).FirstOrDefault <Customer>();
if (customer != null)
{
customerName.CustomerName = customer.CustomerName;
}
}
salesList1 = list1;
salesList2 = salesList1;
}
}
catch (Exception ex)
{
salesList2 = salesList1;
}
return(salesList2);
}
public cls_login_responses LogIn(
string sp_name,
cls_login_requests login_requests)
{
login_requests.Password = Cryptography.Encrypt(login_requests.Password);
cls_login_responses clsLoginResponses1 = new cls_login_responses();
cls_login_responses clsLoginResponses2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
foreach (cls_login_responses clsLoginResponses3 in customErpEntities.Database.SqlQuery <cls_login_responses>(sp_name + " @email, @password", (object)new SqlParameter("@email", (object)login_requests.Email), (object)new SqlParameter("@password", (object)login_requests.Password)))
{
if (clsLoginResponses3.ResponseCode == 200)
{
clsLoginResponses1.ResponseCode = clsLoginResponses3.ResponseCode;
clsLoginResponses1.ResponseMessage = clsLoginResponses3.ResponseMessage;
clsLoginResponses1.UserID = clsLoginResponses3.UserID;
clsLoginResponses1.UserIDNumber = clsLoginResponses3.UserIDNumber;
clsLoginResponses1.UserName = clsLoginResponses3.UserName;
clsLoginResponses1.UserType = clsLoginResponses3.UserType;
clsLoginResponses1.CompanyID = clsLoginResponses3.CompanyID;
clsLoginResponses1.IsSuperUser = clsLoginResponses3.IsSuperUser;
clsLoginResponses1.CompanyName = clsLoginResponses3.CompanyName;
}
else if (clsLoginResponses3.ResponseCode != 400)
{
clsLoginResponses1.ResponseCode = 400;
clsLoginResponses1.ResponseMessage = "Username or Password is incorrect";
clsLoginResponses1.UserIDNumber = 0;
}
else
{
clsLoginResponses1.ResponseCode = clsLoginResponses3.ResponseCode;
clsLoginResponses1.ResponseMessage = clsLoginResponses3.ResponseMessage;
clsLoginResponses1.UserIDNumber = 0;
}
}
clsLoginResponses2 = clsLoginResponses1;
}
}
catch (Exception ex)
{
clsLoginResponses1.ResponseCode = 400;
clsLoginResponses1.ResponseMessage = "Something went wrong, please try again later.";
clsLoginResponses1.UserIDNumber = 0;
clsLoginResponses2 = clsLoginResponses1;
}
return(clsLoginResponses2);
}
public static bool saveSalesContractDetail(
SalesContract salescontract_requests,
int ResponseGenID)
{
Stockdbf stockdbf = new Stockdbf();
StockDetails stockDetails = new StockDetails();
bool flag = false;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
if (salescontract_requests.SalescontractDetails != null)
{
if (salescontract_requests.SalescontractDetails.Count > 0)
{
foreach (SalesContractDetails salescontractDetail1 in salescontract_requests.SalescontractDetails)
{
SalesContractDetails salescontractDetail = salescontractDetail1;
salescontractDetail.SalesID = ResponseGenID;
SalesContractDetails salesContractDetails = customErpEntities.SalesContractDetails.Where <SalesContractDetails>((Expression <Func <SalesContractDetails, bool> >)(iv => iv.IDNUMBER == salescontractDetail.IDNUMBER && iv.SalesID == ResponseGenID)).SingleOrDefault <SalesContractDetails>();
if (salesContractDetails == null)
{
customErpEntities.SalesContractDetails.Add(salescontractDetail);
customErpEntities.SaveChanges();
}
else
{
salesContractDetails.Price = salescontractDetail.Price;
salesContractDetails.Qty = salescontractDetail.Qty;
salesContractDetails.TotalAmount = salescontractDetail.TotalAmount;
salesContractDetails.CompanyID = salescontractDetail.CompanyID;
salesContractDetails.UnitID = salescontractDetail.UnitID;
customErpEntities.SaveChanges();
}
}
}
flag = true;
}
flag = true;
}
}
catch (Exception ex)
{
flag = false;
}
return(flag);
}
public cls_common_responses CreateUser(string sp_name, Users user_requests)
{
user_requests.CompanyID = new int?(1);
cls_common_responses clsCommonResponses1 = new cls_common_responses();
user_requests.pswd = Cryptography.Encrypt(user_requests.pswd);
cls_common_responses clsCommonResponses2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
foreach (cls_common_responses clsCommonResponses3 in customErpEntities.Database.SqlQuery <cls_common_responses>(sp_name + " @prmIDNUMBER, @prmCompanyID, @prmUserType, @prmUserID, @prmUserName, @prmpswd, @prmEmailID, @prmMobileNo, @prmBOD, @prmIsActive, @prmIsSuperUser", (object)new SqlParameter("@prmIDNUMBER", (object)user_requests.IDNUMBER), (object)new SqlParameter("@prmCompanyID", (object)user_requests.CompanyID), (object)new SqlParameter("@prmUserType", (object)user_requests.UserType), (object)new SqlParameter("@prmUserID", (object)user_requests.UserID), (object)new SqlParameter("@prmUserName", (object)user_requests.UserName), (object)new SqlParameter("@prmpswd", (object)user_requests.pswd), (object)new SqlParameter("@prmEmailID", (object)user_requests.EmailID), (object)new SqlParameter("@prmMobileNo", (object)user_requests.MobileNo), (object)new SqlParameter("@prmBOD", (object)user_requests.BOD), (object)new SqlParameter("@prmIsActive", (object)user_requests.IsActive), (object)new SqlParameter("@prmIsSuperUser", (object)user_requests.IsSuperUser)))
{
if (clsCommonResponses3.ResponseCode == 200)
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
else if (clsCommonResponses3.ResponseCode != 400)
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
else
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
}
clsCommonResponses2 = clsCommonResponses1;
}
}
catch (Exception ex)
{
clsCommonResponses1.ResponseGenID = 0;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = "Something went wrong, please try again later.";
clsCommonResponses2 = clsCommonResponses1;
}
return(clsCommonResponses2);
}
public cls_common_responses CreateExpenses(
string sp_name,
Expenses expenses_requests)
{
cls_common_responses clsCommonResponses1 = new cls_common_responses();
cls_common_responses clsCommonResponses2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
foreach (cls_common_responses clsCommonResponses3 in customErpEntities.Database.SqlQuery <cls_common_responses>(sp_name + " @prmIDNUMBER, @prmCompanyID, @prmExpenseName, @prmPaidBy, @prmWallet, @prmItem, @prmItemID, @prmItemVarientID, @prmCurrency, @prmCost, @prmUSDCost, @prmNote, @prmIsActive, @prmCreatedBy", (object)new SqlParameter("prmIDNUMBER", (object)expenses_requests.IDNUMBER), (object)new SqlParameter("prmCompanyID", (object)expenses_requests.CompanyID), (object)new SqlParameter("@prmExpenseName", (object)expenses_requests.ExpenseName), (object)new SqlParameter("@prmPaidBy", (object)expenses_requests.PaidBy), (object)new SqlParameter("@prmWallet", (object)expenses_requests.Wallet), (object)new SqlParameter("@prmItem", (object)expenses_requests.Item), (object)new SqlParameter("@prmItemID", (object)expenses_requests.ItemID), (object)new SqlParameter("@prmItemVarientID", (object)expenses_requests.ItemVarientID), (object)new SqlParameter("@prmCurrency", (object)expenses_requests.Currency), (object)new SqlParameter("@prmCost", (object)expenses_requests.Cost), (object)new SqlParameter("@prmUSDCost", (object)expenses_requests.USDCost), (object)new SqlParameter("@prmNote", (object)expenses_requests.Note), (object)new SqlParameter("@prmIsActive", (object)expenses_requests.IsActive), (object)new SqlParameter("@prmCreatedBy", (object)expenses_requests.CreatedBy)))
{
if (clsCommonResponses3.ResponseCode == 200)
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
else if (clsCommonResponses3.ResponseCode != 400)
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
else
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
}
clsCommonResponses2 = clsCommonResponses1;
}
}
catch (Exception ex)
{
clsCommonResponses1.ResponseGenID = 0;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = "Something went wrong, please try again later.";
clsCommonResponses2 = clsCommonResponses1;
}
return(clsCommonResponses2);
}
public cls_common_responses CreateEmployee(
string sp_name,
Employee employee_requests)
{
cls_common_responses clsCommonResponses1 = new cls_common_responses();
cls_common_responses clsCommonResponses2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
foreach (cls_common_responses clsCommonResponses3 in customErpEntities.Database.SqlQuery <cls_common_responses>(sp_name + " @prmIDNUMBER, @prmCompanyID, @prmEmpFirstName, @prmEmpSurName, @prmEmployeeAddress, @prmPhoneNo, @prmEmailID, @prmPosition,@prmEmploymentStart, @prmEmployeeEnd, @prmNotes, @prmIsEmployeement, @prmIsActive, @prmCreatedBy, @prmCreatedDate, @prmUpdatedBy, @prmUpdatedDate", (object)new SqlParameter("@prmIDNUMBER", (object)employee_requests.IDNUMBER), (object)new SqlParameter("@prmCompanyID", (object)employee_requests.CompanyID), (object)new SqlParameter("@prmEmpFirstName", (object)employee_requests.EmpFirstName), (object)new SqlParameter("@prmEmpSurName", (object)employee_requests.EmpSurName), (object)new SqlParameter("@prmEmployeeAddress", (object)employee_requests.EmployeeAddress), (object)new SqlParameter("@prmPhoneNo", (object)employee_requests.PhoneNo), (object)new SqlParameter("@prmEmailID", (object)employee_requests.EmailID), (object)new SqlParameter("@prmPosition", (object)employee_requests.Position), (object)new SqlParameter("@prmEmploymentStart", (object)employee_requests.EmploymentStart), (object)new SqlParameter("@prmEmployeeEnd", (object)employee_requests.EmployeeEnd), (object)new SqlParameter("@prmNotes", (object)employee_requests.Notes), (object)new SqlParameter("@prmIsEmployeement", (object)employee_requests.IsEmployeement), (object)new SqlParameter("@prmIsActive", (object)employee_requests.IsActive), (object)new SqlParameter("@prmCreatedBy", (object)employee_requests.CreatedBy), (object)new SqlParameter("@prmCreatedDate", (object)employee_requests.CreatedDate), (object)new SqlParameter("@prmUpdatedBy", (object)employee_requests.UpdatedBy), (object)new SqlParameter("@prmUpdatedDate", (object)employee_requests.UpdatedDate)))
{
if (clsCommonResponses3.ResponseCode == 200)
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
else if (clsCommonResponses3.ResponseCode != 400)
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
else
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
}
clsCommonResponses2 = clsCommonResponses1;
}
}
catch (Exception ex)
{
clsCommonResponses1.ResponseGenID = 0;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = "Something went wrong, please try again later.";
clsCommonResponses2 = clsCommonResponses1;
}
return(clsCommonResponses2);
}
public cls_common_responses CreateSuplier(
string sp_name,
Supplier supplier_requests)
{
cls_common_responses clsCommonResponses1 = new cls_common_responses();
cls_common_responses clsCommonResponses2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
foreach (cls_common_responses clsCommonResponses3 in customErpEntities.Database.SqlQuery <cls_common_responses>(sp_name + " @prmIDNUMBER, @prmCompanyID, @prmSupplierName, @prmSupplierAddress, @prmPhoneNo1, @prmPhoneNo2, @prmEmailID,@prmCompanyName, @prmCompAddress, @prmWebsite, @prmCompEmail, @prmDesignation, @prmShippingAddress, @prmContFirstName1, @prmContSurname1, @prmContPosition1, @prmContEmail1, @prmContPhone1, @prmContFirstName2,@prmContSurname2, @prmContPosition2, @prmContEmail2, @prmContPhone2, @prmBankName, @prmBankAddress, @prmIBAN, @prmSWIFT, @prmAccountNumber, @prmNote, @prmIsActive, @prmCreatedBy, @prmCreatedDate, @prmUpdatedBy, @prmUpdatedDate", (object)new SqlParameter("@prmIDNUMBER", (object)supplier_requests.IDNUMBER), (object)new SqlParameter("@prmCompanyID", (object)supplier_requests.CompanyID), (object)new SqlParameter("@prmSupplierName", (object)supplier_requests.SupplierName), (object)new SqlParameter("@prmSupplierAddress", (object)supplier_requests.SupplierAddress), (object)new SqlParameter("@prmPhoneNo1", (object)supplier_requests.PhoneNo1), (object)new SqlParameter("@prmPhoneNo2", (object)supplier_requests.PhoneNo2), (object)new SqlParameter("@prmEmailID", (object)supplier_requests.EmailID), (object)new SqlParameter("@prmCompanyName", (object)supplier_requests.CompanyName), (object)new SqlParameter("@prmCompAddress", (object)supplier_requests.CompAddress), (object)new SqlParameter("@prmWebsite", (object)supplier_requests.Website), (object)new SqlParameter("@prmCompEmail", (object)supplier_requests.CompEmail), (object)new SqlParameter("@prmDesignation", (object)supplier_requests.Designation), (object)new SqlParameter("@prmShippingAddress", (object)supplier_requests.ShippingAddress), (object)new SqlParameter("@prmContFirstName1", (object)supplier_requests.ContFirstName1), (object)new SqlParameter("@prmContSurname1", (object)supplier_requests.ContSurname1), (object)new SqlParameter("@prmContPosition1", (object)supplier_requests.ContPosition1), (object)new SqlParameter("@prmContEmail1", (object)supplier_requests.ContEmail1), (object)new SqlParameter("@prmContPhone1", (object)supplier_requests.ContPhone1), (object)new SqlParameter("@prmContFirstName2", (object)supplier_requests.ContFirstName2), (object)new SqlParameter("@prmContSurname2", (object)supplier_requests.ContSurname2), (object)new SqlParameter("@prmContPosition2", (object)supplier_requests.ContPosition2), (object)new SqlParameter("@prmContEmail2", (object)supplier_requests.ContEmail2), (object)new SqlParameter("@prmContPhone2", (object)supplier_requests.ContPhone2), (object)new SqlParameter("@prmBankName", (object)supplier_requests.BankName), (object)new SqlParameter("@prmBankAddress", (object)supplier_requests.BankAddress), (object)new SqlParameter("@prmIBAN", (object)supplier_requests.IBAN), (object)new SqlParameter("@prmSWIFT", (object)supplier_requests.SWIFT), (object)new SqlParameter("@prmAccountNumber", (object)supplier_requests.AccountNumber), (object)new SqlParameter("@prmNote", (object)supplier_requests.Note), (object)new SqlParameter("@prmIsActive", (object)supplier_requests.IsActive), (object)new SqlParameter("@prmCreatedBy", (object)supplier_requests.CreatedBy), (object)new SqlParameter("@prmCreatedDate", (object)supplier_requests.CreatedDate), (object)new SqlParameter("@prmUpdatedBy", (object)supplier_requests.UpdatedBy), (object)new SqlParameter("@prmUpdatedDate", (object)supplier_requests.UpdatedDate)))
{
if (clsCommonResponses3.ResponseCode == 200)
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
else if (clsCommonResponses3.ResponseCode != 400)
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
else
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
}
clsCommonResponses2 = clsCommonResponses1;
}
}
catch (Exception ex)
{
clsCommonResponses1.ResponseGenID = 0;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = "Something went wrong, please try again later.";
clsCommonResponses2 = clsCommonResponses1;
}
return(clsCommonResponses2);
}
public cls_common_responses Createwarehouse(
string sp_name,
Warehouse warehouse_requests)
{
cls_common_responses clsCommonResponses1 = new cls_common_responses();
cls_common_responses clsCommonResponses2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
foreach (cls_common_responses clsCommonResponses3 in customErpEntities.Database.SqlQuery <cls_common_responses>(sp_name + " @prmIDNUMBER, @prmCompanyID, @prmWarehouseName, @prmAddress, @prmIsActive, @prmCreatedDate, @prmCreatedBy, @prmUpdateDate, @prmUpdatedBy", (object)new SqlParameter("@prmIDNUMBER", (object)warehouse_requests.IDNUMBER), (object)new SqlParameter("@prmCompanyID", (object)warehouse_requests.CompanyID), (object)new SqlParameter("@prmWarehouseName", (object)warehouse_requests.WarehouseName), (object)new SqlParameter("@prmAddress", (object)warehouse_requests.Address), (object)new SqlParameter("@prmIsActive", (object)warehouse_requests.IsActive), (object)new SqlParameter("@prmCreatedDate", (object)warehouse_requests.CreatedDate), (object)new SqlParameter("@prmCreatedBy", (object)warehouse_requests.CreatedBy), (object)new SqlParameter("@prmUpdateDate", (object)warehouse_requests.UpdatedDate), (object)new SqlParameter("@prmUpdatedBy", (object)warehouse_requests.UpdatedBy)))
{
if (clsCommonResponses3.ResponseCode == 200)
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
else if (clsCommonResponses3.ResponseCode != 400)
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
else
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
}
clsCommonResponses2 = clsCommonResponses1;
}
}
catch (Exception ex)
{
clsCommonResponses1.ResponseGenID = 0;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = "Something went wrong, please try again later.";
clsCommonResponses2 = clsCommonResponses1;
}
return(clsCommonResponses2);
}
public cls_DashBoard_Data GetDashBoardData()
{
cls_DashBoard_Data clsDashBoardData1 = new cls_DashBoard_Data();
cls_DashBoard_Data clsDashBoardData2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
int num1 = customErpEntities.Users.Select <Users, Users>((Expression <Func <Users, Users> >)(us => us)).Count <Users>();
int num2 = customErpEntities.Supplier.Select <Supplier, Supplier>((Expression <Func <Supplier, Supplier> >)(us => us)).Count <Supplier>();
int num3 = customErpEntities.Customer.Select <Customer, Customer>((Expression <Func <Customer, Customer> >)(us => us)).Count <Customer>();
int num4 = customErpEntities.Employee.Select <Employee, Employee>((Expression <Func <Employee, Employee> >)(us => us)).Count <Employee>();
int num5 = customErpEntities.Item.Select <Item, Item>((Expression <Func <Item, Item> >)(us => us)).Count <Item>();
int num6 = customErpEntities.Purchase.Select <Purchase, Purchase>((Expression <Func <Purchase, Purchase> >)(us => us)).Count <Purchase>();
int num7 = customErpEntities.Sales.Select <Sales, Sales>((Expression <Func <Sales, Sales> >)(us => us)).Count <Sales>();
clsDashBoardData1.UserCount = num1;
clsDashBoardData1.SupplierCount = num2;
clsDashBoardData1.CustomerCount = num3;
clsDashBoardData1.EmployeeCount = num4;
clsDashBoardData1.ProductCount = num5;
clsDashBoardData1.PurchaseCount = num6;
clsDashBoardData1.SalesCount = num7;
}
clsDashBoardData2 = clsDashBoardData1;
}
catch (Exception ex)
{
clsDashBoardData1.UserCount = 0;
clsDashBoardData1.SupplierCount = 0;
clsDashBoardData1.CustomerCount = 0;
clsDashBoardData1.EmployeeCount = 0;
clsDashBoardData1.ProductCount = 0;
clsDashBoardData1.PurchaseCount = 0;
clsDashBoardData1.SalesCount = 0;
clsDashBoardData2 = clsDashBoardData1;
}
return(clsDashBoardData2);
}
public List <Expenses> GetExpenses()
{
List <Expenses> expensesList1 = new List <Expenses>();
List <Expenses> expensesList2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
List <Expenses> list = customErpEntities.Expenses.Select <Expenses, Expenses>((Expression <Func <Expenses, Expenses> >)(ex => ex)).ToList <Expenses>();
if (list.Count > 0)
{
expensesList1 = list;
}
expensesList2 = expensesList1;
}
}
catch (Exception ex)
{
expensesList2 = expensesList1;
}
return(expensesList2);
}
public string GetLastSalesContractID()
{
int num = 0;
string str1 = "";
string str2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
num = customErpEntities.Sales.OrderByDescending <Sales, int>((Expression <Func <Sales, int> >)(p => p.IDNUMBER)).Select <Sales, int>((Expression <Func <Sales, int> >)(p => p.IDNUMBER)).FirstOrDefault <int>();
if ((uint)num > 0U)
{
if (num.ToString().Length == 4)
{
str1 = num.ToString();
}
if (num.ToString().Length == 3)
{
str1 = "0" + num.ToString();
}
else if (num.ToString().Length == 2)
{
str1 = "00" + num.ToString();
}
else if (num.ToString().Length == 1)
{
str1 = "000" + num.ToString();
}
}
str2 = str1;
}
catch (Exception ex)
{
str2 = str1;
}
return(str2);
}
public string LastPurchaseID(bool lastId = false)
{
int num = 0;
string str1 = "";
string str2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
num = customErpEntities.Purchase.OrderByDescending <Purchase, int>((Expression <Func <Purchase, int> >)(p => p.IDNUMBER)).Select <Purchase, int>((Expression <Func <Purchase, int> >)(p => p.IDNUMBER)).FirstOrDefault <int>();
if ((uint)num > 0U)
{
if (num.ToString().Length == 4)
{
str1 = num.ToString();
}
if (num.ToString().Length == 3)
{
str1 = "0" + num.ToString();
}
else if (num.ToString().Length == 2)
{
str1 = "00" + num.ToString();
}
else if (num.ToString().Length == 1)
{
str1 = "000" + num.ToString();
}
}
str2 = str1;
}
catch (Exception ex)
{
str2 = str1;
}
return(str2);
}
public List <Warehouse> GetWarehouses()
{
List <Warehouse> warehouseList1 = new List <Warehouse>();
cls_user_responses clsUserResponses = new cls_user_responses();
List <Warehouse> warehouseList2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
List <Warehouse> list = customErpEntities.Warehouse.Select <Warehouse, Warehouse>((Expression <Func <Warehouse, Warehouse> >)(war => war)).ToList <Warehouse>();
if (list.Count > 0)
{
warehouseList1 = list;
}
warehouseList2 = warehouseList1;
}
}
catch (Exception ex)
{
warehouseList2 = warehouseList1;
}
return(warehouseList2);
}
public List <Supplier> GetSupplier()
{
List <Supplier> supplierList1 = new List <Supplier>();
cls_user_responses clsUserResponses = new cls_user_responses();
List <Supplier> supplierList2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
List <Supplier> list = customErpEntities.Supplier.Select <Supplier, Supplier>((Expression <Func <Supplier, Supplier> >)(sup => sup)).ToList <Supplier>();
if (list.Count > 0)
{
supplierList1 = list;
}
supplierList2 = supplierList1;
}
}
catch (Exception ex)
{
supplierList2 = supplierList1;
}
return(supplierList2);
}
public List <Customer> GetCustomers()
{
List <Customer> customerList1 = new List <Customer>();
cls_user_responses clsUserResponses = new cls_user_responses();
List <Customer> customerList2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
List <Customer> list = customErpEntities.Customer.Select <Customer, Customer>((Expression <Func <Customer, Customer> >)(cus => cus)).ToList <Customer>();
if (list.Count > 0)
{
customerList1 = list;
}
customerList2 = customerList1;
}
}
catch (Exception ex)
{
customerList2 = customerList1;
}
return(customerList2);
}
public List <Category> GetCategories()
{
List <Category> categoryList1 = new List <Category>();
cls_user_responses clsUserResponses = new cls_user_responses();
List <Category> categoryList2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
List <Category> list = customErpEntities.Category.Select <Category, Category>((Expression <Func <Category, Category> >)(cat => cat)).ToList <Category>();
if (list.Count > 0)
{
categoryList1 = list;
}
categoryList2 = categoryList1;
}
}
catch (Exception ex)
{
categoryList2 = categoryList1;
}
return(categoryList2);
}
public List <Employee> GetEmployees()
{
List <Employee> employeeList1 = new List <Employee>();
cls_user_responses clsUserResponses = new cls_user_responses();
List <Employee> employeeList2;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
List <Employee> list = customErpEntities.Employee.Select <Employee, Employee>((Expression <Func <Employee, Employee> >)(emp => emp)).ToList <Employee>();
if (list.Count > 0)
{
employeeList1 = list;
}
employeeList2 = employeeList1;
}
}
catch (Exception ex)
{
employeeList2 = employeeList1;
}
return(employeeList2);
}
public static bool saveStocks(Item product_requests, int ResponseGenID)
{
Stockdbf entity1 = new Stockdbf();
StockDetails entity2 = new StockDetails();
ItemVarient itemVarient1 = new ItemVarient();
bool flag = false;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
if (product_requests.ItemVarients != null)
{
if (product_requests.ItemVarients.Count > 0)
{
foreach (ItemVarient itemVarient2 in product_requests.ItemVarients)
{
ItemVarient responseGenID = itemVarient2;
responseGenID.ItemID = ResponseGenID;
responseGenID.CreatedBy = new int?(1);
responseGenID.CreatedDate = new DateTime?(DateTime.Now);
responseGenID.UpdateBy = new int?(1);
responseGenID.UpdatedDate = new DateTime?(DateTime.Now);
ItemVarient warehouseID = customErpEntities.ItemVarient.Where <ItemVarient>((Expression <Func <ItemVarient, bool> >)(iv => iv.IDNUMBER == responseGenID.IDNUMBER && iv.ItemID == ResponseGenID)).SingleOrDefault <ItemVarient>();
if (warehouseID == null)
{
warehouseID = responseGenID;
entity1.StockQty = responseGenID.Inventory;
warehouseID.WarehouseID = responseGenID.WarehouseID;
customErpEntities.ItemVarient.Add(warehouseID);
customErpEntities.SaveChanges();
if (customErpEntities.Stockdbf.Where <Stockdbf>((Expression <Func <Stockdbf, bool> >)(st => st.ItemID == responseGenID.ItemID && st.ItemVarientID == responseGenID.IDNUMBER)).FirstOrDefault <Stockdbf>() != null)
{
entity1.StockQty = responseGenID.Inventory;
customErpEntities.SaveChanges();
entity2.StockQty = responseGenID.Inventory;
entity2.StockRate = warehouseID.Cost;
entity2.TranNo = product_requests.ItemName;
customErpEntities.SaveChanges();
}
else
{
entity1.CompanyID = new int?(1);
entity1.ItemID = responseGenID.ItemID;
entity1.ItemVarientID = responseGenID.IDNUMBER;
entity1.StockQty = warehouseID.Inventory;
customErpEntities.Stockdbf.Add(entity1);
customErpEntities.SaveChanges();
entity2.CompanyID = new int?(1);
entity2.StockID = entity1.IDNUMBER;
entity2.ItemID = responseGenID.ItemID;
entity2.ItemVarientID = responseGenID.IDNUMBER;
entity2.StockQty = responseGenID.Inventory;
entity2.StockRate = responseGenID.Cost;
entity2.TranCode = "C";
entity2.TranBook = "OP";
entity2.TranNo = product_requests.ItemName;
entity2.CreatedBy = new int?(1);
entity2.CreatedDate = new DateTime?(DateTime.Now);
customErpEntities.StockDetails.Add(entity2);
customErpEntities.SaveChanges();
}
flag = true;
}
else
{
warehouseID.Color = responseGenID.Color;
warehouseID.Size = responseGenID.Size;
warehouseID.Inventory = responseGenID.Inventory;
warehouseID.WarehouseID = responseGenID.WarehouseID;
warehouseID.Cost = responseGenID.Cost;
warehouseID.SKU = responseGenID.SKU;
warehouseID.UPC = responseGenID.UPC;
customErpEntities.SaveChanges();
if (customErpEntities.Stockdbf.FirstOrDefault <Stockdbf>((Expression <Func <Stockdbf, bool> >)(x => x.ItemID == warehouseID.ItemID && x.ItemVarientID == warehouseID.IDNUMBER)) != null)
{
entity1.StockQty = warehouseID.Inventory;
customErpEntities.SaveChanges();
entity2.StockQty = responseGenID.Inventory;
entity2.StockRate = warehouseID.Cost;
entity2.TranNo = product_requests.ItemName;
customErpEntities.SaveChanges();
}
else
{
entity1.CompanyID = new int?(1);
entity1.ItemID = warehouseID.ItemID;
entity1.ItemVarientID = warehouseID.IDNUMBER;
entity1.StockQty = warehouseID.Inventory;
customErpEntities.Stockdbf.Add(entity1);
customErpEntities.SaveChanges();
entity2.CompanyID = new int?(1);
entity2.StockID = entity1.IDNUMBER;
entity2.ItemID = warehouseID.ItemID;
entity2.ItemVarientID = warehouseID.IDNUMBER;
entity2.StockQty = warehouseID.Inventory;
entity2.StockRate = warehouseID.Cost;
entity2.TranCode = "C";
entity2.TranBook = "OP";
entity2.TranNo = product_requests.ItemName;
entity2.CreatedBy = new int?(1);
entity2.CreatedDate = new DateTime?(DateTime.Now);
customErpEntities.StockDetails.Add(entity2);
customErpEntities.SaveChanges();
}
flag = true;
}
}
}
flag = true;
}
flag = true;
}
}
catch (Exception ex)
{
flag = false;
}
return(flag);
}
public static bool saveStocks(Sales sales_requests, int ResponseGenID)
{
Stockdbf stockdbf = new Stockdbf();
StockDetails entity = new StockDetails();
bool flag = false;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
if (sales_requests.SalesDetails != null)
{
if (sales_requests.SalesDetails.Count > 0)
{
foreach (SalesDetails salesDetail1 in sales_requests.SalesDetails)
{
SalesDetails salesDetail = salesDetail1;
salesDetail.SalesID = ResponseGenID;
SalesDetails salesDetails = customErpEntities.SalesDetails.Where <SalesDetails>((Expression <Func <SalesDetails, bool> >)(iv => iv.IDNUMBER == salesDetail.IDNUMBER && iv.SalesID == ResponseGenID)).SingleOrDefault <SalesDetails>();
if (salesDetails == null)
{
customErpEntities.SalesDetails.Add(salesDetail);
customErpEntities.SaveChanges();
if (customErpEntities.Stockdbf.FirstOrDefault <Stockdbf>((Expression <Func <Stockdbf, bool> >)(x => x.ItemID == salesDetail.ItemID && x.ItemVarientID == salesDetail.ItemVarientID)) != null)
{
stockdbf.StockQty -= salesDetail.Qty;
customErpEntities.SaveChanges();
entity.CompanyID = new int?(1);
entity.StockID = stockdbf.IDNUMBER;
entity.ItemID = salesDetail.ItemID;
entity.ItemVarientID = salesDetail.IDNUMBER;
entity.StockQty = salesDetail.Qty;
entity.StockRate = salesDetail.Price;
entity.TranCode = "D";
entity.TranBook = "SLS";
entity.TranNo = sales_requests.SONO;
entity.CreatedBy = new int?(1);
entity.CreatedDate = new DateTime?(DateTime.Now);
customErpEntities.StockDetails.Add(entity);
customErpEntities.SaveChanges();
}
flag = true;
}
else
{
salesDetails.Price = salesDetail.Price;
salesDetails.Qty = salesDetail.Qty;
salesDetails.TotalAmount = salesDetail.TotalAmount;
salesDetails.CompanyID = salesDetail.CompanyID;
salesDetails.UnitID = salesDetail.UnitID;
customErpEntities.SaveChanges();
if (customErpEntities.Stockdbf.FirstOrDefault <Stockdbf>((Expression <Func <Stockdbf, bool> >)(x => x.ItemID == salesDetail.ItemID && x.ItemVarientID == salesDetail.ItemVarientID)) != null)
{
stockdbf.StockQty -= salesDetails.Qty;
customErpEntities.SaveChanges();
entity.CompanyID = new int?(1);
entity.StockID = stockdbf.IDNUMBER;
entity.ItemID = salesDetails.ItemID;
entity.ItemVarientID = salesDetails.IDNUMBER;
entity.StockQty = salesDetails.Qty;
entity.StockRate = salesDetails.Price;
entity.TranCode = "D";
entity.TranBook = "SLS";
entity.TranNo = sales_requests.SONO;
entity.CreatedBy = new int?(1);
entity.CreatedDate = new DateTime?(DateTime.Now);
customErpEntities.StockDetails.Add(entity);
customErpEntities.SaveChanges();
}
flag = true;
}
}
}
flag = true;
}
flag = true;
}
}
catch (Exception ex)
{
flag = false;
}
return(flag);
}
public cls_common_responses CreateProduct(
string sp_name,
Item product_requests)
{
cls_common_responses clsCommonResponses1 = new cls_common_responses();
cls_common_responses clsCommonResponses2;
try
{
if (product_requests.IsImage == 1)
{
string str = ProductManager.SaveBranchFile(product_requests.ItemImage, "Item", product_requests.ItemName);
product_requests.ItemImage = !(str != "error") ? "../dist/img/user-image.png" : str;
}
else if (product_requests.IDNUMBER == 0)
{
product_requests.ItemImage = "../dist/img/user-image.png";
}
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
foreach (cls_common_responses clsCommonResponses3 in customErpEntities.Database.SqlQuery <cls_common_responses>(sp_name + " @prmIDNUMBER, @prmCompanyID, @prmItemName, @prmItemImage, @prmCategoryID, @prmDescription, @prmcmLength, @prmcmHeight,@prmcmWidth, @prminchLength, @prminchHeight, @prminchWidth, @prmkgWeight, @prmlbsWeight, @prmNote, @prmIsActive, @prmCreatedBy, @prmUpdateBy", (object)new SqlParameter("@prmIDNUMBER", (object)product_requests.IDNUMBER), (object)new SqlParameter("@prmCompanyID", (object)product_requests.CompanyID), (object)new SqlParameter("@prmItemName", (object)product_requests.ItemName), (object)new SqlParameter("@prmItemImage", (object)product_requests.ItemImage), (object)new SqlParameter("@prmCategoryID", (object)product_requests.CategoryID), (object)new SqlParameter("@prmDescription", (object)product_requests.Description), (object)new SqlParameter("@prmcmLength", (object)product_requests.cmLength), (object)new SqlParameter("@prmcmHeight", (object)product_requests.cmHeight), (object)new SqlParameter("@prmcmWidth", (object)product_requests.cmWidth), (object)new SqlParameter("@prminchLength", (object)product_requests.inchLength), (object)new SqlParameter("@prminchHeight", (object)product_requests.inchHeight), (object)new SqlParameter("@prminchWidth", (object)product_requests.inchWidth), (object)new SqlParameter("@prmkgWeight", (object)product_requests.kgWeight), (object)new SqlParameter("@prmlbsWeight", (object)product_requests.lbsWeight), (object)new SqlParameter("@prmNote", (object)product_requests.Note), (object)new SqlParameter("@prmIsActive", (object)product_requests.IsActive), (object)new SqlParameter("@prmCreatedBy", (object)product_requests.CreatedBy), (object)new SqlParameter("@prmUpdateBy", (object)product_requests.UpdateBy)))
{
if (clsCommonResponses3.ResponseCode == 200)
{
if (!ProductManager.saveStocks(product_requests, clsCommonResponses3.ResponseGenID))
{
clsCommonResponses1.ResponseGenID = 0;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = "Something went wrong in Stock Insertion!!";
}
else
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
}
else if (clsCommonResponses3.ResponseCode != 400)
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
else
{
clsCommonResponses1.ResponseGenID = clsCommonResponses3.ResponseGenID;
clsCommonResponses1.ResponseCode = clsCommonResponses3.ResponseCode;
clsCommonResponses1.ResponseMessage = clsCommonResponses3.ResponseMessage;
}
}
clsCommonResponses2 = clsCommonResponses1;
}
}
catch (Exception ex)
{
clsCommonResponses1.ResponseGenID = 0;
clsCommonResponses1.ResponseCode = 400;
clsCommonResponses1.ResponseMessage = "Something went wrong, please try again later.";
clsCommonResponses2 = clsCommonResponses1;
}
return(clsCommonResponses2);
}
public static bool saveStocks(Purchase purchase_requests, int ResponseGenID)
{
Stockdbf stockdbf = new Stockdbf();
StockDetails entity = new StockDetails();
bool flag = false;
try
{
using (CustomERPEntities customErpEntities = new CustomERPEntities())
{
if (purchase_requests.PurchaseDetails != null)
{
if (purchase_requests.PurchaseDetails.Count > 0)
{
foreach (PurchaseDetails purchaseDetail1 in purchase_requests.PurchaseDetails)
{
PurchaseDetails purchaseDetail = purchaseDetail1;
purchaseDetail.PurchaseID = ResponseGenID;
PurchaseDetails purchaseDetails = customErpEntities.PurchaseDetails.Where <PurchaseDetails>((Expression <Func <PurchaseDetails, bool> >)(iv => iv.IDNUMBER == purchaseDetail.IDNUMBER && iv.PurchaseID == ResponseGenID)).SingleOrDefault <PurchaseDetails>();
if (purchaseDetails == null)
{
customErpEntities.PurchaseDetails.Add(purchaseDetail);
customErpEntities.SaveChanges();
if (customErpEntities.Stockdbf.FirstOrDefault <Stockdbf>((Expression <Func <Stockdbf, bool> >)(x => x.ItemID == purchaseDetail.ItemID && x.ItemVarientID == purchaseDetail.ItemVarientID)) != null)
{
stockdbf.StockQty += purchaseDetail.Qty;
customErpEntities.SaveChanges();
entity.CompanyID = new int?(1);
entity.StockID = stockdbf.IDNUMBER;
entity.ItemID = purchaseDetail.ItemID;
entity.ItemVarientID = purchaseDetail.IDNUMBER;
entity.StockQty = purchaseDetail.Qty;
entity.StockRate = purchaseDetail.Price;
entity.TranCode = "C";
entity.TranBook = "PUR";
entity.TranNo = purchase_requests.PONo;
entity.CreatedBy = new int?(1);
entity.CreatedDate = new DateTime?(DateTime.Now);
customErpEntities.StockDetails.Add(entity);
customErpEntities.SaveChanges();
}
flag = true;
}
else
{
purchaseDetails.Price = purchaseDetail.Price;
purchaseDetails.Qty = purchaseDetail.Qty;
purchaseDetails.TotalAmount = purchaseDetail.TotalAmount;
purchaseDetails.CompanyID = purchaseDetail.CompanyID;
purchaseDetails.UnitID = purchaseDetail.UnitID;
customErpEntities.SaveChanges();
if (customErpEntities.Stockdbf.FirstOrDefault <Stockdbf>((Expression <Func <Stockdbf, bool> >)(x => x.ItemID == purchaseDetail.ItemID && x.ItemVarientID == purchaseDetail.ItemVarientID)) != null)
{
stockdbf.StockQty += purchaseDetails.Qty;
customErpEntities.SaveChanges();
entity.CompanyID = new int?(1);
entity.StockID = stockdbf.IDNUMBER;
entity.ItemID = purchaseDetails.ItemID;
entity.ItemVarientID = purchaseDetails.IDNUMBER;
entity.StockQty = purchaseDetails.Qty;
entity.StockRate = purchaseDetails.Price;
entity.TranCode = "C";
entity.TranBook = "PUR";
entity.TranNo = purchase_requests.PONo;
entity.CreatedBy = new int?(1);
entity.CreatedDate = new DateTime?(DateTime.Now);
customErpEntities.StockDetails.Add(entity);
customErpEntities.SaveChanges();
}
flag = true;
}
}
}
flag = true;
}
flag = true;
}
}
catch (Exception ex)
{
flag = false;
}
return(flag);
}
