public IHttpActionResult uploadTransactionDocument(string fileName, long transactionId) { if (HttpContext.Current.Request.Files.AllKeys.Any()) { var httpPostedFile = HttpContext.Current.Request.Files[0]; var userID = BasicAuthHttpModule.getCurrentUserId(); byte[] fileData = null; using (var binaryReader = new BinaryReader(httpPostedFile.InputStream)) { fileData = binaryReader.ReadBytes(httpPostedFile.ContentLength); } if (httpPostedFile != null) { using (var context = new DhoniEnterprisesEntities()) { var fileId = context.uspTransactionFileAdd(transactionId, fileData, Convert.ToString(httpPostedFile.ContentType), fileName, userID); return(Ok(new { success = true, message = "Transaction file added successfully!", fileId = fileId.FirstOrDefault() })); } } } return(Ok(new { success = false, message = "File was not uploaded due to some error" })); }
public IHttpActionResult PostaddNewTransactionBasic([FromBody] JObject transaction) { var trade = transaction["newTransaction"]; using (var context = new DhoniEnterprisesEntities()) { var id = context.uspAddTransactionBasic( Convert.ToDateTime(trade["tr_date"]), Convert.ToInt32(trade["tr_bpBuyerID"]), Convert.ToInt32(trade["tr_bpSellerID"]), Convert.ToInt32(trade["tr_productID"]), Convert.ToString(trade["tr_origin"]), Convert.ToInt32(trade["tr_quantity"]), Convert.ToInt32(trade["tr_price"]), Convert.ToString(trade["tr_packing"]), Convert.ToDateTime(trade["tr_shipment_start"]), Convert.ToDateTime(trade["tr_shipment_end"]), Convert.ToString(trade["tr_fileID"]), Convert.ToString(trade["tr_contractID"]), Convert.ToString(trade["tr_other_info"]), BasicAuthHttpModule.getCurrentUserId(), null, null, null ); return(Ok(new { success = true, message = "Transaction added successfully!", transactionId = id.FirstOrDefault() })); } }
public IHttpActionResult addBusinessPartnerContact([FromBody] JObject contact) { var cn = contact["contact"]; if (Convert.ToString(cn["contactType"]) == "") { return(Ok(new { success = false, message = "No contact type entered!" })); } if (Convert.ToString(cn["contactNumber"]) == "") { return(Ok(new { success = false, message = "No Contact Number entered!" })); } using (var context = new DhoniEnterprisesEntities()) { int userID = BasicAuthHttpModule.getCurrentUserId(); if (userID != -1) { var res = context.uspAddBusinessPartnerContactNumber(Convert.ToInt64(cn["bp_ID"]), Convert.ToString(cn["contactType"]), Convert.ToString(cn["contactNumber"]), userID).FirstOrDefault(); return(Ok(new { success = true, message = "Business Partner contact number added!", conNumID = res })); } else { return(Ok(new { success = false, message = "No User Logged In!" })); } } }
public IHttpActionResult addBusinessPartnerContactPerson([FromBody] JObject contactPerson) { var cp = contactPerson["contactPerson"]; using (var context = new DhoniEnterprisesEntities()) { int userID = BasicAuthHttpModule.getCurrentUserId(); if (userID != -1) { int alreadyPrimary = Convert.ToInt32(context.uspCheckBPPrimaryContactExist(Convert.ToInt32(cp["bp_ID"])).FirstOrDefault()); if (alreadyPrimary <= 0 || !(Convert.ToBoolean(cp["bp_Cont_IsPrimary"]))) { DataTable dt = new DataTable(); var res = context.uspAddBusinessPartnerContact(Convert.ToInt32(cp["bp_ID"]), Convert.ToBoolean(cp["bp_Cont_IsPrimary"]), cp["bp_Cont_fullName"].ToString(), cp["bp_Cont_Designation"].ToString(), cp["bp_Cont_Email"].ToString(), cp["bp_Cont_PrimaryNumber"].ToString(), cp["bp_Cont_SecondaryNumber"].ToString(), userID).FirstOrDefault(); return(Ok(new { success = true, message = "Business Partner Contact Added!", conPerId = res })); } else { return(Ok(new { success = false, message = "This Business Partner already has one primary contact!" })); } } else { return(Ok(new { success = false, message = "No User Logged In!" })); } } }
public IHttpActionResult changePassword([FromBody] JObject passDetails) { using (var context = new DhoniEnterprisesEntities()) { var passwordDetails = passDetails["passwordDetails"]; var oldPass = passwordDetails["oldPassword"]; var newPass = passwordDetails["newPassword"]; var confirmPass = passwordDetails["confirmPassword"]; if (Convert.ToString(newPass) != Convert.ToString(confirmPass)) { return(Ok(new { success = false, message = "Passwords do not match" })); } int userID = BasicAuthHttpModule.getCurrentUserId(); var userDetails = (from user in context.AppUsers where user.UserID.Equals(userID) select user).FirstOrDefault(); string hashedPassword = Security.Security.HashSHA1(Convert.ToString(oldPass) + Convert.ToString(userDetails.UserGuid)); if (hashedPassword != userDetails.UserPass) { return(Ok(new { success = false, message = "Passwords is not correct!" })); } else { Guid userGuid = System.Guid.NewGuid(); string newHashedPass = Security.Security.HashSHA1(Convert.ToString(newPass) + userGuid); context.AppUserChangePasword(userID, newHashedPass, userGuid); return(Ok(new { success = true, message = "Your Password has been Changed!" })); } } }
public IHttpActionResult UpdateBusinessPartner([FromBody] JObject businessPartner) { using (var context = new DhoniEnterprisesEntities()) { int userID = BasicAuthHttpModule.getCurrentUserId(); if (userID != -1) { var generalDetails = businessPartner["businessPartner"]; var bpId = (long?)generalDetails["bp_ID"]; DataTable dt = new DataTable(); context.uspUpdateBusinessPartner( bpId, Convert.ToBoolean(generalDetails["bp_isSeller"]), Convert.ToBoolean(generalDetails["bp_isBroker"]), Convert.ToBoolean(generalDetails["bp_isShipper"]), Convert.ToBoolean(generalDetails["bp_isBuyer"]), Convert.ToBoolean(generalDetails["bp_onDoniContract"]), userID, Convert.ToInt32(generalDetails["bp_credibilityIndex"]), generalDetails["bp_Name"].ToString(), generalDetails["bp_website"].ToString(), generalDetails["bp_address"].ToString(), generalDetails["bp_country"].ToString()); return(Ok(new { success = true, message = "Business Partner Updated!" })); } else { return(Ok(new { success = false, message = "No User Logged In!" })); } } }
public IHttpActionResult GetProductsPricesByDateForDashboard([FromBody] JObject date) { using (var context = new DhoniEnterprisesEntities()) { int userId = BasicAuthHttpModule.getCurrentUserId(); var productPrices = context.uspGetProductPriceByDateForDashBoard(Convert.ToDateTime(date["date"]), userId); return(Ok(new { success = true, productPrices = DataTableSerializer.LINQToDataTable(productPrices) })); } }
public IHttpActionResult ProductPriceByDateRangeForDashboard(DateTime startDate, DateTime endDate) { using (var context = new DhoniEnterprisesEntities()) { int userId = BasicAuthHttpModule.getCurrentUserId(); var productsPrices = DataTableSerializer.LINQToDataTable(context.uspProductListByDateRangeForDashboard(startDate, endDate, userId)); return(Ok(new { success = true, productsPrices = productsPrices })); } }
public IHttpActionResult GetDashboardProducts() { using (var context = new DhoniEnterprisesEntities()) { int userId = BasicAuthHttpModule.getCurrentUserId(); var dashboardProducts = DataTableSerializer.LINQToDataTable(context.uspGetDashboardProducts(userId)); return(Ok(new { success = true, dashboardProducts = dashboardProducts })); } }
public IHttpActionResult ProductPriceByDateCrud([FromBody] JObject pPrice) { using (var context = new DhoniEnterprisesEntities()) { var priceDetails = pPrice["data"]; var operation = Convert.ToString(priceDetails["operation"]); var price = (Decimal?)priceDetails["price"]; var localPrice = (Decimal?)priceDetails["localPrice"]; var productId = (int?)priceDetails["productId"]; var date = (DateTime?)priceDetails["date"]; int userId = BasicAuthHttpModule.getCurrentUserId(); context.uspProductPriceByDateCRUD(operation, productId, date, price, localPrice, userId, userId); return(Ok(new { success = true, message = "Product International Price has been updated!" })); } }
public IHttpActionResult PostEditProduct([FromBody] JObject newProduct) { using (var context = new DhoniEnterprisesEntities()) { int userID = BasicAuthHttpModule.getCurrentUserId(); de_server.Models.Product product = newProduct["product"].ToObject <de_server.Models.Product>(); if (userID != -1) { var result = context.uspAddProduct(product.name, Convert.ToInt32(userID), product.specs.moisture, product.specs.weeviled, product.origin, product.specs.purity, product.specs.splits, product.quality, product.specs.damaged, product.specs.foreignMatter, product.specs.greenDamaged, product.specs.otherColor, product.specs.wrinkled); return(Ok(new { success = true, message = "New Product Added!" })); } else { return(NotFound()); } } }
public IHttpActionResult PostTransactionContractCrud([FromBody] JObject contract) { try { var tr_contract = contract["data"]; var tr_transactionID = (long?)(tr_contract["tr_transactionID"]); var tr_ownContract = Convert.ToBoolean(tr_contract["tr_ownContract"]); var tr_doniContract = Convert.ToBoolean(tr_contract["tr_doniContract"]); var userID = BasicAuthHttpModule.getCurrentUserId(); var tr_ContractualBuyer = (long?)(tr_contract["tr_ContractualBuyer"]); var operation = Convert.ToString(tr_contract["operation"]); using (var context = new DhoniEnterprisesEntities()) { context.uspTransactionContractCRUD( operation, tr_transactionID, tr_doniContract, tr_ownContract, tr_ContractualBuyer, userID, userID); if (operation == CRUD.CREATE) { return(Ok(new { success = true, message = "Transaction contract added successfully!" })); } else if (operation == CRUD.UPDATE) { return(Ok(new { success = true, message = "Transaction contract updated successfully!" })); } else if (operation == CRUD.DELETE) { return(Ok(new { success = true, message = "Transaction contract deleted successfully!" })); } else { return(Ok(new { success = false, message = "Unsupported Operation " + operation })); } } } catch (Exception ex) { return(Ok(new { success = false, message = ex.Message.ToString() })); } }
public IHttpActionResult addBusinessPartnerBankDetails([FromBody] JObject bankDetails) { var ba = bankDetails["bankDetails"]; using (var context = new DhoniEnterprisesEntities()) { int userID = BasicAuthHttpModule.getCurrentUserId(); if (userID != -1) { var res = context.uspAddBusinessPartnerBankDetails(Convert.ToInt64(ba["bp_ID"]), Convert.ToString(ba["branchAddress"]), Convert.ToString(ba["bankName"]), Convert.ToString(ba["accountTitle"]), Convert.ToString(ba["accountNumber"]), Convert.ToString(ba["accountCountry"])).FirstOrDefault(); return(Ok(new { success = true, message = "Business Partner Bank Account added!", bankId = res })); } else { return(Ok(new { success = false, message = "No User Logged In!" })); } } }
public IHttpActionResult PostTransactionStatusCrud([FromBody] JObject status) { try { var tr_status = status["data"]; var tr_transactionID = (long?)(tr_status["tr_transactionID"]); var tr_transactionStatus = Convert.ToString(tr_status["tr_transactionStatus"]); var tr_washoutValueAtPar = (int?)(tr_status["tr_washoutValueAtPar"]); var userID = BasicAuthHttpModule.getCurrentUserId(); var operation = Convert.ToString(tr_status["operation"]); using (var context = new DhoniEnterprisesEntities()) { context.uspTransactionStatusCRUD( operation, tr_transactionID, tr_transactionStatus, tr_washoutValueAtPar, userID, userID ); if (operation == CRUD.CREATE) { return(Ok(new { success = true, message = "Transaction status added successfully!" })); } else if (operation == CRUD.UPDATE) { return(Ok(new { success = true, message = "Transaction status updated successfully!" })); } else if (operation == CRUD.DELETE) { return(Ok(new { success = true, message = "Transaction status deleted successfully!" })); } else { return(Ok(new { success = false, message = "Unsupported Operation " + operation })); } } } catch (Exception ex) { return(Ok(new { success = false, message = ex.Message.ToString() })); } }
public IHttpActionResult PostTransactionNotesCrud([FromBody] JObject note) { try { var tr_note = note["data"]; var tr_transactionID = (long?)(tr_note["tr_transactionID"]); var tr_tranNoteID = (long?)(tr_note["tr_tranNoteID"]); var tr_transactionNotes = Convert.ToString(tr_note["tr_transactionNotes"]); var userID = BasicAuthHttpModule.getCurrentUserId(); var operation = Convert.ToString(tr_note["operation"]); using (var context = new DhoniEnterprisesEntities()) { var res = context.uspTransactionNotesCRUD(operation, tr_transactionID, tr_tranNoteID, tr_transactionNotes, userID); if (operation == CRUD.CREATE) { return(Ok(new { success = true, message = "Transaction Note added successfully!", noteId = res.FirstOrDefault() })); } else if (operation == CRUD.UPDATE) { return(Ok(new { success = true, message = "Transaction Note updated successfully!" })); } else if (operation == CRUD.DELETE) { return(Ok(new { success = true, message = "Transaction Note deleted successfully!" })); } else if (operation == CRUD.READ) { return(Ok(new { success = true, message = "Transaction Note read successfully!" })); } else { return(Ok(new { success = false, message = "Unsupported Operation " + operation })); } } } catch (Exception ex) { return(Ok(new { success = false, message = ex.Message.ToString() })); } }
public IHttpActionResult DashboardProductCrud([FromBody] JObject dbProduct) { using (var context = new DhoniEnterprisesEntities()) { var operation = Convert.ToString(dbProduct["operation"]); var productId = (Int32?)(dbProduct["productId"]); int userId = BasicAuthHttpModule.getCurrentUserId(); if (operation == CRUD.CREATE) { context.uspAddDashboardProduct(userId, productId); return(Ok(new { success = true, message = "Dashboard product created successfully." })); } else if (operation == CRUD.DELETE) { context.uspDeleteDashboardProduct(userId, productId); return(Ok(new { success = true, message = "Dashboard product deleted successfully." })); } return(Ok(new { success = false, message = "Invalid Operation" })); } }
public IHttpActionResult TransactionShipmentCrud([FromBody] JObject shipment) { try { using (var context = new DhoniEnterprisesEntities()) { var tr_ship = shipment["data"]; var operation = Convert.ToString(tr_ship["operation"]); var userID = BasicAuthHttpModule.getCurrentUserId(); var tr_transactionID = (long?)(tr_ship["tr_transactionID"]); var tr_ship_notShipped = Convert.ToBoolean(tr_ship["tr_ship_notShipped"]); var tr_ship_notShipped_reason = Convert.ToString(tr_ship["tr_ship_notShipped_reason"]); var tr_ship_extension = Convert.ToString(tr_ship["tr_ship_extension"]); var tr_ship_appReceived = Convert.ToBoolean(tr_ship["tr_ship_appReceived"]); var tr_expectedShipment = (DateTime?)(tr_ship["tr_expectedShipment"]); var tr_inTransit = (DateTime?)(tr_ship["tr_inTransit"]); var tr_shipped = Convert.ToBoolean(tr_ship["tr_shipped"]); var tr_dateShipped = (DateTime?)(tr_ship["tr_dateShipped"]); var tr_expectedArrival = (DateTime?)(tr_ship["tr_expectedArrival"]); var tr_transitPort = Convert.ToString(tr_ship["tr_transitPort"]); var tr_ship_arrivedAtPort = Convert.ToBoolean(tr_ship["tr_ship_arrivedAtPort"]); var tr_dateArrived = (DateTime?)(tr_ship["tr_dateArrived"]); var tr_actualArrived = (DateTime?)(tr_ship["tr_actualArrived"]); var tr_ship_BlNo = Convert.ToString(tr_ship["tr_ship_BlNo"]); var tr_ship_invoiceNo = Convert.ToString(tr_ship["tr_ship_invoiceNo"]); var tr_ship_invoiceAmt = (Decimal?)(tr_ship["tr_ship_invoiceAmt"]); var tr_ship_quantity = (Decimal?)(tr_ship["tr_ship_quantity"]); var tr_ship_vesselNo = Convert.ToString(tr_ship["tr_ship_vesselNo"]); var tr_ship_primaryShipperId = (long?)(tr_ship["tr_ship_primaryShipperId"]); var tr_ship_portLoad = Convert.ToString(tr_ship["tr_ship_portLoad"]); var tr_ship_portDest = Convert.ToString(tr_ship["tr_ship_portDest"]); var tr_ship_shipLineCont = Convert.ToString(tr_ship["tr_ship_shipLineCont"]); var tr_ship_chk_reason = Convert.ToBoolean(tr_ship["tr_ship_chk_reason"]); var tr_ship_chk_shpExt = Convert.ToBoolean(tr_ship["tr_ship_chk_shpExt"]); var tr_ship_chk_expShp = Convert.ToBoolean(tr_ship["tr_ship_chk_expShp"]); var tr_ship_chk_inTransit = Convert.ToBoolean(tr_ship["tr_ship_chk_inTransit"]); var tr_ship_chk_dateShipped = Convert.ToBoolean(tr_ship["tr_ship_chk_dateShipped"]); var tr_ship_chk_expArrival = Convert.ToBoolean(tr_ship["tr_ship_chk_expArrival"]); var tr_ship_chk_transitPort = Convert.ToBoolean(tr_ship["tr_ship_chk_transitPort"]); var tr_ship_chk_dateArrived = Convert.ToBoolean(tr_ship["tr_ship_chk_dateArrived"]); var tr_ship_chk_actualArrived = Convert.ToBoolean(tr_ship["tr_ship_chk_actualArrived"]); var res = context.uspTransactionShipmentCRUD( operation, tr_transactionID, tr_ship_notShipped, tr_ship_notShipped_reason, tr_ship_extension, tr_ship_appReceived, tr_expectedShipment, tr_inTransit, tr_shipped, tr_dateShipped, tr_expectedArrival, tr_transitPort, tr_ship_arrivedAtPort, tr_dateArrived, tr_actualArrived, tr_ship_BlNo, tr_ship_invoiceNo, tr_ship_invoiceAmt, tr_ship_quantity, tr_ship_vesselNo, tr_ship_primaryShipperId, tr_ship_portLoad, tr_ship_portDest, tr_ship_shipLineCont, userID, userID, tr_ship_chk_reason, tr_ship_chk_shpExt, tr_ship_chk_expShp, tr_ship_chk_inTransit, tr_ship_chk_dateShipped, tr_ship_chk_expArrival, tr_ship_chk_transitPort, tr_ship_chk_dateArrived, tr_ship_chk_actualArrived ); if (operation == CRUD.CREATE) { return(Ok(new { success = true, message = "Transaction shipement details added successfully!" })); } else if (operation == CRUD.DELETE) { return(Ok(new { success = true, message = "Transaction shipment deleted successfully!" })); } else if (operation == CRUD.UPDATE) { return(Ok(new { success = true, message = "Transaction shipment updated successfully!" })); } return(Ok(new { success = true, message = "Transaction Shipment Operation Executed" })); } } catch (Exception ex) { return(Ok(new { success = false, message = ex.Message.ToString() })); } }
public IHttpActionResult PostTransactionSecondaryCrud([FromBody] JObject secTransaction) { try { var tr_sec = secTransaction["data"]; var tr_transactionID = (long?)(tr_sec["tr_transactionID"]); var tr_sec_tranID = (long?)(tr_sec["tr_sec_tranID"]); var tr_sec_bpBuyerID = (long?)(tr_sec["tr_sec_bpBuyerID"]); var tr_sec_bpSellerID = (long?)(tr_sec["tr_sec_bpSellerID"]); var tr_sec_date = (DateTime?)(tr_sec["tr_sec_date"]); var tr_sec_buyerPrice = (Decimal?)(tr_sec["tr_sec_buyerPrice"]); var tr_sec_sellerPrice = (Decimal?)(tr_sec["tr_sec_sellerPrice"]); var tr_sec_otherInfo = Convert.ToString(tr_sec["tr_sec_otherInfo"]); var tr_sec_quantity = (Decimal?)(tr_sec["tr_sec_quantity"]); var userID = BasicAuthHttpModule.getCurrentUserId(); var operation = Convert.ToString(tr_sec["operation"]); if (operation == CRUD.CREATE || operation == CRUD.UPDATE) { if (tr_sec_date == null) { return(Ok(new { success = false, message = "Please Enter Transaction Date" })); } else if (tr_sec_buyerPrice == null) { return(Ok(new { success = false, message = "Please Enter Transaction price" })); } else if (tr_sec_sellerPrice == null) { return(Ok(new { success = false, message = "Please Enter Transaction price" })); } else if (tr_sec_bpBuyerID == null) { return(Ok(new { success = false, message = "Please Enter Transaction Buyer" })); } else if (tr_sec_bpSellerID == null) { return(Ok(new { success = false, message = "Please Enter Transaction Seller" })); } } using (var context = new DhoniEnterprisesEntities()) { var result = context.uspTransactionSecondaryCRUD( operation, tr_transactionID, tr_sec_bpBuyerID, tr_sec_bpSellerID, tr_sec_date, tr_sec_buyerPrice, tr_sec_sellerPrice, tr_sec_quantity, tr_sec_otherInfo, userID, userID, tr_sec_tranID ); if (operation == CRUD.CREATE) { return(Ok(new { success = true, message = "Secondary Transaction added successfully!", sec_id = result.FirstOrDefault() })); } else if (operation == CRUD.UPDATE) { return(Ok(new { success = true, message = "Secondary Transaction updated successfully!" })); } else if (operation == CRUD.DELETE) { return(Ok(new { success = true, message = "Secondary Transaction deleted successfully!" })); } else if (operation == CRUD.READ) { return(Ok(new { success = true, message = "Secondary Transaction read successfully!" })); } else { return(Ok(new { success = false, message = "Unsupported Operation " + operation })); } } } catch (Exception ex) { return(Ok(new { success = false, message = ex.Message.ToString() })); } }
public IHttpActionResult PostTransactionCommissionCrud([FromBody] JObject commission) { var tr_commission = commission["data"]; var tr_transactionID = (long?)(tr_commission["tr_transactionID"]); var tr_brokerInvolved = Convert.ToBoolean(tr_commission["tr_brokerInvolved"]); var tr_buyerBroker = Convert.ToBoolean(tr_commission["tr_buyerBroker"]); var tr_buyerBrokerID = (long?)(tr_commission["tr_buyerBrokerID"]); var tr_buyerBroker_comm_type = Convert.ToString(tr_commission["tr_buyerBroker_comm_type"]); var tr_buyerBroker_comm = (Decimal?)tr_commission["tr_buyerBroker_comm"]; var tr_sellerBroker = Convert.ToBoolean(tr_commission["tr_sellerBroker"]); var tr_sellerBrokerID = (long?)(tr_commission["tr_sellerBrokerID"]); var tr_own_Commission = (Decimal?)(tr_commission["tr_own_Commission"]); var tr_ownCommissionType = Convert.ToString(tr_commission["tr_ownCommissionType"]); var tr_difference = (Decimal?)tr_commission["tr_difference"]; var tr_discount = (Decimal?)tr_commission["tr_discount"]; var tr_netCommission = (Decimal?)tr_commission["tr_netCommission"]; var userID = BasicAuthHttpModule.getCurrentUserId(); var operation = Convert.ToString(tr_commission["operation"]); using (var context = new DhoniEnterprisesEntities()) { if (operation == CRUD.CREATE || operation == CRUD.UPDATE || operation == CRUD.DELETE) { var result = context.uspTransactionCommissionCRUD( operation , tr_transactionID , tr_brokerInvolved , tr_sellerBroker , tr_sellerBrokerID , null , null , tr_buyerBroker , tr_buyerBrokerID , tr_buyerBroker_comm_type , tr_buyerBroker_comm , tr_own_Commission , tr_ownCommissionType , tr_difference , tr_discount , tr_netCommission , userID , null , userID , null ); if (operation == CRUD.CREATE) { return(Ok(new { success = true, message = "Transaction Commission added successfully!" })); } else if (operation == CRUD.UPDATE) { return(Ok(new { success = true, message = "Transaction Commission updated successfully!" })); } else if (operation == CRUD.DELETE) { return(Ok(new { success = true, message = "Transaction Commission deleted successfully!" })); } else if (operation == CRUD.READ) { return(Ok(new { success = true, message = "Transaction Commission read successfully!" })); } else { return(Ok(new { success = false, message = "Unsupported Operation " + operation })); } } else { return(Ok(new { success = false, message = "Unsupported Operation " + operation })); } } }
public IHttpActionResult PostTransactionBasicCRUD([FromBody] JObject transaction) { var trade = transaction["data"]; var tr_transactionID = (long?)(trade["tr_transactionID"]); var tr_date = (DateTime?)(trade["tr_date"]); var tr_bpBuyerID = (long?)(trade["tr_bpBuyerID"]); var tr_bpSellerID = (long?)(trade["tr_bpSellerID"]); var tr_productID = (int?)(trade["tr_productID"]); var tr_origin = Convert.ToString(trade["tr_origin"]); var tr_quantity = (Decimal?)(trade["tr_quantity"]); var tr_price = (Decimal?)(trade["tr_price"]); var tr_packing = Convert.ToString(trade["tr_packing"]); var tr_shipment_start = (DateTime?)(trade["tr_shipment_start"]); var tr_shipment_end = (DateTime?)(trade["tr_shipment_end"]); var tr_fileID = Convert.ToString(trade["tr_fileID"]); var tr_contractID = Convert.ToString(trade["tr_contractID"]); var tr_other_info = Convert.ToString(trade["tr_other_info"]); var userID = BasicAuthHttpModule.getCurrentUserId(); var operation = Convert.ToString(trade["operation"]); if (operation == CRUD.CREATE || operation == CRUD.UPDATE) { if (tr_date == null) { return(Ok(new { success = false, message = "Please Enter Transaction Date" })); } else if (tr_price == null) { return(Ok(new { success = false, message = "Please Enter Transaction price" })); } else if (tr_bpBuyerID == null) { return(Ok(new { success = false, message = "Please Enter Transaction Buyer" })); } else if (tr_bpSellerID == null) { return(Ok(new { success = false, message = "Please Enter Transaction Seller" })); } else if (tr_productID == null) { return(Ok(new { success = false, message = "Please Enter Transaction product" })); } else if (tr_quantity == null) { return(Ok(new { success = false, message = "Please Enter Transaction product quantity in MT" })); } else if (tr_bpBuyerID == tr_bpSellerID) { return(Ok(new { success = false, message = "Buyer and Seller for a Transaction can not be same" })); } else if (tr_fileID == "") { return(Ok(new { success = false, message = "Please Enter Transaction File No." })); } else if (tr_bpBuyerID == tr_bpSellerID) { return(Ok(new { success = false, message = "Buyer and Seller can not be same." })); } } using (var context = new DhoniEnterprisesEntities()) { int file_count = (from tran in context.Transactions where tran.tr_fileID.ToLower() == tr_fileID.ToLower() select tran).Count(); int contract_count = 0; if (tr_contractID != "") { contract_count = (from tran in context.Transactions where tran.tr_contractID.ToLower() == tr_contractID.ToLower() select tran).Count(); } if (file_count > 0 && operation == CRUD.CREATE) { return(Ok(new { success = false, message = "A trasaction with the same File Id already exist in the system." })); } if (contract_count > 0 && operation == CRUD.CREATE) { return(Ok(new { success = false, message = "A trasaction with the same Contract Id already exist in the system." })); } if (operation == CRUD.CREATE || operation == CRUD.UPDATE || operation == CRUD.DELETE) { var result = context.uspTransactionBasicCRUD( operation, tr_transactionID, tr_date, tr_bpBuyerID, tr_bpSellerID, tr_productID, tr_origin, tr_quantity, tr_price, tr_packing, tr_shipment_start, tr_shipment_end, tr_fileID, tr_contractID, tr_other_info, userID, userID ); if (operation == CRUD.CREATE) { return(Ok(new { success = true, message = "Transaction added successfully!", transactionId = result.FirstOrDefault() })); } else if (operation == CRUD.UPDATE) { return(Ok(new { success = true, message = "Transaction updated successfully!" })); } else if (operation == CRUD.DELETE) { return(Ok(new { success = true, message = "Transaction deleted successfully!" })); } } if (operation == CRUD.READ) { var basic = context.uspGetTransaction(tr_transactionID); var comm = basic.GetNextResult <DataTable>(); var contract = basic.GetNextResult <DataTable>(); var sec = basic.GetNextResult <DataTable>(); var ship = basic.GetNextResult <DataTable>(); var status = basic.GetNextResult <DataTable>(); var notes = basic.GetNextResult <DataTable>(); return(Ok(new { success = true, message = "Transaction read successfully!", basic = basic, comm = comm, contract = contract, sec = sec, ship = ship, status = status, notes = notes })); } else { return(Ok(new { success = false, message = "Unsupported Operation " + operation })); } } }