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