public DataTable InsertMerchantSmvRequestToRevise(MerchantSmvRequestModel merchantSmvRequestModel)
{
DataTable dt = null;
try
{
return(dt = new MerchantSmvRequestGateway().InsertMerchantSmvRequestToRevise(merchantSmvRequestModel));
}
catch (Exception ex)
{
throw ex;
}
}
protected void sendButton_Click(object sender, EventArgs e)
{
MerchantSmvRequestModel merchantSmvRequestModel = new MerchantSmvRequestModel();
MerchantGateway merchantGateway = new MerchantGateway();
DataTable dt = new DataTable();
int actionResult = 0;
string pdfFileName = String.Empty;
try
{
if (RequestId > 0)
{
dt = merchantGateway.LoadMerchantRequestInfoRequestIdWise(RequestId);
if (dt.Rows.Count > 0)
{
merchantSmvRequestModel.SmvRequestId = RequestId;
merchantSmvRequestModel.MerchantId = Convert.ToInt32(dt.Rows[0]["MerchantId"]);
merchantSmvRequestModel.BuyerId = Convert.ToInt32(dt.Rows[0]["BuyerId"]);
merchantSmvRequestModel.SampleStageId = Convert.ToInt32(dt.Rows[0]["SampleStageId"]);
merchantSmvRequestModel.StyleNumber = dt.Rows[0]["StyleNumber"].ToString();
merchantSmvRequestModel.DesignNumber = dt.Rows[0]["DesignNumber"].ToString();
merchantSmvRequestModel.ProductCategoryId = Convert.ToInt32(dt.Rows[0]["ProductId"]);
merchantSmvRequestModel.FabricId = Convert.ToInt32(dt.Rows[0]["FabricId"]);
merchantSmvRequestModel.SendToUserId = Convert.ToInt32(dt.Rows[0]["SendToUserId"]);
pdfFileName = merchantSmvRequestModel.MerchantId.ToString()
+ merchantSmvRequestModel.BuyerId.ToString()
+ merchantSmvRequestModel.SampleStageId.ToString()
+ merchantSmvRequestModel.FabricId.ToString()
+ merchantSmvRequestModel.ProductCategoryId.ToString()
+ merchantSmvRequestModel.StyleNumber.ToString()
+ "_" + merchantSmvRequestModel.DesignNumber.ToString()
+ merchantSmvRequestModel.SendToUserId.ToString();
actionResult = merchantGateway.UpdateMerchantRequest(merchantSmvRequestModel.SmvRequestId);
if (actionResult > 0)
{
PdfFileUpload(pdfFileName);
}
}
}
}
catch (Exception ex)
{
}
}
public DataTable InsertMerchantSmvRequestToRevise(MerchantSmvRequestModel merchantSmvRequestModel)
{
DataTable dt = null;
try
{
OpenConnection();
ArrayList arlSqlParameter = new ArrayList();
arlSqlParameter.Add(new SqlParameter("@BuyerId", merchantSmvRequestModel.BuyerId));
arlSqlParameter.Add(new SqlParameter("@MerchantId", merchantSmvRequestModel.MerchantId));
arlSqlParameter.Add(new SqlParameter("@SampleStageId", merchantSmvRequestModel.SampleStageId));
arlSqlParameter.Add(new SqlParameter("@PreviousSampleStage", merchantSmvRequestModel.PreviousSampleStage));
arlSqlParameter.Add(new SqlParameter("@IsActive", merchantSmvRequestModel.IsActive));
arlSqlParameter.Add(new SqlParameter("@StyleNumber", merchantSmvRequestModel.StyleNumber));
arlSqlParameter.Add(new SqlParameter("@DesignNumber", merchantSmvRequestModel.DesignNumber));
arlSqlParameter.Add(new SqlParameter("@FabricId", merchantSmvRequestModel.FabricId));
arlSqlParameter.Add(new SqlParameter("@ProductCategoryId", merchantSmvRequestModel.ProductCategoryId));
arlSqlParameter.Add(new SqlParameter("@ReasonToRevised", merchantSmvRequestModel.ReasonToRevised));
arlSqlParameter.Add(new SqlParameter("@ApproxOrderQtn", merchantSmvRequestModel.ApproxOrderQtn));
arlSqlParameter.Add(new SqlParameter("@CostingDeadLine", merchantSmvRequestModel.CostingDeadLine));
arlSqlParameter.Add(new SqlParameter("@Comments", merchantSmvRequestModel.Comments));
arlSqlParameter.Add(new SqlParameter("@SendToUserId", merchantSmvRequestModel.SendToUserId));
arlSqlParameter.Add(new SqlParameter("@PostedBy", merchantSmvRequestModel.PostedBy));
arlSqlParameter.Add(new SqlParameter("@UpdatedBy", merchantSmvRequestModel.UpdatedBy));
arlSqlParameter.Add(new SqlParameter("@IsOption", merchantSmvRequestModel.IsOption));
dt = this.ExecuteQuery("[KP].[USP_InsertMerchantSmvRequestToRevise]", arlSqlParameter);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
CloseConnection();
}
}
protected void sendButton_Click(object sender, EventArgs e)
{
MerchantSmvRequestModel merchantSmvRequestModel = new MerchantSmvRequestModel();
MerchantSmvRequestBLL merchantSmvRequestBLL = new MerchantSmvRequestBLL();
DataTable dt = new DataTable();
try
{
int value = 0;
merchantSmvRequestModel.BuyerId = Convert.ToInt32(buyerDropDownList.SelectedValue);
value = Convert.ToInt32(sampleStageHiddenField.Value);
merchantSmvRequestModel.SampleStageId = value;
merchantSmvRequestModel.StyleNumber = styleNumberTextBox.Text;
merchantSmvRequestModel.FabricId = Convert.ToInt32(fabricDropDownList.SelectedValue);
merchantSmvRequestModel.ProductCategoryId = Convert.ToInt32(productDropDownList.SelectedValue);
merchantSmvRequestModel.ApproxOrderQtn = Convert.ToInt32(quantityTextBox.Text);
merchantSmvRequestModel.CostingDeadLine = costingDeadLineTextBox.Text;
merchantSmvRequestModel.Comments = commentsTextBox.Text;
merchantSmvRequestModel.SendToUserId = Convert.ToInt32(sendToDropDownList.SelectedValue);
merchantSmvRequestModel.MerchantId = Convert.ToInt32(merchantId);
merchantSmvRequestModel.IsActive = 1;
merchantSmvRequestModel.PreviousSampleStage = 0;
merchantSmvRequestModel.DesignNumber = DesignNumberTextBox.Text;
merchantSmvRequestModel.IsOption = Convert.ToInt32(optionDropDownList.SelectedValue);
pdfFileName = merchantSmvRequestModel.MerchantId.ToString()
+ merchantSmvRequestModel.BuyerId.ToString()
+ merchantSmvRequestModel.SampleStageId.ToString()
+ merchantSmvRequestModel.FabricId.ToString()
+ merchantSmvRequestModel.ProductCategoryId.ToString()
+ merchantSmvRequestModel.StyleNumber.ToString()
+ "_" + merchantSmvRequestModel.DesignNumber.ToString()
+ merchantSmvRequestModel.SendToUserId.ToString();
if (requestId == 0)
{
merchantSmvRequestModel.PostedBy = Convert.ToInt32(merchantId);
merchantSmvRequestModel.UpdatedBy = 0;
dt = merchantSmvRequestBLL.InsertMerchantSmvRequest(merchantSmvRequestModel);
if (dt.Rows.Count > 0)
{
bool success = Convert.ToBoolean(dt.Rows[0]["Success"]);
if (success)
{
messageLabel.Text = "<p Style ='font-size:20px;color:Red; margin-top:20px;'>Already Exists</p>";
}
else
{
messageLabel.Text = "<p Style ='font-size:20px;color:Red; margin-top:20px;'>SMV Information Successfully Sended</p>";
PdfFileUpload(pdfFileName);
ClearData();
table = LoadPendingMerchantRequest(Convert.ToInt32(merchantId));
}
}
}
}
catch (Exception ex)
{
}
}