public CSalesproduct DeleteFromMaster(string SOMaster_OID, string uID)
{
CSalesproduct oSaleaProduct = new CSalesproduct();
DataTable oDt = null;
try
{
strSQL = "delete from t_SODet where SODet_MStrOID = '" + SOMaster_OID + "'";
oManager = new CConManager();
oDt = oManager.Read(strSQL);
strSQL = string.Empty;
strSQL = "delete from t_SOMstr where SOMstr_OID = '" + SOMaster_OID + "'";
oManager = new CConManager();
oDt = oManager.Read(strSQL);
//strSQL = "Update t_SOMstr set SOMstr_OID='" + + "'";
}
catch (Exception ex)
{
CConManager oManager = new CConManager();
oManager.s_ErrorMessage = ex.Message;
}
return(oSaleaProduct);
}
public List <CSalesproduct> allselsproduct(string uID)
{
List <CSalesproduct> salesproductList = new List <CSalesproduct>();
DataTable oDt = null;
try
{
strSQL = string.Format("SELECT SOMstr_OID, SOMstr_Branch, SOMstr_Code, SOMstr_Date,SOMstr_TotalAmt,SOMstr_NetAmt FROM dbo.t_SOMstr ");
oManager = new CConManager();
oDt = oManager.Read(strSQL);
if (oDt != null)
{
foreach (DataRow dr in oDt.Rows)
{
CSalesproduct osalesproduct = new CSalesproduct();
osalesproduct.SOMstr_OID = dr["SOMstr_OID"].ToString();
osalesproduct.SOMstr_Branch = dr["SOMstr_Branch"].ToString();
osalesproduct.SOMstr_Code = dr["SOMstr_Code"].ToString();
osalesproduct.SOMstr_Date = DateTime.Parse(dr["SOMstr_Date"].ToString());
osalesproduct.SOMstr_TotalAmt = float.Parse(dr["SOMstr_TotalAmt"].ToString());
osalesproduct.SOMstr_NetAmt = float.Parse(dr["SOMstr_NetAmt"].ToString());
salesproductList.Add(osalesproduct);
osalesproduct = null;
}
}
}
catch (Exception ex)
{
CConManager oManager = new CConManager();
oManager.s_ErrorMessage = ex.Message;
}
return(salesproductList);
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = null;
CConManager oConnManager = new CConManager();
string s_DBError = "";
string Item_OID = "";
string ItemCode = txtStartCode.Text;
int st = Convert.ToInt32(txtStart.Text);
int en = Convert.ToInt32(txtend.Text);
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
for (; st <= en; st++)
{
string strItemCode = ItemCode.Substring(0, 4);
string strCode = "" + Convert.ToString(Convert.ToInt32(ItemCode.Substring(4)) + 1);
for (int j = 5; j > (strCode.Length); j--)
{
strItemCode += "0";
}
ItemCode = strItemCode + strCode;
for (int j = 10; j > (st.ToString().Length); j--)
{
Item_OID += "0";
}
Item_OID += st.ToString();
string sql = "UPDATE t_Item SET Item_Code = '" + ItemCode + "' WHERE Item_OID='ItemXXXXBRN01 " + Item_OID + "'";
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (SqlException ewe)
{
}
Item_OID = "";
}
}
oConnManager.Close();
txtStartCode.Text = ItemCode;
}
public CSGoodsReceive DeleteGoodsReceivede(string Rec_OID, string Rec_ProductID, string uID)
{
CSGoodsReceive oReceiveDetails = new CSGoodsReceive();
DataTable oDt = null;
try
{
strSQL = "delete from t_GReceive where Rec_OID = '" + Rec_OID + "' and Rec_ProductID = '" + Rec_ProductID + "' ";
oManager = new CConManager();
oDt = oManager.Read(strSQL);
}
catch (Exception ex)
{
CConManager oManager = new CConManager();
oManager.s_ErrorMessage = ex.Message;
}
return(oReceiveDetails);
}
//public List<CGoodsReceiveDetails> AllGoodsReceive(string Rec_OID, string uID)
//{
// List<CGoodsReceiveDetails> oGoodReceiveList = new List<CGoodsReceiveDetails>();
// DataTable oDt = null;
// try
// {
// strSQL = @"select * from t_GRDet where GRDet_MStrOID= '" + GRMstr_ID + "'";
// oManager = new CConManager();
// oDt = oManager.Read(strSQL, uID);
// if (oDt.Rows.Count > 0)
// {
// foreach (DataRow dr in oDt.Rows)
// {
// CGoodsReceiveDetails oGoodsReceiveDetails = new CGoodsReceiveDetails();
// oGoodsReceiveDetails.GRDet_OID = dr["GRDet_OID"].ToString();
// oGoodsReceiveDetails.GRDet_Branch = dr["GRDet_Branch"].ToString();
// oGoodsReceiveDetails.GRDet_MStrOID = dr["GRDet_MStrOID"].ToString();
// oGoodsReceiveDetails.GRDet_ItemOID = dr["GRDet_ItemOID"].ToString();
// oGoodsReceiveDetails.GRDet_QTY = float.Parse(dr["GRDet_QTY"].ToString());
// oGoodsReceiveDetails.GRDet_UOM = dr["GRDet_UOM"].ToString();
// oGoodsReceiveDetails.GRDet_BranchOID =dr["GRDet_BranchOID"].ToString();
// oGoodsReceiveDetails.GRDet_LocOID = dr["GRDet_LocOID"].ToString();
// oGoodsReceiveDetails.GRDet_InvType = int.Parse(dr["GRDet_InvType"].ToString());
// oGoodsReceiveDetails.GRDet_Currency = dr["GRDet_Currency"].ToString();
// oGoodsReceiveDetails.GRDet_Price = float.Parse(dr["GRDet_Price"].ToString());
// oGoodsReceiveDetails.GRDet_Amount = float.Parse(dr["GRDet_Amount"].ToString());
// oGoodReceiveList.Add(oGoodsReceiveDetails);
// oGoodsReceiveDetails = null;
// }
// }
// else
// {
// strSQL = @"delete from t_GRMstr where GRMstr_OID = '" + GRMstr_ID + "'";
// oManager = new CConManager();
// oDt = oManager.Read(strSQL, uID);
// }
// }
// catch (Exception ex)
// {
// CConManager oManager = new CConManager();
// oManager.s_ErrorMessage = ex.Message;
// }
// return oGoodReceiveList;
//}
#endregion
#region Delete GoodsReceive Details
public CSGoodsReceive UpdateGoodsReceivede(CSGoodsReceive ogoodreceive, string uID)
{
CSGoodsReceive oReceiveDetails = new CSGoodsReceive();
DataTable oDt = null;
try
{
strSQL = "Update t_GReceive set Rec_ReceivedQty= " + ogoodreceive.Rec_ReceivedQty + "where Rec_OID = " + ogoodreceive.Rec_OID + " and Rec_ProductID = '" + ogoodreceive.Rec_ProductID + "' ";
oManager = new CConManager();
oDt = oManager.Read(strSQL);
}
catch (Exception ex)
{
CConManager oManager = new CConManager();
oManager.s_ErrorMessage = ex.Message;
}
return(oReceiveDetails);
}
public List <CSGoodsReceive> allGoodsReceive(string uID)
{
List <CSGoodsReceive> oGoodsReceiveList = new List <CSGoodsReceive>();
DataTable oDt = null;
try
{
strSQL = string.Format("SELECT dbo.t_GReceive.Rec_OID, dbo.t_GReceive.Rec_ReqID, dbo.t_GReceive.Rec_IssueID, dbo.t_GReceive.Rec_BranchID, dbo.t_GReceive.Rec_ProductID, dbo.t_GReceive.Rec_WantedQTY, dbo.t_GReceive.Rec_IssueQTY, dbo.t_GReceive.Rec_Remark, dbo.t_GReceive.Rec_ReceivedQty, dbo.t_Item.Item_ItemName FROM dbo.t_Item RIGHT OUTER JOIN dbo.t_GReceive ON dbo.t_Item.Item_OID = dbo.t_GReceive.Rec_ProductID");
oManager = new CConManager();
oDt = oManager.Read(strSQL);
if (oDt != null)
{
foreach (DataRow dr in oDt.Rows)
{
CSGoodsReceive oGoodReceives = new CSGoodsReceive();
oGoodReceives.Item_Name = dr["Item_ItemName"].ToString();
oGoodReceives.Rec_OID = dr["Rec_OID"].ToString();
oGoodReceives.Rec_ReqID = dr["Rec_ReqID"].ToString();
oGoodReceives.Rec_IssueID = dr["Rec_IssueID"].ToString();
oGoodReceives.Rec_BranchID = dr["Rec_BranchID"].ToString();
oGoodReceives.Rec_ProductID = dr["Rec_ProductID"].ToString();
oGoodReceives.Rec_WantedQTY = Int32.Parse(dr["Rec_WantedQTY"].ToString());
oGoodReceives.Rec_IssueQTY = Int32.Parse(dr["Rec_IssueQTY"].ToString());
oGoodReceives.Rec_Remark = dr["Rec_Remark"].ToString();
oGoodReceives.Rec_ReceivedQty = Int32.Parse(dr["Rec_ReceivedQty"].ToString());
oGoodsReceiveList.Add(oGoodReceives);
oGoodReceives = null;
}
}
}
catch (Exception ex)
{
CConManager oManager = new CConManager();
oManager.s_ErrorMessage = ex.Message;
}
return(oGoodsReceiveList);
}
//public List<CHijibi> amount(string uID)
//{
// List<CHijibi> oamount =new List<CHijibi>();
// DataTable oDt = null;
// strSQL = "select * from t_Mozila";
// oManager = new CConManager();
// oDt = oManager.Read(strSQL, uID);
// if (oDt != null)
// {
// foreach (DataRow dr in oDt.Rows)
// {
// CHijibi oamounta = new CHijibi();
// oamounta.Chrom = float.Parse(dr["Chrom"].ToString());
// oamount.Add(oamounta);
// oamounta = null;
// }
// }
// return oamount;
//}
//public CSalesproduct CreateMaxID(string uID)
//{
// string MasterID = string.Empty;
// DataTable oDt = null;
// try
// {
// strSQL = string.Format("SELECT SOMstr_OID FROM t_SOMstr ");
// oManager = new CConManager();
// oDt = oManager.Read(strSQL, uID);
// if (oDt != null)
// {
// if (oDt.Rows.Count == 0)//BIL-NO-00001
// {
// MasterID = "SOMstrXXBRN01 0000000001";
// }
// else
// {
// DataRow dr = oDt.Rows[0];
// MasterID = dr["Bill_Id"].ToString();
// MasterID = MasterID.Remove(0, 13);
// MasterID = (Convert.ToInt64(MasterID) + 1).ToString();
// MasterID = MasterID.PadLeft(2, '0');
// MasterID = MasterID.PadLeft(3, '0');
// MasterID = MasterID.PadLeft(4, '0');
// MasterID = MasterID.PadLeft(5, '0');
// MasterID = MasterID.PadLeft(6, '0');
// MasterID = MasterID.PadLeft(7, 'O');
// MasterID = MasterID.PadLeft(8, '0');
// MasterID = MasterID.PadLeft(9, '0');
// MasterID = MasterID.PadLeft(10, '0');
// MasterID = MasterID.PadLeft(11, ' ');
// MasterID = MasterID.PadLeft(12, '1');
// MasterID = MasterID.PadLeft(13, '0');
// MasterID = MasterID.PadLeft(14, 'N');
// MasterID = MasterID.PadLeft(15, 'R');
// MasterID = MasterID.PadLeft(16, 'B');
// MasterID = MasterID.PadLeft(17, 'X');
// MasterID = MasterID.PadLeft(18, 'X');
// MasterID = MasterID.PadLeft(19, 'r');
// MasterID = MasterID.PadLeft(20, 't');
// MasterID = MasterID.PadLeft(21, 's');
// MasterID = MasterID.PadLeft(22, 'M');
// MasterID = MasterID.PadLeft(23, 'O');
// MasterID = MasterID.PadLeft(23, 'S');
// }
// }
// }
// catch (Exception ex)
// {
// oManager.s_ErrorMessage = ex.Message;
// MasterID = string.Empty;
// }
// finally
// {
// oManager = null;
// strSQL = string.Empty;
// }
// return null;
//}
public CSalesDetials DeleteFromdetails(string ItemID, string So_detailsID, float qty, string receiveID, string MasterID, float detamount, string uID)
{
CSalesDetials oSaleaDetails = new CSalesDetials();
DataTable oDt = null;
try
{
strSQL = "delete from t_SODet where SODet_OID='" + So_detailsID + "'";
//strSQL = @"IF(EXISTS(SELECT ID FROM t_SODet WHERE SODet_ItemOID='" + Rec_OID + "'))BEGIN UPDATE t_GReceive SET Rec_ReceivedQty=Rec_ReceivedQty-" + oSaleaDetails.SODet_QTY + "where Rec_ProductID='" + Rec_OID + "' END";
//sqlList.Add(strSQL);
oManager = new CConManager();
oDt = oManager.Read(strSQL);
strSQL = string.Empty;
strSQL = "Update t_GReceive set Rec_ReceivedQty=Rec_ReceivedQty- " + qty + " where Rec_OID='" + receiveID + "' and Rec_ProductID = '" + ItemID + "'";
oManager = new CConManager();
oDt = oManager.Read(strSQL);
strSQL = string.Empty;
strSQL = "Update t_SOMstr set SOMstr_NetAmt=SOMstr_NetAmt- " + detamount + " where SOMstr_OID='" + MasterID + "'";
oManager = new CConManager();
oDt = oManager.Read(strSQL);
//float deletedAmount = Actualamount - amount;
// float percentage = (deletedAmount * 100) / Actualamount;
}
catch (Exception ex)
{
CConManager oManager = new CConManager();
oManager.s_ErrorMessage = ex.Message;
}
return(oSaleaDetails);
}
public CSizeBO()
{
oConnManager = new CConManager();
}
public CCustomerBO()
{
oConnManager = new CConManager();
}
public CPurchaseBO()
{
oConnManager = new CConManager();
}
public CCompanyBO()
{
oConnManager = new CConManager();
}
public CCashCardBO()
{
oConnManager = new CConManager();
}
public CPriceMasterBO()
{
oConnManager = new CConManager();
}
public CUOMBO()
{
oConnManager = new CConManager();
}
private void btnImport_Click(object sender, EventArgs e)
{
try
{
progressBarImport.Value = 0;
Cursor = Cursors.WaitCursor;
string selectGRFromHomeMaster = "select *from t_GRMstr where GRMatr_IsImported=0";
SqlConnection oConnectionForHomeDB = new CConManager().GetConnectionForRemote();
DataTable dtHome = new DataTable();
SqlCommand oCommandForHome = new SqlCommand(selectGRFromHomeMaster, oConnectionForHomeDB);
oCommandForHome.CommandType = CommandType.Text;
SqlDataAdapter oSqlAdapter = new SqlDataAdapter(oCommandForHome);
oSqlAdapter.Fill(dtHome);
List <CGRMaster> oGRMasterList = new List <CGRMaster>();
progressBarImport.Value = 70;
if (dtHome.Rows.Count > 0)
{
progressBarImport.Value = 70;
foreach (DataRow dr in dtHome.Rows)
{
CGRMaster oGRMaster = new CGRMaster();
oGRMaster.GRMstr_OID = "";
oGRMaster.GRMstr_Branch = currentBranch.CompBrn_Code;
oGRMaster.GRMstr_Code = GetGRmstrCode();
oGRMaster.GRMstr_Type = int.Parse(dr["GRMstr_Type"].ToString());
oGRMaster.GRMstr_Date = DateTime.Parse(dr["GRMstr_Date"].ToString());
oGRMaster.GRMstr_By = dr["GRMstr_By"].ToString();
oGRMaster.Remarks = dr["GRMstr_Remarks"].ToString();
oGRMaster.GRMstr_RefBy = dr["GRMstr_RefBy"].ToString();
oGRMaster.Creator = dr["GRMstr_Creator"].ToString();
oGRMaster.CreationDate = DateTime.Parse(dr["GRMstr_CreationDate"].ToString());
oGRMaster.UpdateBy = dr["GRMstr_UpdateBy"].ToString();
oGRMaster.UpdateDate = DateTime.Parse(dr["GRMstr_UpdateDate"].ToString());
oGRMaster.IsActive = "Y";
oGRMaster.GRMstr_IsImported = 1;
string selectGRForHomeDetail = "select *from t_GRDet where GRDet_MStrOID='" + dr["GRMstr_OID"].ToString() + "'";
SqlConnection oConnectionForHomeDBDetail = new CConManager().GetConnectionForRemote();
DataTable dtHomedetail = new DataTable();
SqlCommand oCommand = new SqlCommand(selectGRForHomeDetail, oConnectionForHomeDBDetail);
oCommand.CommandType = CommandType.Text;
SqlDataAdapter oDataAdapter = new SqlDataAdapter(oCommand);
oDataAdapter.Fill(dtHomedetail);
//List<CGRDetails> oGRDetailList = new List<CGRDetails>();
if (dtHomedetail.Rows.Count > 0)
{
foreach (DataRow drDetail in dtHomedetail.Rows)
{
CGRDetails oGRDetails = new CGRDetails();
oGRDetails.GRDet_Branch = currentBranch.CompBrn_Code;
oGRDetails.GRDet_ItemOID = drDetail["GRDet_ItemOID"].ToString();
oGRDetails.GRDet_QTY = float.Parse(drDetail["GRDet_QTY"].ToString());
oGRDetails.GRDet_UOM = drDetail["GRDet_UOM"].ToString();
oGRDetails.GRDet_BranchOID = currentBranch.CompBrn_OId;
oGRDetails.GRDet_LocOID = drDetail["GRDet_LocOID"].ToString();
oGRDetails.GRDet_InvType = int.Parse(drDetail["GRDet_InvType"].ToString());
oGRDetails.GRDet_Price = float.Parse(drDetail["GRDet_Price"].ToString());
oGRDetails.GRDet_Currency = drDetail["GRDet_Currency"].ToString();
oGRDetails.GRDet_Amount = float.Parse(drDetail["GRDet_Amount"].ToString());
//oGRDetailList.Add(oGRDetails);
oGRMaster.GRMstr_DetailsList.Add(oGRDetails);
}
}
//oGRMaster.GRMstr_DetailsList = oGRDetailList;
oGRMasterList.Add(oGRMaster);
}
if (oGRMasterList.Count > 0)
{
foreach (CGRMaster oGRMaster in oGRMasterList)
{
progressBarImport.Value = 50;
CResult oResult = new CResult();
CGRBO oGRBO = new CGRBO();
if (oGRMaster != null)
{
oResult = oGRBO.Create(oGRMaster);
}
if (oResult.IsSuccess)
{
progressBarImport.Value = 100;
this.Cursor = Cursors.Default;
oResult = oGRBO.UpdateHomeGRTable();
}
progressBarImport.Value = 100;
MessageBox.Show("Goods are successfully Imported", "ETLPOS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else if (dtHome.Rows.Count <= 0)
{
DialogResult oDR = MessageBox.Show("You Have No Goods For Import", "ETLPOS", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (oDR.ToString() == "OK")
{
this.Cursor = Cursors.Default;
progressBarImport.Value = 0;
}
}
}
catch
{
MessageBox.Show("You Have No Goods For Import", "ETLPOS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public CInventoryBO()
{
oConnManager = new CConManager();
}
public CUserBO()
{
oConnManager = new CConManager();
}
public CMemberShipBO()
{
oConnManager = new CConManager();
}
public CCurrencyBO()
{
oConnManager = new CConManager();
}
public CLocBO()
{
oConnManager = new CConManager();
}
public CReorderLevelBO()
{
oConnManager = new CConManager();
}
public CPaymentBO()
{
oConnManager = new CConManager();
}
public CMaterialTransferBO()
{
oConnManager = new CConManager();
}
public CSupplierBO()
{
oConnManager = new CConManager();
}
public CPartyBO()
{
oConnManager = new CConManager();
}
public CEmployeeBO()
{
oConnManager = new CConManager();
}
public CCommonBO()
{
oConnManager = new CConManager();
}
public List <CSalesDetials> Saleadetels(string SODet_MStrOID, string uID)
{
List <CSalesDetials> oSalesDetails = new List <CSalesDetials>();
DataTable oDt = null;
try
{ //SELECT dbo.t_Item.Item_ItemName, dbo.t_SODet.* FROM dbo.t_Item LEFT OUTER JOIN dbo.t_SODet ON dbo.t_Item.Item_OID = dbo.t_SODet.SODet_ItemOID
strSQL = @"SELECT dbo.t_SODet.SODet_OID, dbo.t_SODet.SODet_Branch, dbo.t_SODet.SODet_MStrOID, dbo.t_SODet.SODet_ItemSLNum, dbo.t_SODet.SODet_ItemOID,
dbo.t_SODet.SODet_QTY, dbo.t_SODet.SODet_UOM, dbo.t_SODet.SODet_Price, dbo.t_SODet.SODet_Currency, dbo.t_SODet.SODet_Amount,
dbo.t_SODet.SODet_SDValue, dbo.t_SODet.SODet_SDAmount, dbo.t_SODet.SODet_VATValue, dbo.t_SODet.SODet_VATAmount, dbo.t_SODet.SODet_Discount,
dbo.t_SODet.SODet_NetAmount, dbo.t_SODet.SODet_BranchOID, dbo.t_SODet.SODet_LocOID, dbo.t_GReceive.Rec_ReceivedQty, dbo.t_GReceive.Rec_IssueQTY,
dbo.t_GReceive.Rec_WantedQTY, dbo.t_GReceive.Rec_ProductID, dbo.t_GReceive.Rec_OID, dbo.t_GReceive.Rec_BranchID, dbo.t_Item.Item_ItemName
FROM dbo.t_Item LEFT OUTER JOIN
dbo.t_SODet ON dbo.t_Item.Item_OID = dbo.t_SODet.SODet_ItemOID LEFT OUTER JOIN
dbo.t_GReceive ON dbo.t_SODet.SODet_ItemOID = dbo.t_GReceive.Rec_ProductID where SODet_MStrOID= '" + SODet_MStrOID + "'";
oManager = new CConManager();
oDt = oManager.Read(strSQL);
if (oDt.Rows.Count > 0)
{
foreach (DataRow dr in oDt.Rows)
{
CSalesDetials salesDetails = new CSalesDetials();
salesDetails.SODet_OID = dr["SODet_OID"].ToString();
salesDetails.SODet_MStrOID = dr["SODet_MStrOID"].ToString();
salesDetails.SODet_ItemName = dr["Item_ItemName"].ToString();
salesDetails.SODet_Branch = dr["SODet_Branch"].ToString();
//salesDetails.SODet_ItemSLNum = dr["SODet_ItemSLNum"].ToString();
salesDetails.SODet_ItemOID = dr["SODet_ItemOID"].ToString();
//salesDetails.SODet_ItemName = dr["SODet_ItemName"].ToString();
salesDetails.SODet_QTY = float.Parse(dr["SODet_QTY"].ToString());
//salesDetails.SODet_UOM = dr["SODet_UOM"].ToString();
salesDetails.SODet_Price = float.Parse(dr["SODet_Price"].ToString());
//salesDetails.SODet_Currency = dr["SODet_Currency"].ToString();
salesDetails.SODet_Amount = float.Parse(dr["SODet_Amount"].ToString());
salesDetails.SODet_SDValue = float.Parse(dr["SODet_SDValue"].ToString());
salesDetails.SODet_SDAmount = float.Parse(dr["SODet_SDAmount"].ToString());
salesDetails.SODet_VATValue = float.Parse(dr["SODet_VATValue"].ToString());
salesDetails.SODet_VATAmount = float.Parse(dr["SODet_VATAmount"].ToString());
salesDetails.SODet_Discount = float.Parse(dr["SODet_Discount"].ToString());
salesDetails.SODet_NetAmount = float.Parse(dr["SODet_NetAmount"].ToString());
salesDetails.Rec_OID = dr["Rec_OID"].ToString();
//salesDetails.SODet_LocOID = dr["SODet_LocOID"].ToString();
oSalesDetails.Add(salesDetails);
salesDetails = null;
}
}
//else
//{
// strSQL = @"delete from t_SOMstr where SOMstr_OID = '" + SODet_MStrOID + "'";
// oManager = new CConManager();
// oDt = oManager.Read(strSQL, uID);
//}
}
catch (Exception ex)
{
CConManager oManager = new CConManager();
oManager.s_ErrorMessage = ex.Message;
}
return(oSalesDetails);
}
public CGRBO()
{
oConnManager = new CConManager();
}
public CCVBBO()
{
oConnManager = new CConManager();
}
