public bool Post(PurchaseTaxEntity purchaseTax) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); ManageSQLConnection manageSQL = new ManageSQLConnection(); sqlParameters.Add(new KeyValuePair <string, string>("@PurchaseID", purchaseTax.PurchaseID)); sqlParameters.Add(new KeyValuePair <string, string>("@Month", purchaseTax.Month)); sqlParameters.Add(new KeyValuePair <string, string>("@Year", purchaseTax.Year)); sqlParameters.Add(new KeyValuePair <string, string>("@CompanyName", purchaseTax.CompanyName)); sqlParameters.Add(new KeyValuePair <string, string>("@AccYear", purchaseTax.AccYear)); sqlParameters.Add(new KeyValuePair <string, string>("@BillNo", purchaseTax.BillNo)); sqlParameters.Add(new KeyValuePair <string, string>("@BillDate", purchaseTax.BillDate)); sqlParameters.Add(new KeyValuePair <string, string>("@CommodityName", purchaseTax.CommodityName)); sqlParameters.Add(new KeyValuePair <string, string>("@Quantity", purchaseTax.Quantity)); sqlParameters.Add(new KeyValuePair <string, string>("@Rate", purchaseTax.Rate)); sqlParameters.Add(new KeyValuePair <string, string>("@TaxType", purchaseTax.TaxType)); sqlParameters.Add(new KeyValuePair <string, string>("@GSTType", purchaseTax.GSTType)); sqlParameters.Add(new KeyValuePair <string, string>("@Scheme", purchaseTax.Scheme)); sqlParameters.Add(new KeyValuePair <string, string>("@AADS", purchaseTax.AADS)); sqlParameters.Add(new KeyValuePair <string, string>("@Measurement", purchaseTax.Measurement)); sqlParameters.Add(new KeyValuePair <string, string>("@Hsncode", purchaseTax.Hsncode)); sqlParameters.Add(new KeyValuePair <string, string>("@Amount", purchaseTax.Amount)); sqlParameters.Add(new KeyValuePair <string, string>("@Percentage", purchaseTax.Percentage)); sqlParameters.Add(new KeyValuePair <string, string>("@CGST", purchaseTax.CGST)); sqlParameters.Add(new KeyValuePair <string, string>("@SGST", purchaseTax.SGST)); sqlParameters.Add(new KeyValuePair <string, string>("@IGST", purchaseTax.IGST)); sqlParameters.Add(new KeyValuePair <string, string>("@VatAmount", purchaseTax.VatAmount)); sqlParameters.Add(new KeyValuePair <string, string>("@Total", purchaseTax.Total)); sqlParameters.Add(new KeyValuePair <string, string>("@CreatedBy", purchaseTax.CreatedBy)); sqlParameters.Add(new KeyValuePair <string, string>("@CreatedDate", purchaseTax.CreatedDate.ToString("MM/dd/yyyy"))); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", purchaseTax.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", purchaseTax.RCode)); return(manageSQL.InsertData("InsertPurchaseTaxEntry", sqlParameters)); }
public Tuple <bool, string> Post(UesrProfileEntity entity) { try { ManageSQLConnection manageSQL = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@UserId", entity.UserId)); sqlParameters.Add(new KeyValuePair <string, string>("@LocationURL", entity.LocationURL)); sqlParameters.Add(new KeyValuePair <string, string>("@Dcode", entity.Dcode)); sqlParameters.Add(new KeyValuePair <string, string>("@Rcode", entity.Rcode)); sqlParameters.Add(new KeyValuePair <string, string>("@Name", entity.Name)); sqlParameters.Add(new KeyValuePair <string, string>("@Address", entity.Address)); sqlParameters.Add(new KeyValuePair <string, string>("@MailId", entity.MailId)); sqlParameters.Add(new KeyValuePair <string, string>("@Phone", entity.Phone)); sqlParameters.Add(new KeyValuePair <string, string>("@FileName", entity.FileName)); sqlParameters.Add(new KeyValuePair <string, string>("@RMName", entity.RMName)); sqlParameters.Add(new KeyValuePair <string, string>("@RMPhone", entity.RMPhone)); sqlParameters.Add(new KeyValuePair <string, string>("@RMDistrict", entity.RMDistrict)); sqlParameters.Add(new KeyValuePair <string, string>("@RMEmailId", entity.RMEmailId)); var result = manageSQL.InsertData("InsertUserProfile", sqlParameters); return(new Tuple <bool, string>(result, "Saved Successfully")); } catch (Exception ex) { return(new Tuple <bool, string>(false, "Please Contact Administrator")); } }
public bool Post(GodownEntity godownEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > parameterList = new List <KeyValuePair <string, string> >(); try { parameterList.Add(new KeyValuePair <string, string>("@TNCSCode", godownEntity.TNCSCode)); parameterList.Add(new KeyValuePair <string, string>("@TNCSName", godownEntity.TNCSName)); parameterList.Add(new KeyValuePair <string, string>("@TNCSRegn", godownEntity.TNCSRegn)); parameterList.Add(new KeyValuePair <string, string>("@TNCSType", godownEntity.TNCSType)); parameterList.Add(new KeyValuePair <string, string>("@TNCSCarpet", godownEntity.TNCSCarpet)); parameterList.Add(new KeyValuePair <string, string>("@TNCSCapacity", godownEntity.TNCSCapacity)); parameterList.Add(new KeyValuePair <string, string>("@DeleteFlag", godownEntity.DeleteFlag)); parameterList.Add(new KeyValuePair <string, string>("@ActiveFlag", godownEntity.ActiveFlag)); parameterList.Add(new KeyValuePair <string, string>("@SessionFlag", godownEntity.SessionFlag)); parameterList.Add(new KeyValuePair <string, string>("@ExportFlag", godownEntity.ExportFlag)); parameterList.Add(new KeyValuePair <string, string>("@OPERATIONTYPE", godownEntity.OPERATIONTYPE)); parameterList.Add(new KeyValuePair <string, string>("@NOOFSHOPCRS", Convert.ToString(godownEntity.NOOFSHOPCRS))); parameterList.Add(new KeyValuePair <string, string>("@DocStatus", Convert.ToString(godownEntity.DocStatus))); parameterList.Add(new KeyValuePair <string, string>("@CBStatement", Convert.ToString(godownEntity.CBStatement))); parameterList.Add(new KeyValuePair <string, string>("@Allotment", Convert.ToString(godownEntity.Allotment))); return(manageSQLConnection.InsertData("InsertGodownMaster", parameterList)); } finally { parameterList = null; } }
public Tuple <bool, string> Post([FromBody] List <TransferOBToHOQtyEntity> entity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); try { foreach (var item in entity) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", item.RegionCode)); sqlParameters.Add(new KeyValuePair <string, string>("@QtyMonth", item.QTYMONTH)); sqlParameters.Add(new KeyValuePair <string, string>("@QtyYear", item.QTYYEAR)); sqlParameters.Add(new KeyValuePair <string, string>("@ITCode", item.CommodityCode)); sqlParameters.Add(new KeyValuePair <string, string>("@Location", item.Location)); sqlParameters.Add(new KeyValuePair <string, string>("@OB", item.OB)); sqlParameters.Add(new KeyValuePair <string, string>("@PB", item.PB)); sqlParameters.Add(new KeyValuePair <string, string>("@CS", item.CS)); manageSQLConnection.InsertData("InsertOBIntoHOQtyAbstract", sqlParameters); } return(new Tuple <bool, string> (true, GlobalVariable.SavedMessage)); } catch (Exception ex) { AuditLog.WriteError("Allotment" + ex.Message + " : " + ex.StackTrace); return(new Tuple <bool, string>(false, GlobalVariable.ErrorMessage)); } }
public bool Post(HoqtAbstract hoqtyabstract) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); ManageSQLConnection manageSQL = new ManageSQLConnection(); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", hoqtyabstract.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@QtyMonth", hoqtyabstract.qtyMonth)); sqlParameters.Add(new KeyValuePair <string, string>("@QtyYear", hoqtyabstract.qtyYear)); sqlParameters.Add(new KeyValuePair <string, string>("@ITCode", hoqtyabstract.ITCode)); sqlParameters.Add(new KeyValuePair <string, string>("@Trcode", hoqtyabstract.Trcode)); sqlParameters.Add(new KeyValuePair <string, string>("@OB", hoqtyabstract.OB)); sqlParameters.Add(new KeyValuePair <string, string>("@PurchaseReceipt", hoqtyabstract.PurchaseReceipt)); sqlParameters.Add(new KeyValuePair <string, string>("@FreeRice", hoqtyabstract.FreeRice)); sqlParameters.Add(new KeyValuePair <string, string>("@OtherReceipt", hoqtyabstract.OtherReceipt)); sqlParameters.Add(new KeyValuePair <string, string>("@TotalReceipt", hoqtyabstract.TotalReceipt)); sqlParameters.Add(new KeyValuePair <string, string>("@Issueonsales", hoqtyabstract.Issueonsales)); sqlParameters.Add(new KeyValuePair <string, string>("@Freeissue", hoqtyabstract.Freeissue)); sqlParameters.Add(new KeyValuePair <string, string>("@Otherissue", hoqtyabstract.Otherissue)); sqlParameters.Add(new KeyValuePair <string, string>("@TotalIssues", hoqtyabstract.TotalIssues)); sqlParameters.Add(new KeyValuePair <string, string>("@CB", hoqtyabstract.CB)); sqlParameters.Add(new KeyValuePair <string, string>("@CS", hoqtyabstract.CS)); sqlParameters.Add(new KeyValuePair <string, string>("@ActualBalance", hoqtyabstract.ActualBalance)); sqlParameters.Add(new KeyValuePair <string, string>("@HOQtyId", hoqtyabstract.HOQtyId)); return(manageSQL.InsertData("InsertHOqtyabstract", sqlParameters)); }
public bool Post(ServiceProviderEntity serviceProvider) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); ManageSQLConnection manageSQL = new ManageSQLConnection(); sqlParameters.Add(new KeyValuePair <string, string>("@ServiceID", serviceProvider.ServiceID)); sqlParameters.Add(new KeyValuePair <string, string>("@Month", serviceProvider.Month)); sqlParameters.Add(new KeyValuePair <string, string>("@Year", serviceProvider.Year)); sqlParameters.Add(new KeyValuePair <string, string>("@CompanyName", serviceProvider.CompanyName)); sqlParameters.Add(new KeyValuePair <string, string>("@TIN", serviceProvider.TIN)); sqlParameters.Add(new KeyValuePair <string, string>("@AccYear", serviceProvider.AccYear)); sqlParameters.Add(new KeyValuePair <string, string>("@BillNo", serviceProvider.BillNo)); sqlParameters.Add(new KeyValuePair <string, string>("@BillDate", serviceProvider.BillDate)); sqlParameters.Add(new KeyValuePair <string, string>("@CommodityName", serviceProvider.CommodityName)); sqlParameters.Add(new KeyValuePair <string, string>("@TaxType", serviceProvider.TaxType)); sqlParameters.Add(new KeyValuePair <string, string>("@SGST", serviceProvider.SGST)); sqlParameters.Add(new KeyValuePair <string, string>("@CGST", serviceProvider.CGST)); sqlParameters.Add(new KeyValuePair <string, string>("@IGST", serviceProvider.IGST)); sqlParameters.Add(new KeyValuePair <string, string>("@Amount", serviceProvider.Amount)); sqlParameters.Add(new KeyValuePair <string, string>("@TaxPercentage", serviceProvider.TaxPercentage)); sqlParameters.Add(new KeyValuePair <string, string>("@TaxAmount", serviceProvider.TaxAmount)); sqlParameters.Add(new KeyValuePair <string, string>("@Total", serviceProvider.Total)); sqlParameters.Add(new KeyValuePair <string, string>("@CreatedBy", serviceProvider.CreatedBy)); sqlParameters.Add(new KeyValuePair <string, string>("@CreatedDate", serviceProvider.CreatedDate.ToString("MM/dd/yyyy"))); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", serviceProvider.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", serviceProvider.RCode)); return(manageSQL.InsertData("InsertServiceProviderEntry", sqlParameters)); }
public Tuple <bool, string> Post(DocumentStockReceiptList stockReceipt = null) { //Check valid user details. ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); ManageReport manage = new ManageReport(); List <KeyValuePair <string, string> > sqlParameters1 = new List <KeyValuePair <string, string> >(); sqlParameters1.Add(new KeyValuePair <string, string>("@UserName", stockReceipt.UserID)); DataSet ds = new DataSet(); ds = manageSQLConnection.GetDataSetValues("GetDocumentDownloadUser", sqlParameters1); if (manage.CheckDataAvailable(ds)) { ManagePDFGeneration managePDF = new ManagePDFGeneration(); var result = managePDF.GeneratePDF(stockReceipt); if (result.Item1) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@Doc", stockReceipt.SRNo)); sqlParameters.Add(new KeyValuePair <string, string>("@Status", "1")); manageSQLConnection.UpdateValues("UpdateSRDetailStatus", sqlParameters); List <KeyValuePair <string, string> > InsertParameter = new List <KeyValuePair <string, string> >(); InsertParameter.Add(new KeyValuePair <string, string>("@GCode", stockReceipt.ReceivingCode)); InsertParameter.Add(new KeyValuePair <string, string>("@RCode", stockReceipt.RCode)); InsertParameter.Add(new KeyValuePair <string, string>("@DocNumber", stockReceipt.SRNo)); InsertParameter.Add(new KeyValuePair <string, string>("@UserName", stockReceipt.UserID)); InsertParameter.Add(new KeyValuePair <string, string>("@DocType", "1")); manageSQLConnection.InsertData("InsertDocumentDownloadLog", InsertParameter); } return(result); } else { List <KeyValuePair <string, string> > InsertParameter = new List <KeyValuePair <string, string> >(); InsertParameter.Add(new KeyValuePair <string, string>("@GCode", stockReceipt.ReceivingCode)); InsertParameter.Add(new KeyValuePair <string, string>("@RCode", stockReceipt.RCode)); InsertParameter.Add(new KeyValuePair <string, string>("@DocNumber", stockReceipt.SRNo)); InsertParameter.Add(new KeyValuePair <string, string>("@UserName", stockReceipt.UserID)); InsertParameter.Add(new KeyValuePair <string, string>("@DocType", "2")); manageSQLConnection.InsertData("InsertDocumentDownloadLog", InsertParameter); // return(new Tuple <bool, string>(false, "Please contact HO")); } }
public bool Post(AllotmentCommodityEntity allotmentCommodity) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); ManageSQLConnection manageSQL = new ManageSQLConnection(); sqlParameters.Add(new KeyValuePair <string, string>("@ACode", allotmentCommodity.ACode)); sqlParameters.Add(new KeyValuePair <string, string>("@AName", allotmentCommodity.AName)); sqlParameters.Add(new KeyValuePair <string, string>("@AllotmentCommodity", allotmentCommodity.AllotmentCommodity)); sqlParameters.Add(new KeyValuePair <string, string>("@AllotmentScheme", allotmentCommodity.AllotmentScheme)); return(manageSQL.InsertData("InsertAllotmentCommodity", sqlParameters)); }
public Tuple <bool, string> Post(IssuerGSTEntity issuerGSTEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", issuerGSTEntity.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@GSTNumber", issuerGSTEntity.GSTNumber)); sqlParameters.Add(new KeyValuePair <string, string>("@IssuerCode", issuerGSTEntity.IssuerCode)); manageSQLConnection.InsertData("UpdateGSTInIssuerMaster", sqlParameters); return(new Tuple <bool, string>(true, "Updated Successfully!")); }
public bool Post(CommodityEntity commodityEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > parameterList = new List <KeyValuePair <string, string> >(); try { if (commodityEntity.Type == 1) { parameterList.Add(new KeyValuePair <string, string>("@ITCode", commodityEntity.ITCode)); parameterList.Add(new KeyValuePair <string, string>("@ITDescription", commodityEntity.ITDescription)); parameterList.Add(new KeyValuePair <string, string>("@ItemType", commodityEntity.ItemType)); return(manageSQLConnection.InsertData("InsertItemMasterCereal", parameterList)); } else { parameterList.Add(new KeyValuePair <string, string>("@ITCode", commodityEntity.ITCode)); parameterList.Add(new KeyValuePair <string, string>("@ITDescription", commodityEntity.ITDescription)); parameterList.Add(new KeyValuePair <string, string>("@ITBweighment", commodityEntity.ITBweighment)); parameterList.Add(new KeyValuePair <string, string>("@ittax", commodityEntity.ittax)); parameterList.Add(new KeyValuePair <string, string>("@GRName", commodityEntity.GRName)); parameterList.Add(new KeyValuePair <string, string>("@ItemType", commodityEntity.ItemType)); parameterList.Add(new KeyValuePair <string, string>("@Hsncode", commodityEntity.Hsncode)); parameterList.Add(new KeyValuePair <string, string>("@DeleteFlag", commodityEntity.DeleteFlag)); parameterList.Add(new KeyValuePair <string, string>("@Activeflag", commodityEntity.ActiveFlag)); parameterList.Add(new KeyValuePair <string, string>("@Allotmentgroup", commodityEntity.Allotmentgroup)); parameterList.Add(new KeyValuePair <string, string>("@SFlag", Convert.ToString(commodityEntity.SFlag))); parameterList.Add(new KeyValuePair <string, string>("@CBFlag", Convert.ToString(commodityEntity.CBFlag))); parameterList.Add(new KeyValuePair <string, string>("@Unit", Convert.ToString(commodityEntity.Unit))); parameterList.Add(new KeyValuePair <string, string>("@Group", Convert.ToString(commodityEntity.Group))); return(manageSQLConnection.InsertData("InsertItemMaster", parameterList)); } //return manageSQLConnection.InsertData("InsertItemMaster", parameterList); } finally { parameterList = null; } }
public bool Post(QuantityAccountEntity QuantityMaster) { //ManageEmployeeDetailsSQL manageEmployee = new ManageEmployeeDetailsSQL(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); ManageSQLConnection manageSQL = new ManageSQLConnection(); sqlParameters.Add(new KeyValuePair <string, string>("@SlNo", QuantityMaster.SlNo)); sqlParameters.Add(new KeyValuePair <string, string>("@ScCode", QuantityMaster.SCCode)); sqlParameters.Add(new KeyValuePair <string, string>("@TRCode", QuantityMaster.TRCode)); sqlParameters.Add(new KeyValuePair <string, string>("@Activeflag", QuantityMaster.Activeflag)); sqlParameters.Add(new KeyValuePair <string, string>("@RType", QuantityMaster.ReportType)); return(manageSQL.InsertData("InsertQuantityDetails", sqlParameters)); }
public bool Post(NotificationPopupEntity notification) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); ManageSQLConnection manageSQL = new ManageSQLConnection(); if (notification.Type == 1) { sqlParameters.Add(new KeyValuePair <string, string>("@ID", notification.ID)); sqlParameters.Add(new KeyValuePair <string, string>("@Notes", notification.Notes)); sqlParameters.Add(new KeyValuePair <string, string>("@Reason", notification.Reason)); sqlParameters.Add(new KeyValuePair <string, string>("@isActive", notification.isActive)); sqlParameters.Add(new KeyValuePair <string, string>("@ImageName", notification.ImageName)); return(manageSQL.InsertData("InsertNotificationPopup", sqlParameters)); } else { sqlParameters.Add(new KeyValuePair <string, string>("@ID", notification.ID)); sqlParameters.Add(new KeyValuePair <string, string>("@Notes", notification.Notes)); sqlParameters.Add(new KeyValuePair <string, string>("@Reason", notification.Reason)); sqlParameters.Add(new KeyValuePair <string, string>("@isActive", notification.isActive)); return(manageSQL.InsertData("InsertNotification", sqlParameters)); } }
public bool Post(SocietyMasterNewEntity societyMasterNewEntry) { //ManageEmployeeDetailsSQL manageEmployee = new ManageEmployeeDetailsSQL(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); ManageSQLConnection manageSQL = new ManageSQLConnection(); sqlParameters.Add(new KeyValuePair <string, string>("@SlNo", societyMasterNewEntry.SlNo)); sqlParameters.Add(new KeyValuePair <string, string>("@soccode", societyMasterNewEntry.SocietyCode)); sqlParameters.Add(new KeyValuePair <string, string>("@socname", societyMasterNewEntry.SocietyName)); sqlParameters.Add(new KeyValuePair <string, string>("@soctype", societyMasterNewEntry.SocietyType)); sqlParameters.Add(new KeyValuePair <string, string>("@godowncode", societyMasterNewEntry.gowdoncode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", societyMasterNewEntry.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@eflag", societyMasterNewEntry.eflag)); return(manageSQL.InsertData("Insertsocietymasterentry", sqlParameters)); }
public bool Post(StackMasterEntity stackMasterEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > parameterList = new List <KeyValuePair <string, string> >(); try { parameterList.Add(new KeyValuePair <string, string>("@RowId", stackMasterEntity.RowId)); parameterList.Add(new KeyValuePair <string, string>("@Flag", stackMasterEntity.Flag)); return(manageSQLConnection.InsertData("UpdateStackCardMaster", parameterList)); } finally { parameterList = null; } }
public bool Post(RegionMasterEntity MasterEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > parameterList = new List <KeyValuePair <string, string> >(); try { parameterList.Add(new KeyValuePair <string, string>("@RGCODE", MasterEntity.RGCODE)); parameterList.Add(new KeyValuePair <string, string>("@RGNAME", MasterEntity.RGNAME)); parameterList.Add(new KeyValuePair <string, string>("@SessionFlag", MasterEntity.SessionFlag)); return(manageSQLConnection.InsertData("InsertRegionMaster", parameterList)); } finally { parameterList = null; } }
public bool Post(VehicleMasterEntity masterEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > parameterList = new List <KeyValuePair <string, string> >(); try { parameterList.Add(new KeyValuePair <string, string>("@Activeflag", masterEntity.Activeflag)); parameterList.Add(new KeyValuePair <string, string>("@DeleteFlag", masterEntity.DeleteFlag)); parameterList.Add(new KeyValuePair <string, string>("@VHType", masterEntity.VHType)); parameterList.Add(new KeyValuePair <string, string>("@VHCode", masterEntity.VHCode)); return(manageSQLConnection.InsertData("InsertVehicleMaster", parameterList)); } finally { parameterList = null; } }
public bool Post(IssuerEntity issuerEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@IssuerNo", issuerEntity.IssuerNo)); sqlParameters.Add(new KeyValuePair <string, string>("@Issuername", issuerEntity.IssuerName)); sqlParameters.Add(new KeyValuePair <string, string>("@SocietyCode", issuerEntity.SocietyCode)); sqlParameters.Add(new KeyValuePair <string, string>("@IssuerCode", issuerEntity.IssuerCode)); sqlParameters.Add(new KeyValuePair <string, string>("@CategoryId", issuerEntity.CategoryId)); sqlParameters.Add(new KeyValuePair <string, string>("@Tycode", issuerEntity.Tycode)); sqlParameters.Add(new KeyValuePair <string, string>("@Beneficiaries", issuerEntity.NoOfBeneficiaries)); sqlParameters.Add(new KeyValuePair <string, string>("@Activeflag", issuerEntity.Activeflag)); sqlParameters.Add(new KeyValuePair <string, string>("@ACSCode", issuerEntity.ACSCode)); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", issuerEntity.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", issuerEntity.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@GSTNo", issuerEntity.GSTNumber)); return(manageSQLConnection.InsertData("InsertIssuerMaster", sqlParameters)); }
public bool Post(TransactionMasterEntity typeMasterEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > parameterList = new List <KeyValuePair <string, string> >(); try { parameterList.Add(new KeyValuePair <string, string>("@TRCode", typeMasterEntity.TRCode)); parameterList.Add(new KeyValuePair <string, string>("@TRName", typeMasterEntity.TRName)); parameterList.Add(new KeyValuePair <string, string>("@DeleteFlag", typeMasterEntity.DeleteFlag)); parameterList.Add(new KeyValuePair <string, string>("@Activeflag", typeMasterEntity.Activeflag)); parameterList.Add(new KeyValuePair <string, string>("@TransType", typeMasterEntity.TransType)); return(manageSQLConnection.InsertData("InsertTransactionMaster", parameterList)); } finally { parameterList = null; } }
public bool Post(TransactionStatusEntity transactionStatus) { DataSet ds = new DataSet(); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > listParameters = new List <KeyValuePair <string, string> >(); listParameters.Add(new KeyValuePair <string, string>("@srno", transactionStatus.Srno.ToString())); listParameters.Add(new KeyValuePair <string, string>("@gCode", transactionStatus.Gcode)); listParameters.Add(new KeyValuePair <string, string>("@docdate", transactionStatus.Docdate.ToString("MM/dd/yyyy"))); listParameters.Add(new KeyValuePair <string, string>("@receipt", transactionStatus.Receipt.ToString().ToLower() == "false" ? "0" : "1")); listParameters.Add(new KeyValuePair <string, string>("@issues", transactionStatus.Issues.ToString().ToLower() == "false" ? "0" : "1")); listParameters.Add(new KeyValuePair <string, string>("@transfer", transactionStatus.Transfer.ToString().ToLower() == "false" ? "0" : "1")); listParameters.Add(new KeyValuePair <string, string>("@Cb", transactionStatus.CB.ToString().ToLower() == "false" ? "0" : "1")); listParameters.Add(new KeyValuePair <string, string>("@Remarks", transactionStatus.remarks)); listParameters.Add(new KeyValuePair <string, string>("@Flag1", "1")); listParameters.Add(new KeyValuePair <string, string>("@userid", transactionStatus.userid)); listParameters.Add(new KeyValuePair <string, string>("@RoleId", Convert.ToString(transactionStatus.RoleId))); return(manageSQLConnection.InsertData("InsertTransactionstatus", listParameters)); }
public bool Post(RateMasterEntity RateMaster) { //ManageEmployeeDetailsSQL manageEmployee = new ManageEmployeeDetailsSQL(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); ManageSQLConnection manageSQL = new ManageSQLConnection(); sqlParameters.Add(new KeyValuePair <string, string>("@RowID", RateMaster.RowID)); sqlParameters.Add(new KeyValuePair <string, string>("@ScCode", RateMaster.ScCode)); sqlParameters.Add(new KeyValuePair <string, string>("@Allotment", RateMaster.Allotment)); sqlParameters.Add(new KeyValuePair <string, string>("@Rate", RateMaster.Rate)); sqlParameters.Add(new KeyValuePair <string, string>("@EffectDate", RateMaster.EffectDate)); sqlParameters.Add(new KeyValuePair <string, string>("@EndDate", RateMaster.EndDate)); sqlParameters.Add(new KeyValuePair <string, string>("@CreatedDate", RateMaster.CreatedDate)); sqlParameters.Add(new KeyValuePair <string, string>("@Remark", RateMaster.Remark)); sqlParameters.Add(new KeyValuePair <string, string>("@Activeflag", RateMaster.Activeflag)); sqlParameters.Add(new KeyValuePair <string, string>("@TaxPercentage", RateMaster.TaxPercentage)); sqlParameters.Add(new KeyValuePair <string, string>("@Hsncode", RateMaster.Hsncode)); return(manageSQL.InsertData("InsertRateMaster", sqlParameters)); }
public bool Post(SchemesCommodityEntity masterEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > parameterList = new List <KeyValuePair <string, string> >(); try { parameterList.Add(new KeyValuePair <string, string>("@ActiveFlag", masterEntity.ActiveFlag)); parameterList.Add(new KeyValuePair <string, string>("@DeleteFlag", masterEntity.DeleteFlag)); parameterList.Add(new KeyValuePair <string, string>("@SCCode", masterEntity.SCCode)); parameterList.Add(new KeyValuePair <string, string>("@CCode", masterEntity.CCode)); parameterList.Add(new KeyValuePair <string, string>("@RowId", masterEntity.RowId)); return(manageSQLConnection.InsertData("InsertSchemeCommodity", parameterList)); } finally { parameterList = null; } }
public Tuple <bool, string> Post(DocCorrectionEntity docCorrectionEntity = null) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); if (docCorrectionEntity.Type == 1) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@DocNumber", docCorrectionEntity.DocNo)); sqlParameters.Add(new KeyValuePair <string, string>("@RoleId", docCorrectionEntity.RoleId.ToString())); sqlParameters.Add(new KeyValuePair <string, string>("@DocType", docCorrectionEntity.DocType.ToString())); sqlParameters.Add(new KeyValuePair <string, string>("@RegionCode", docCorrectionEntity.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", docCorrectionEntity.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@Reason", docCorrectionEntity.Reason)); var result = manageSQLConnection.InsertData("InsertDocumentCorrection", sqlParameters); if (result) { return(new Tuple <bool, string>(true, "Request sent!")); } else { return(new Tuple <bool, string>(false, "Please contact Administrator")); } } else { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@Id", docCorrectionEntity.Id.ToString())); sqlParameters.Add(new KeyValuePair <string, string>("@ApproverRoleID", docCorrectionEntity.ApproverRoleID.ToString())); sqlParameters.Add(new KeyValuePair <string, string>("@ApproverReason", docCorrectionEntity.ApproverReason.ToString())); sqlParameters.Add(new KeyValuePair <string, string>("@ApprovalStatus", docCorrectionEntity.ApprovalStatus.ToString())); var result = manageSQLConnection.UpdateValues("UpdateDocumentCorrection", sqlParameters); if (result) { return(new Tuple <bool, string>(true, docCorrectionEntity.ApprovalStatus == 1 ? "Approved!" : "Rejected!")); } else { return(new Tuple <bool, string>(false, "Please contact Administrator")); } } // return new Tuple<bool, string>(false, "Please contact Administrator"); }
public bool Post(EmployeeDetailsEntity employeeDetails) { //ManageEmployeeDetailsSQL manageEmployee = new ManageEmployeeDetailsSQL(); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); ManageSQLConnection manageSQL = new ManageSQLConnection(); //sqlParameters.Add(new KeyValuePair<string, string>("@RowID", employeeDetails.RowID)); sqlParameters.Add(new KeyValuePair <string, string>("@ecode", employeeDetails.Empno)); sqlParameters.Add(new KeyValuePair <string, string>("@empname", employeeDetails.Empname)); sqlParameters.Add(new KeyValuePair <string, string>("@designation", employeeDetails.Designation)); sqlParameters.Add(new KeyValuePair <string, string>("@refno", employeeDetails.Refno)); sqlParameters.Add(new KeyValuePair <string, string>("@refdate", employeeDetails.Refdate)); sqlParameters.Add(new KeyValuePair <string, string>("@jdate", employeeDetails.Jrdate)); //sqlParameters.Add(new KeyValuePair<string, string>("@rdate", employeeDetails.Rdate)); sqlParameters.Add(new KeyValuePair <string, string>("@jrtype", employeeDetails.Jrtype)); sqlParameters.Add(new KeyValuePair <string, string>("@rcode", employeeDetails.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@gcode", employeeDetails.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@ExportFlag", employeeDetails.ExportFlag)); return(manageSQL.InsertData("InsertEmployeeDetails", sqlParameters)); }
public bool Post(PackingMasterEntity masterEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > parameterList = new List <KeyValuePair <string, string> >(); try { parameterList.Add(new KeyValuePair <string, string>("@Pcode", masterEntity.Pcode)); parameterList.Add(new KeyValuePair <string, string>("@PName", masterEntity.PName)); parameterList.Add(new KeyValuePair <string, string>("@PWeight", Convert.ToString(masterEntity.PWeight))); parameterList.Add(new KeyValuePair <string, string>("@PBWeight", masterEntity.PBWeight)); parameterList.Add(new KeyValuePair <string, string>("@DeleteFlag", masterEntity.DeleteFlag)); parameterList.Add(new KeyValuePair <string, string>("@Activeflag", masterEntity.Activeflag)); return(manageSQLConnection.InsertData("InsertPackingMaster", parameterList)); } finally { parameterList = null; } }
public bool Post(SchemesMasterEntity masterEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > parameterList = new List <KeyValuePair <string, string> >(); try { parameterList.Add(new KeyValuePair <string, string>("@SCCode", masterEntity.SCCode)); parameterList.Add(new KeyValuePair <string, string>("@SCName", masterEntity.SCName)); parameterList.Add(new KeyValuePair <string, string>("@SCType", masterEntity.SCType)); parameterList.Add(new KeyValuePair <string, string>("@DeleteFlag", masterEntity.DeleteFlag)); parameterList.Add(new KeyValuePair <string, string>("@Activeflag", masterEntity.Activeflag)); parameterList.Add(new KeyValuePair <string, string>("@AnnavitranTNCSCID", masterEntity.AnnavitranTNCSCID)); parameterList.Add(new KeyValuePair <string, string>("@AllotmentScheme", masterEntity.AllotmentScheme)); return(manageSQLConnection.InsertData("InsertSchemesMaster", parameterList)); } finally { parameterList = null; } }
public bool Post(MenuMasterEntity MasterEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > parameterList = new List <KeyValuePair <string, string> >(); try { parameterList.Add(new KeyValuePair <string, string>("@MenuId", Convert.ToString(MasterEntity.MenuId))); parameterList.Add(new KeyValuePair <string, string>("@Name", MasterEntity.MenuName)); parameterList.Add(new KeyValuePair <string, string>("@ID", Convert.ToString(MasterEntity.ID))); parameterList.Add(new KeyValuePair <string, string>("@URL", MasterEntity.URL)); parameterList.Add(new KeyValuePair <string, string>("@ParentId", Convert.ToString(MasterEntity.ParentId))); parameterList.Add(new KeyValuePair <string, string>("@IsActive", Convert.ToString(MasterEntity.Active))); parameterList.Add(new KeyValuePair <string, string>("@RoleId", Convert.ToString(MasterEntity.RoleId))); return(manageSQLConnection.InsertData("InsertMenuMaster", parameterList)); } finally { parameterList = null; } }
public bool Post(PartyLedgerEntryEntity partyLedger) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); ManageSQLConnection manageSQL = new ManageSQLConnection(); if (partyLedger.Type == 1) { sqlParameters.Add(new KeyValuePair <string, string>("@LedgerID", partyLedger.LedgerID)); sqlParameters.Add(new KeyValuePair <string, string>("@PCode", partyLedger.PCode)); sqlParameters.Add(new KeyValuePair <string, string>("@PartyName", partyLedger.PartyName)); sqlParameters.Add(new KeyValuePair <string, string>("@TIN", partyLedger.Tin)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", partyLedger.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@AADSType", partyLedger.AADSType)); sqlParameters.Add(new KeyValuePair <string, string>("@Flag", partyLedger.Flag)); } else { sqlParameters.Add(new KeyValuePair <string, string>("@LedgerID", partyLedger.LedgerID)); sqlParameters.Add(new KeyValuePair <string, string>("@PCode", partyLedger.PCode)); sqlParameters.Add(new KeyValuePair <string, string>("@Pan", partyLedger.Pan)); sqlParameters.Add(new KeyValuePair <string, string>("@PartyName", partyLedger.PartyName)); sqlParameters.Add(new KeyValuePair <string, string>("@TIN", partyLedger.Tin)); sqlParameters.Add(new KeyValuePair <string, string>("@StateCode", partyLedger.StateCode)); sqlParameters.Add(new KeyValuePair <string, string>("@GSTNo", partyLedger.GST)); sqlParameters.Add(new KeyValuePair <string, string>("@Account", partyLedger.Account)); sqlParameters.Add(new KeyValuePair <string, string>("@Bank", partyLedger.Bank)); sqlParameters.Add(new KeyValuePair <string, string>("@Branch", partyLedger.Branch)); sqlParameters.Add(new KeyValuePair <string, string>("@IFSC", partyLedger.IFSC)); sqlParameters.Add(new KeyValuePair <string, string>("@Favour", partyLedger.Favour)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", partyLedger.RCode)); sqlParameters.Add(new KeyValuePair <string, string>("@AADSType", partyLedger.AADSType)); sqlParameters.Add(new KeyValuePair <string, string>("@Pincode", partyLedger.Pincode)); sqlParameters.Add(new KeyValuePair <string, string>("@Address1", partyLedger.Address1)); sqlParameters.Add(new KeyValuePair <string, string>("@Address2", partyLedger.Address2)); sqlParameters.Add(new KeyValuePair <string, string>("@Flag", partyLedger.Flag)); } return(manageSQL.InsertData("InsertPartyLedgerdetails", sqlParameters)); }
public bool Post(DepositorEntity depositorEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > parameterList = new List <KeyValuePair <string, string> >(); try { parameterList.Add(new KeyValuePair <string, string>("@DepositorCode", depositorEntity.DepositorCode)); parameterList.Add(new KeyValuePair <string, string>("@DepositorName", depositorEntity.DepositorName)); parameterList.Add(new KeyValuePair <string, string>("@DepositorType", depositorEntity.DepositorType)); parameterList.Add(new KeyValuePair <string, string>("@RCODE", depositorEntity.RCode)); parameterList.Add(new KeyValuePair <string, string>("@GODOWNCODE", depositorEntity.GCode)); parameterList.Add(new KeyValuePair <string, string>("@DeleteFlag", depositorEntity.DeleteFlag)); parameterList.Add(new KeyValuePair <string, string>("@ActiveFlag", depositorEntity.ActiveFlag)); parameterList.Add(new KeyValuePair <string, string>("@LedgerId", depositorEntity.LedgerId)); parameterList.Add(new KeyValuePair <string, string>("@Gst", depositorEntity.GstNo)); return(manageSQLConnection.InsertData("InsertDepositorsMaster", parameterList)); } finally { parameterList = null; } }
public bool Post(UserMasterEntity MasterEntity) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); List <KeyValuePair <string, string> > parameterList = new List <KeyValuePair <string, string> >(); try { parameterList.Add(new KeyValuePair <string, string>("@UserName", MasterEntity.UserName)); parameterList.Add(new KeyValuePair <string, string>("@Pwd", MasterEntity.Pwd)); parameterList.Add(new KeyValuePair <string, string>("@EMailId", MasterEntity.EMailId)); parameterList.Add(new KeyValuePair <string, string>("@EmpId", MasterEntity.EmpId)); parameterList.Add(new KeyValuePair <string, string>("@PhoneNumber", MasterEntity.PhoneNumber)); parameterList.Add(new KeyValuePair <string, string>("@RoleId", Convert.ToString(MasterEntity.RoleId))); parameterList.Add(new KeyValuePair <string, string>("@Flag", Convert.ToString(MasterEntity.Flag))); parameterList.Add(new KeyValuePair <string, string>("@GodownCode", MasterEntity.GodownCode)); parameterList.Add(new KeyValuePair <string, string>("@Regioncode", MasterEntity.Regioncode)); return(manageSQLConnection.InsertData("InsertUserMaster", parameterList)); } finally { parameterList = null; } }
public bool Post(SalesTaxEntity salesTax) { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); ManageSQLConnection manageSQL = new ManageSQLConnection(); sqlParameters.Add(new KeyValuePair <string, string>("@SalesID", salesTax.SalesID)); sqlParameters.Add(new KeyValuePair <string, string>("@Month", salesTax.Month)); sqlParameters.Add(new KeyValuePair <string, string>("@Year", salesTax.Year)); sqlParameters.Add(new KeyValuePair <string, string>("@CompanyName", salesTax.CompanyName)); sqlParameters.Add(new KeyValuePair <string, string>("@AccYear", salesTax.AccYear)); sqlParameters.Add(new KeyValuePair <string, string>("@BillNo", salesTax.BillNo)); sqlParameters.Add(new KeyValuePair <string, string>("@BillDate", salesTax.BillDate)); sqlParameters.Add(new KeyValuePair <string, string>("@CommodityName", salesTax.CommodityName)); sqlParameters.Add(new KeyValuePair <string, string>("@TaxType", salesTax.TaxType)); sqlParameters.Add(new KeyValuePair <string, string>("@Measurement", salesTax.Measurement)); sqlParameters.Add(new KeyValuePair <string, string>("@CreditSales", salesTax.CreditSales.ToString().ToLower() == "false" ? "0" : "1")); sqlParameters.Add(new KeyValuePair <string, string>("@GSTType", salesTax.GSTType)); sqlParameters.Add(new KeyValuePair <string, string>("@Scheme", salesTax.Scheme)); sqlParameters.Add(new KeyValuePair <string, string>("@AADS", salesTax.AADS)); sqlParameters.Add(new KeyValuePair <string, string>("@SGST", salesTax.SGST)); sqlParameters.Add(new KeyValuePair <string, string>("@CGST", salesTax.CGST)); sqlParameters.Add(new KeyValuePair <string, string>("@IGST", salesTax.IGST)); sqlParameters.Add(new KeyValuePair <string, string>("@Hsncode", salesTax.Hsncode)); sqlParameters.Add(new KeyValuePair <string, string>("@Quantity", salesTax.Quantity)); sqlParameters.Add(new KeyValuePair <string, string>("@Rate", salesTax.Rate)); sqlParameters.Add(new KeyValuePair <string, string>("@DORate", salesTax.DORATE)); sqlParameters.Add(new KeyValuePair <string, string>("@DOTOTAL", salesTax.DOTOTAL)); sqlParameters.Add(new KeyValuePair <string, string>("@Amount", salesTax.Amount)); sqlParameters.Add(new KeyValuePair <string, string>("@TaxPercentage", salesTax.TaxPercentage)); sqlParameters.Add(new KeyValuePair <string, string>("@TaxAmount", salesTax.TaxAmount)); sqlParameters.Add(new KeyValuePair <string, string>("@Total", salesTax.Total)); sqlParameters.Add(new KeyValuePair <string, string>("@CreatedBy", salesTax.CreatedBy)); sqlParameters.Add(new KeyValuePair <string, string>("@CreatedDate", salesTax.CreatedDate.ToString("MM/dd/yyyy"))); sqlParameters.Add(new KeyValuePair <string, string>("@GCode", salesTax.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@RCode", salesTax.RCode)); return(manageSQL.InsertData("InsertSalesTaxEntry", sqlParameters)); }