private static void ProcessQuoteHeader(QuoteHeader header, string spName, bool isUpdate = false)
{
try
{
SqlParameter pQuoteCreatedOn = new SqlParameter();
pQuoteCreatedOn.ParameterName = "CreatedOn";
pQuoteCreatedOn.Value = header.QuoteCreatedOn;
SqlParameter pRequestedShipDate = new SqlParameter();
pRequestedShipDate.ParameterName = "RequestedShipDate";
pRequestedShipDate.Value = header.QuoteRequestedOn;
SqlParameter pCustomerPO = new SqlParameter();
pCustomerPO.ParameterName = "CustomerPO";
pCustomerPO.Value = header.CustomerPO;
SqlParameter pLeadTimeID = new SqlParameter();
pLeadTimeID.ParameterName = "LeadTimeID";
pLeadTimeID.Value = header.LeadTimeID;
SqlParameter pLeadTimeTypeID = new SqlParameter();
pLeadTimeTypeID.ParameterName = "LeadTimeTypeID";
pLeadTimeTypeID.Value = header.LeadTimeTypeID;
SqlParameter pShipToOtherAddress = new SqlParameter();
pShipToOtherAddress.ParameterName = "ShipToOtherAddress";
pShipToOtherAddress.Value = header.IsShipToOtherAddress;
SqlParameter pQuoteNumber = new SqlParameter();
pQuoteNumber.ParameterName = "QuoteNumber";
pQuoteNumber.Value = header.QuoteNumber;
SqlParameter pShippingMethodID = new SqlParameter();
pShippingMethodID.ParameterName = "ShippingMethodID";
pShippingMethodID.Value = header.ShippingMethodID;
SqlParameter pCustomerID = new SqlParameter();
pCustomerID.ParameterName = "CustomerID";
pCustomerID.Value = header.CustomerID;
SqlParameter pOperatorName = new SqlParameter();
pOperatorName.ParameterName = "OperatorName";
pOperatorName.Value = header.OperatorName;
SqlParameter pPaymentModeID = new SqlParameter();
pPaymentModeID.ParameterName = "PaymentModeID";
pPaymentModeID.Value = header.PaymentModeID;
SqlParameter pQuoteStatusID = new SqlParameter();
pQuoteStatusID.ParameterName = "QuoteStatusID";
pQuoteStatusID.Value = header.QuoteStatusID;
if (header.IsNewCustomer && isUpdate == false)
{
string customerID = CreateNewCustomer(header.SoldTo);
if (header.IsShipToOtherAddress == true && string.IsNullOrEmpty(customerID) == false)
{
InsertShippingDetails(customerID, header.QuoteNumber, header.ShipTo);
}
pCustomerID.Value = int.Parse(customerID);
}
SQLHelper.ExecuteStoredProcedure(spName, pQuoteCreatedOn, pRequestedShipDate, pCustomerPO, pLeadTimeID, pLeadTimeTypeID,
pShipToOtherAddress, pQuoteNumber, pCustomerID, pShippingMethodID, pOperatorName, pPaymentModeID, pQuoteStatusID);
}
catch (Exception ex)
{
Logger.LogException(ex);
}
}
internal static void SaveQuoteHeader(QuoteHeader header)
{
try
{
ProcessQuoteHeader(header, StoredProcedures.AddQuoteHeader);
}
catch (Exception ex)
{
Logger.LogException(ex);
}
}
internal static void UpdateQuoteHeader(QuoteHeader header, bool isUpdate)
{
ProcessQuoteHeader(header, StoredProcedures.UpdateQuoteHeader, isUpdate);
}
private QuoteHeader BuildQuoteHeader(string quoteNumber)
{
QuoteHeader header = new QuoteHeader();
try
{
header.QuoteNumber = quoteNumber;
header.QuoteCreatedOn = dtQuoteCreatedOn.SelectedDate.Value.ToShortDateString();
header.QuoteRequestedOn = dtQuoteRequestedOn.SelectedDate.Value.ToShortDateString();
header.CustomerPO = txtCustomerPO.Text;
header.IsNewCustomer = cbIsNewClient.IsChecked == true;
header.IsShipToOtherAddress = cbIsShipToSameAddress.IsChecked == true;
header.ShippingMethodID = cmbShippingMethod.SelectedIndex;
header.LeadTimeID = cmbLeadTime.SelectedIndex;
header.LeadTimeTypeID = cmbLeadTimeType.SelectedIndex;
header.PaymentModeID = int.Parse(cmbPaymentType.SelectedValue.ToString());
header.QuoteStatusID = int.Parse(cmbQuoteStatus.SelectedValue.ToString());
if (FirmSettings.IsAdmin)
{
header.OperatorName = cmbOperator.Text;
}
else
{
header.OperatorName = txtOperatorName.Text;
}
if (cbIsNewClient.IsChecked.Value == false)
{
header.CustomerID = int.Parse(cmbCustomers.SelectedValue.ToString());
}
header.SoldTo = new CustomerDetails();
header.SoldTo.FirstName = txtSoldToFirstName.Text;
header.SoldTo.LastName = txtSoldToLastName.Text;
header.SoldTo.Address = txtSoldToAddress.Text;
header.SoldTo.Phone = txtSoldToPhone.Text;
header.SoldTo.Email = txtSoldToEmail.Text;
header.SoldTo.Fax = txtSoldToFax.Text;
header.SoldTo.Misc = txtSoldToMisc.Text;
if (cbIsShipToSameAddress.IsChecked == true)
{
header.ShipTo = new CustomerDetails();
header.ShipTo.FirstName = txtShiptoFirstName.Text;
header.ShipTo.LastName = txtShiptoLastName.Text;
header.ShipTo.Address = txtShipToAddress.Text;
header.ShipTo.Phone = txtShipToPhone.Text;
header.ShipTo.Email = txtShipToEmail.Text;
header.ShipTo.Fax = txtShipToFax.Text;
header.ShipTo.Misc = txtShipToMisc.Text;
}
}
catch (Exception ex)
{
Logger.LogException(ex);
}
return header;
}