private string TransferStock()
{
string _BillNumber = "";
if (Bill_ID.Trim().Length == 0)
{
_BillNumber = GenerateBillNumber();
ObjDAL.SetColumnData("BillNo", SqlDbType.NVarChar, _BillNumber);
ObjDAL.SetColumnData("FromStore", SqlDbType.Int, cmdFrom.SelectedValue);
ObjDAL.SetColumnData("ToStore", SqlDbType.Int, cmdTo.SelectedValue);
ObjDAL.SetColumnData("BillStatus", SqlDbType.NVarChar, lblBillStatus.Text);
ObjDAL.SetColumnData("TotalQTY", SqlDbType.Int, txtTotalQTY.Text);
ObjDAL.SetColumnData("BillDate", SqlDbType.Date, dtpSalesDate.Value.ToString("yyyy-MM-dd"));
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID);
int TransferID = ObjDAL.InsertData(clsUtility.DBName + ".dbo.tblStoreTransferBillDetails", true);
if (TransferID > 0)
{
for (int i = 0; i < dgvProductDetails.Rows.Count; i++)
{
string Total = dgvProductDetails.Rows[i].Cells["Total"].Value.ToString();
string ProductID = dgvProductDetails.Rows[i].Cells["ProductID"].Value.ToString();
string QTY = dgvProductDetails.Rows[i].Cells["BillQTY"].Value.ToString();
string Rate = dgvProductDetails.Rows[i].Cells["Rate"].Value.ToString();
string ColorID = dgvProductDetails.Rows[i].Cells["ColorID"].Value.ToString();
string SizeID = dgvProductDetails.Rows[i].Cells["SizeID"].Value.ToString();
string BarcodeNo = dgvProductDetails.Rows[i].Cells["BarcodeNo"].Value.ToString();
string SubProductID = dgvProductDetails.Rows[i].Cells["SubProductID"].Value.ToString();
ObjDAL.SetColumnData("StoreBillDetailsID", SqlDbType.Int, TransferID);
ObjDAL.SetColumnData("ProductID", SqlDbType.Int, ProductID);
ObjDAL.SetColumnData("Barcode", SqlDbType.NVarChar, BarcodeNo);
ObjDAL.SetColumnData("SubProductID", SqlDbType.Int, SubProductID);
ObjDAL.SetColumnData("Rate", SqlDbType.Decimal, Rate);
ObjDAL.SetColumnData("BillQTY", SqlDbType.Int, QTY);
ObjDAL.SetColumnData("ColorID", SqlDbType.Int, ColorID);
ObjDAL.SetColumnData("SizeID", SqlDbType.Int, SizeID);
ObjDAL.SetColumnData("Total", SqlDbType.Decimal, Total);
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID);
ObjDAL.InsertData(clsUtility.DBName + ".dbo.tblStoreTransferItemDetails", false);
}
clsUtility.ShowInfoMessage("Item has been transferd to selected store.", clsUtility.strProjectTitle);
}
}
else
{
_BillNumber = txtInvoiceNumber.Text;
ObjDAL.UpdateColumnData("UpdatedOn", SqlDbType.DateTime, DateTime.Now);
ObjDAL.UpdateColumnData("UpdatedBy", SqlDbType.Int, clsUtility.LoginID);
ObjDAL.UpdateData(clsUtility.DBName + ".dbo.tblStoreTransferBillDetails", "StoreTransferID='" + Bill_ID + "'");
ObjDAL.ExecuteNonQuery("Delete " + clsUtility.DBName + ".dbo.tblStoreTransferItemDetails WHERE StoreBillDetailsID=" + Bill_ID);
int pBillQTY = 0;
for (int i = 0; i < dgvProductDetails.Rows.Count; i++)
{
string Total = dgvProductDetails.Rows[i].Cells["Total"].Value.ToString();
string ProductID = dgvProductDetails.Rows[i].Cells["ProductID"].Value.ToString();
string QTY = dgvProductDetails.Rows[i].Cells["BillQTY"].Value.ToString();
pBillQTY += Convert.ToInt32(QTY);
string Rate = dgvProductDetails.Rows[i].Cells["Rate"].Value.ToString();
string ColorID = dgvProductDetails.Rows[i].Cells["ColorID"].Value.ToString();
string SizeID = dgvProductDetails.Rows[i].Cells["SizeID"].Value.ToString();
string BarcodeNo = dgvProductDetails.Rows[i].Cells["BarcodeNo"].Value.ToString();
string SubProductID = dgvProductDetails.Rows[i].Cells["SubProductID"].Value.ToString();
ObjDAL.SetColumnData("StoreBillDetailsID", SqlDbType.Int, Bill_ID);
ObjDAL.SetColumnData("ProductID", SqlDbType.Int, ProductID);
ObjDAL.SetColumnData("Barcode", SqlDbType.NVarChar, BarcodeNo);
ObjDAL.SetColumnData("SubProductID", SqlDbType.Int, SubProductID);
ObjDAL.SetColumnData("Rate", SqlDbType.Decimal, Rate);
ObjDAL.SetColumnData("BillQTY", SqlDbType.Int, QTY);
ObjDAL.SetColumnData("ColorID", SqlDbType.Int, ColorID);
ObjDAL.SetColumnData("SizeID", SqlDbType.Int, SizeID);
ObjDAL.SetColumnData("Total", SqlDbType.Decimal, Total);
ObjDAL.SetColumnData("CreatedBy", SqlDbType.Int, clsUtility.LoginID);
ObjDAL.InsertData(clsUtility.DBName + ".dbo.tblStoreTransferItemDetails", false);
}
ObjDAL.UpdateColumnData("TotalQTY", SqlDbType.Int, pBillQTY);
ObjDAL.UpdateColumnData("UpdatedOn", SqlDbType.DateTime, DateTime.Now);
ObjDAL.UpdateColumnData("UpdatedBy", SqlDbType.Int, clsUtility.LoginID);
ObjDAL.UpdateData(clsUtility.DBName + ".dbo.tblStoreTransferBillDetails", "StoreTransferID='" + Bill_ID + "'");
clsUtility.ShowInfoMessage("Item has been transferd to selected store.", clsUtility.strProjectTitle);
}
return(_BillNumber);
}
