public GetWorkOrderDetailsStatusQM Execute(GetWorkOrderDetailsStatusCM modelCM)
{
var response = new GetWorkOrderDetailsStatusQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetWorkOrderDetailsStatus]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@WONumber", SsDbType.VarChar, ParameterDirection.Input, modelCM.WorkOrderNumber));
sqlCommand.Parameters.Add(AddParameter("@WOSerial", SsDbType.Decimal, ParameterDirection.Input, modelCM.WorkOrderSerial));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
if (reader.Read())
{
response.Dc = Convert.ToBoolean(reader["Dc"]);
response.Invoice = Convert.ToBoolean(reader["Invoice"]);
response.SubContract = Convert.ToBoolean(reader["SubContract"]);
response.JTC = Convert.ToBoolean(reader["JTC"]);
}
}
}
return(response);
}
public StockEnquiryOptionQM Execute(Int16 Option)
{
StockEnquiryOptionQM response = new StockEnquiryOptionQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetStockOptionEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@Option", SsDbType.SmallInt, ParameterDirection.Input, Option));
if (Option == 0)
{
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.getStockOptionEnquiryForSerialModel = reader.ToList <GetStockOptionEnquiryForSerialModel>();
}
}
else
{
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.getStockOptionEnquiryForItemModel = reader.ToList <GetStockOptionEnquiryForItemModel>();
}
}
}
return(response);
}
public GetWorkOrderClientSerialNoQM Execute(String shortCode)
{
//var response = new GetWorkOrderTypeQM();
GetWorkOrderClientSerialNoQM workOrderSerialNo = new GetWorkOrderClientSerialNoQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetWorkOrderClientSerialNo]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@shortCode", SsDbType.VarChar, ParameterDirection.Input, shortCode));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
if (reader.Read())
{
workOrderSerialNo = new GetWorkOrderClientSerialNoQM()
{
WorkOrderClientSerialNo = Convert.ToString(reader["SerialNo"]),
WorkOrderClientChar = Convert.ToString(reader["SerialChar"])
};
}
}
}
return(workOrderSerialNo);
}
public GetWorkOrderNumberForHeatQM Execute()
{
var response = new GetWorkOrderNumberForHeatQM()
{
};
var responseDtoList = new List <GetWorkOrderNumberHeatModelQM>();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetWorkOrderNumberForHeat]";
sqlCommand.CommandType = CommandType.StoredProcedure;
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
while (reader.Read())
{
var responseDto = new GetWorkOrderNumberHeatModelQM()
{
WONumber = reader["WONumber"].ToString()
};
responseDtoList.Add(responseDto);
}
}
response.getWorkOrderNumberHeatDetails = responseDtoList;
}
return(response);
}
public DataSet Execute()
{
DataSet ds = new DataSet();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetToBeInvoicedEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
ds = SsDbCommandHelper.ExecuteDataset(sqlCommand);
}
return(ds);
}
public DataSet Execute(string SerialNo)
{
DataSet ds = new DataSet();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetSerialNoEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@SerialNo", SsDbType.NVarChar, ParameterDirection.Input, SerialNo));
ds = SsDbCommandHelper.ExecuteDataset(sqlCommand);
}
return(ds);
}
public DataSet Execute(Int16 Option)
{
DataSet ds = new DataSet();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetStockOptionEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@Option", SsDbType.SmallInt, ParameterDirection.Input, Option));
ds = SsDbCommandHelper.ExecuteDataset(sqlCommand);
}
return(ds);
}
public DataSet Execute(DateTime FromDate)
{
DataSet ds = new DataSet();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetDeliveryFollowUpEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@CutOffDate", SsDbType.DateTime, ParameterDirection.Input, FromDate));
ds = SsDbCommandHelper.ExecuteDataset(sqlCommand);
}
return(ds);
}
public GetGPReceiptVendorQM Execute()
{
var response = new GetGPReceiptVendorQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetGPReceiptVendor]";
sqlCommand.CommandType = CommandType.StoredProcedure;
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.gpReceiptVendorList = reader.ToList <GPReceiptVendorModel>();
}
}
return(response);
}
public GetUnitMasterQM Execute()
{
var response = new GetUnitMasterQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetUnitMaster]";
sqlCommand.CommandType = CommandType.StoredProcedure;
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.GetUnitMasterQMList = reader.ToList <GetUnitMasterQMList>();
}
}
return(response);
}
public GetSubContractSendingResponseQM Execute()
{
var response = new GetSubContractSendingResponseQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetSubContractSendingDetails]";
sqlCommand.CommandType = CommandType.StoredProcedure;
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.getSubContractSendingResponseModel = reader.ToList <GetSubContractSendingResponseModel>();
}
}
return(response);
}
public GetProcesssCardCopyQM Execute()
{
var response = new GetProcesssCardCopyQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetCopyProcessCardDetails]";
sqlCommand.CommandType = CommandType.StoredProcedure;
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.GetProcesssCardCopyQMModel = reader.ToList <GetProcesssCardCopyQMModel>();
}
}
return(response);
}
public GetProcessCardQM Execute(string vendorCode)
{
var response = new GetProcessCardQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetProcessCard]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@VendorCode", SsDbType.Decimal, ParameterDirection.Input, vendorCode));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.GetProcessCardDetailsQMModel = reader.ToList <GetProcessCardQMModel>();
}
}
return(response);
}
public GetJobCardMaintanceQM Execute()
{
var response = new GetJobCardMaintanceQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetJobCardMaintance]";
sqlCommand.CommandType = CommandType.StoredProcedure;
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.getJobCardMaintanceQMModelList = reader.ToList <GetJobCardMaintanceQMModel>();
}
}
return(response);
}
public DataSet Execute(Int16 Option, DateTime?fromDate, DateTime?ToDate)
{
DataSet ds = new DataSet();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetDespatchEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@FromDate", SsDbType.DateTime, ParameterDirection.Input, fromDate));
sqlCommand.Parameters.Add(AddParameter("@ToDate", SsDbType.DateTime, ParameterDirection.Input, ToDate));
sqlCommand.Parameters.Add(AddParameter("@IsOption", SsDbType.SmallInt, ParameterDirection.Input, Option));
ds = SsDbCommandHelper.ExecuteDataset(sqlCommand);
}
return(ds);
}
public GetSubContractReceivingResponseQM Execute(Int64 VendorCode)
{
var response = new GetSubContractReceivingResponseQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetScReceivingDetails]";
sqlCommand.Parameters.Add(AddParameter("@VendorCode", SsDbType.BigInt, ParameterDirection.Input, VendorCode));
sqlCommand.CommandType = CommandType.StoredProcedure;
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.getSubContractReceivingResponseModel = reader.ToList <GetSubContractReceivingResponseModel>();
}
}
return(response);
}
public GetSubContractStockEnquiryQM Execute()
{
GetSubContractStockEnquiryQM response = new GetSubContractStockEnquiryQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetSubContractStockEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.GetSubContractStockEnquiryModelList = reader.ToList <GetSubContractStockEnquiryModel>();
}
}
return(response);
}
public InvoicedEnquiryOptionQM Execute()
{
InvoicedEnquiryOptionQM response = new InvoicedEnquiryOptionQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetToBeInvoicedEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.GetInvoicedEnquiryOptionModel = reader.ToList <InvoicedEnquiryOptionModel>();
}
}
return(response);
}
public RolesQM Execute()
{
var response = new RolesQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetRoles]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@RecordCount", SsDbType.Int, ParameterDirection.Output, default(int)));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.roleList = reader.ToList <RoleResponseModel>();
}
}
return(response);
}
public GetSequenceNumberQM Execute(decimal PartCode)
{
var response = new GetSequenceNumberQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetSequenceNumber]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@PartCode", SsDbType.Decimal, ParameterDirection.Input, PartCode));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.SequenceNumberList = reader.ToList <GetSequenceNumberModel>();
}
}
return(response);
}
public GetDcDetailsForInvoiceQM Execute(string DcNumber)
{
var response = new GetDcDetailsForInvoiceQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetDcDetailsForInvoice]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@DcNumber", SsDbType.NVarChar, ParameterDirection.Input, DcNumber));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.GetDcDetailsForInvoiceModel = reader.ToList <GetDcDetailsForInvoiceModel>();
}
}
return(response);
}
public GetJobCardGenerationQM Execute()
{
var response = new GetJobCardGenerationQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetJobCardMasterAndDetails]";
sqlCommand.CommandType = CommandType.StoredProcedure;
//sqlCommand.Parameters.Add(AddParameter("@PartCode", SsDbType.Decimal, ParameterDirection.Input, PartCode));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.GetJobCardGenerationModelList = reader.ToList <GetJobCardGenerationModel>();
}
}
return(response);
}
public GetScDetailsAndSerialsQM Execute(long vendorCode, string DcNumber)
{
var response = new GetScDetailsAndSerialsQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetSubContractDetailAndSerials]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@VendorCode", SsDbType.BigInt, ParameterDirection.Input, vendorCode));
sqlCommand.Parameters.Add(AddParameter("@DcNumber", SsDbType.VarChar, ParameterDirection.Input, DcNumber));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.getScDetailsAndSerialsModel = reader.ToList <GetScDetailsAndSerialsModel>();
}
}
return(response);
}
public DeliveryFollowUpOptionQM Execute(DateTime FromDate)
{
DeliveryFollowUpOptionQM response = new DeliveryFollowUpOptionQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetDeliveryFollowUpEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@CutOffDate", SsDbType.DateTime, ParameterDirection.Input, FromDate));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.getDeliveryFollowUpOptionModel = reader.ToList <DeliveryFollowUpOptionModel>();
}
}
return(response);
}
public SerialNoEnquiryOptionQM Execute(string SerialNo)
{
SerialNoEnquiryOptionQM response = new SerialNoEnquiryOptionQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetSerialNoEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@SerialNo", SsDbType.NVarChar, ParameterDirection.Input, SerialNo));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.getSerialNoEnquiryOptionModel = reader.ToList <SerialNoEnquiryOptionModel>();
}
}
return(response);
}
public GetSerialNoFromWoNumerWoSerialQM Execute(string woNumber, decimal woSerial)
{
var response = new GetSerialNoFromWoNumerWoSerialQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetSerialNoFromWoNumerWoSerialForDc]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@WoNumber", SsDbType.VarChar, ParameterDirection.Input, woNumber));
sqlCommand.Parameters.Add(AddParameter("@WoSerial", SsDbType.Decimal, ParameterDirection.Input, woSerial));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.getSerialNoFromWoNumerWoSerialModel = reader.ToList <GetSerialNoFromWoNumerWoSerialModel>();
}
}
return(response);
}
public GetEmployeeMasterQM Execute()
{
var response = new GetEmployeeMasterQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetEmployeeMaster]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@RecordCount", SsDbType.Int, ParameterDirection.Output, default(int)));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.EmployeeMasterList = reader.ToList <EmployeeMasterModel>();
}
response.RecordCount = Convert.ToInt32(sqlCommand.Parameters["@RecordCount"].Value);
}
return(response);
}
public GetDcNumberForInvoiceQM Execute(Int64 VendorCode, string WoType)
{
var response = new GetDcNumberForInvoiceQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetDcNumberForInvoice]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@VendorCode", SsDbType.BigInt, ParameterDirection.Input, VendorCode));
sqlCommand.Parameters.Add(AddParameter("@WoType", SsDbType.NVarChar, ParameterDirection.Input, WoType));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.GetDcNumberForInvoiceList = reader.ToList <GetDcNumberForInvoiceModel>();
}
}
return(response);
}
public GetWOMasterForDcQM Execute(long vendorCode, string woType)
{
var response = new GetWOMasterForDcQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetWoFromCustomerCodeWoTypeForDc]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@VendorCode", SsDbType.BigInt, ParameterDirection.Input, vendorCode));
sqlCommand.Parameters.Add(AddParameter("@WoType", SsDbType.VarChar, ParameterDirection.Input, woType));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.GetWOMasterForDcModelList = reader.ToList <GetWOMasterForDcModel>();
}
}
return(response);
}
public GetCompanyMasterQM Execute(int companyCode)
{
var response = new GetCompanyMasterQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetCompanyMaster]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@CompanyCode", SsDbType.Int, ParameterDirection.Input, companyCode));
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.GetCompanyMasterModelList = reader.ToList <GetCompanyMasterModel>();
}
//response.RecordCount = Convert.ToInt32(sqlCommand.Parameters["@RecordCount"].Value);
}
return(response);
}
