public Int64 InsertUpdateKitDetails(bool bIsSaveKit_Asset = true)
{
Int64 nKitID = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
Object objValue = null;
Object objStatus = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nKitID", this.nKitID, ParameterDirection.InputOutput, SqlDbType.BigInt);
oDBParameter.Add("@sKitName", this.sKitName, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sKitCode", this.sKitCode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sKitAbbrivation", this.sKitAbbrivation, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sKitDescription", this.sKitDescription, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@kitBarcode", this.kitBarcode, ParameterDirection.Input, SqlDbType.Image);
oDBAccess.OpenConnection(true);
oDBAccess.Execute("lgsp_INUP_KitMaster", oDBParameter, out objValue);
if (objValue != null)
{
nKitID = Convert.ToInt64(objValue);
}
if (nKitID == 0)
{
oDBAccess.RollBack();
oDBAccess.CloseConnection(true);
return(nKitID);
}
if (nKitID != 0 && bIsSaveKit_Asset)
{
foreach (KitAsset item in lstKitDetails)
{
oDBParameter.clear();
oDBParameter.Add("@nKitID", nKitID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nKitAssetID", item.nKitAssetID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nAssetCodeID", item.nAssetCodeID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nAssetID", item.nAssetID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nStatus", 0, ParameterDirection.InputOutput, SqlDbType.Int);
oDBAccess.Execute("lgsp_INUP_KitAssetAssociation", oDBParameter, out objStatus);
int nStatus = 0;
if (objValue != null)
{
nStatus = Convert.ToInt32(objStatus);
}
if (nStatus <= 0)
{
oDBAccess.RollBack();
oDBAccess.CloseConnection(true);
return(nStatus);
}
if (nStatus == 2)
{
oDBAccess.RollBack();
oDBAccess.CloseConnection(true);
return(nStatus);
}
}
}
oDBAccess.Commit();
}
catch (Exception ex)
{
oDBAccess.RollBack();
oDBAccess.CloseConnection(true);
MessageBox.Show("Error: " + ex.ToString(), clsGlobal.MessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (oDBAccess != null)
{
oDBAccess.Dispose();
oDBAccess = null;
}
if (oDBParameter != null)
{
oDBParameter.Dispose();
oDBParameter = null;
}
}
return(nKitID);
}
public Int64 UpdateAssetCode()
{
Int64 nStatus = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
Object objStatus = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nKitID", this.nKitID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nKitAssetID", this.nKitAssetID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nAssetID", this.nAssetID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nAssetCodeID", this.nAssetCodeID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nStatus", 0, ParameterDirection.InputOutput, SqlDbType.Int);
oDBAccess.OpenConnection(false);
oDBAccess.Execute("lgsp_INUP_KitAssetAssociation", oDBParameter, out objStatus);
oDBAccess.CloseConnection(false);
if (objStatus != null)
{
nStatus = Convert.ToInt32(objStatus);
}
if (nStatus <= 0)
{
oDBAccess.RollBack();
oDBAccess.CloseConnection(true);
return(nStatus);
}
if (nStatus == 2)
{
oDBAccess.RollBack();
oDBAccess.CloseConnection(true);
return(nStatus);
}
oDBAccess.Commit();
oDBAccess.CloseConnection(true);
}
catch (Exception ex)
{
oDBAccess.RollBack();
oDBAccess.CloseConnection(true);
MessageBox.Show("Error: " + ex.ToString(), clsGlobal.MessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (oDBAccess != null)
{
oDBAccess.Dispose();
oDBAccess = null;
}
if (oDBParameter != null)
{
oDBParameter.Dispose();
oDBParameter = null;
}
}
return(nStatus);
}
public Int64 InsertUpdatePartyMaster()
{
Int64 _nPartyID = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
Object objValue = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nPartyID", this.nPartyID, ParameterDirection.InputOutput, SqlDbType.BigInt);
oDBParameter.Add("@sPartyCode", this.sPartyCode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPartyName", this.sPartyName, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPartyAbbrivation", this.sPartyAbbrivation, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@nPartyTypeID", this.nPartyTypeID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@sAddressLine1", this.sAddressLine1, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sAddressLine2", this.sAddressLine2, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCity", this.sCity, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sState", this.sState, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPincode", this.sPincode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCountry", this.sCountry, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sEmail", this.sEmail, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sFax", this.sFax, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sAllPhoneNo", this.sAllPhoneNo, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sBillToAddressLine1", this.sBillToAddressLine1, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sBillToAddressLine2", this.sBillToAddressLine1, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sBillToPincode", this.sBillToAddressLine1, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sShipToAddressLine1", this.sShipToAddressLine1, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sShipToAddressLine2", this.sShipToAddressLine1, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sShipToPincode", this.sShipToPincode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sGSTNO", this.sGSTNo, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPANNO", this.sPANNo, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sTANNO", this.sTANNo, ParameterDirection.Input, SqlDbType.VarChar);
oDBAccess.OpenConnection(false);
oDBAccess.Execute("lgsp_INUP_PartyMaster", oDBParameter, out objValue);
oDBAccess.CloseConnection(false);
if (objValue != null)
{
_nPartyID = Convert.ToInt64(objValue);
}
}
catch (Exception ex)
{
oDBAccess.CloseConnection(false);
MessageBox.Show("Error: " + ex.ToString(), clsGlobal._sMessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
if (oDBAccess != null)
{
oDBAccess.Dispose();
oDBAccess = null;
}
if (oDBParameter != null)
{
oDBParameter.Dispose();
oDBParameter = null;
}
}
return(_nPartyID);
}
public Int64 UpdateAssetCode()
{
Int64 nStatus = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
Object objStatus = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nAssetID", this.nAssetID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nAssetCodeID", this.nAssetCodeID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@sInitialCode", this.sInitialCode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@nSequenceNo", this.nSequenceNo, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@sUniqueCode", this.sUniqueCode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@barcode", this.barcode, ParameterDirection.Input, SqlDbType.Image);
oDBParameter.Add("@dtShelfLife", this.dtShelfLife, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@sShelfLifeUnit", this.sShelfLifeUnit, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@dtRetirementDate", this.dtRetirementDate, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@nStatus", 0, ParameterDirection.InputOutput, SqlDbType.Int);
oDBAccess.OpenConnection(false);
oDBAccess.Execute("lgsp_INUP_AssetCode", oDBParameter, out objStatus);
oDBAccess.CloseConnection(false);
if (objStatus != null)
{
nStatus = Convert.ToInt32(objStatus);
}
if (nStatus <= 0)
{
oDBAccess.RollBack();
oDBAccess.CloseConnection(true);
return(nStatus);
}
if (nStatus == 2)
{
oDBAccess.RollBack();
oDBAccess.CloseConnection(true);
return(nStatus);
}
oDBAccess.Commit();
//oDBAccess.CloseConnection(true);
}
catch (Exception ex)
{
oDBAccess.RollBack();
MessageBox.Show("Error: " + ex.ToString(), clsGlobal._sMessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
if (oDBAccess != null)
{
oDBAccess.Dispose();
oDBAccess = null;
}
if (oDBParameter != null)
{
oDBParameter.Dispose();
oDBParameter = null;
}
}
return(nStatus);
}
public Int64 InsertUpdateAsset(bool bIsSaveAsset_Code = true)
{
Int64 nAssetID = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
Object objValue = null;
Object objStatus = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nAssetID", this.nAssetID, ParameterDirection.InputOutput, SqlDbType.BigInt);
oDBParameter.Add("@nCompanyID", this.nCompanyID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nAssetMainTypeID", this.nAssetMainTypeID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nAssetTypeID", this.nAssetTypeID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nAssetTypeOneID", this.nAssetTypeOneID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nAssetMaterialID", this.nAssetMaterialID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nAssetVendorID", this.nAssetVendorID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nDensityID", this.nDensityID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nColorID", this.nColorID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@sHSNCode", this.sHSNCode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sAssetName", this.sAssetName, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sAssetAbbrivation", this.sAssetAbbrivation, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sDescription", this.sAssetDescription, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@dtIntroductionDate", this.dtIntroductionDate, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@dtReorderDate", this.dtReorderDate, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@sReorderDays", this.sReorderDays, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sReorderQuntity", this.sReorderQuntity, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sRate", this.sAssetRate, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sMake", this.sAssetMake, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sSizeOrCapacity", this.sAssetSizeOrCapacity, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sQuality", this.sAssetQuality, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sDimention", this.sAssetDimention, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sWeight", this.sAssetWeight, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sWattage", this.sWattage, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sSpan", this.sSpan, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sAttachment", this.sAttachment, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sAttachmentName", this.sAttachmentName, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sLength", this.sLength, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCoreOrPole", this.sCoreOrPole, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sAmps", this.sAmps, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPlug", this.sPlug, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPower", this.sPower, ParameterDirection.Input, SqlDbType.VarChar);
oDBAccess.OpenConnection(true);
oDBAccess.Execute("lgsp_INUP_AssetMaster", oDBParameter, out objValue);
if (objValue != null)
{
nAssetID = Convert.ToInt64(objValue);
}
if (nAssetID == 0)
{
oDBAccess.RollBack();
oDBAccess.CloseConnection(true);
return(nAssetID);
}
if (nAssetID != 0)
{
foreach (AssetCode item in lstAssetCode)
{
oDBParameter.clear();
oDBParameter.Add("@nAssetID", nAssetID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nAssetCodeID", item.nAssetCodeID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@sInitialCode", item.sInitialCode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@nSequenceNo", item.nSequenceNo, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@sUniqueCode", item.sUniqueCode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@barcode", item.barcode, ParameterDirection.Input, SqlDbType.Image);
oDBParameter.Add("@dtShelfLife", item.dtShelfLife, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@sShelfLifeUnit", item.sShelfLifeUnit, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@dtRetirementDate", item.dtRetirementDate, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@nStatus", 0, ParameterDirection.InputOutput, SqlDbType.Int);
oDBAccess.Execute("lgsp_INUP_AssetCode", oDBParameter, out objStatus);
int nStatus = 0;
if (objValue != null)
{
nStatus = Convert.ToInt32(objStatus);
}
if (nStatus <= 0)
{
oDBAccess.RollBack();
oDBAccess.CloseConnection(true);
return(nStatus);
}
if (nStatus == 2)
{
oDBAccess.RollBack();
oDBAccess.CloseConnection(true);
return(nStatus);
}
}
}
oDBAccess.Commit();
//oDBAccess.CloseConnection(true);
}
catch (Exception ex)
{
oDBAccess.RollBack();
MessageBox.Show("Error: " + ex.ToString(), clsGlobal._sMessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
if (oDBAccess != null)
{
oDBAccess.Dispose();
oDBAccess = null;
}
if (oDBParameter != null)
{
oDBParameter.Dispose();
oDBParameter = null;
}
}
return(nAssetID);
}
public Int64 InsertUpdateCompanyMaster()
{
Int64 _nCompanyID = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
Object objValue = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nCompanyID", this.nCompanyID, ParameterDirection.InputOutput, SqlDbType.BigInt);
oDBParameter.Add("@sCompanyName", this.sCompanyName, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompanyCode", this.sCompanyCode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompAbbrivation", this.sCompAbbrivation, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@nCompanyTypeID", this.nCompanyTypeID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@sCompanySignatory", this.sCompSignatoryID, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompAddressLine1", this.sCompAddressLine1, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompAddressLine2", this.sCompAddressLine2, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompCity", this.sCompCity, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompState", this.sCompState, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompCountry", this.sCompCountry, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompPincode", this.sCompPincode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompEmail", this.sCompEmail, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompWebsite", this.sCompWebsite, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompAllPhoneNo", this.sCompAllPhoneNo, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompFax", this.sCompFax, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompHSN_SACCode", this.sCompHSN_SACCode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompGSTNo", this.sCompGSTNo, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sCompPANNo", this.sCompPANNo, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@dtCompanyFormedOn", this.dtCompanyFormedDate, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@sTransporterID", this.sTransporterID, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sTransDocumentDate", this.sTransDocumentDate, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sTransDocumentName", this.sTransDocumentName, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sTransDocumentNumber", this.sTransDocumentNumber, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sWHAddressLine1", this.sWHAddressLine1, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sWHAddressLine2", this.sWHAddressLine2, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sWHCity", this.sWHCity, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sWHState", this.sWHState, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sWHCountry", this.sWHCountry, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sWHPincode", this.sWHPincode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@nWHSupervisorID", this.nWHSupervisorID, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sWHAllPhoneNo", this.sWHAllPhoneNo, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@imgCompHeader", this.imgCompHeader, ParameterDirection.Input, SqlDbType.Image);
oDBParameter.Add("@imgCompFooter", this.imgCompFooter, ParameterDirection.Input, SqlDbType.Image);
oDBParameter.Add("@imgTerms_Condition", this.imgTerms_Condition, ParameterDirection.Input, SqlDbType.Image);
oDBParameter.Add("@sTerms_Condition", this.sTerms_Condition, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@nTerms_ConditionType", this.nTerms_ConditionType, ParameterDirection.Input, SqlDbType.Int);
oDBParameter.Add("@nTransportationID", this.nCompTransportID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nWarehouseID", this.nCompWarehouseID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nImageID", this.nCompImageID, ParameterDirection.Input, SqlDbType.BigInt);
oDBAccess.OpenConnection(false);
oDBAccess.Execute("lgsp_INUP_CompanyMasters", oDBParameter, out objValue);
oDBAccess.CloseConnection(false);
if (objValue != null)
{
_nCompanyID = Convert.ToInt64(objValue);
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.ToString(), clsGlobal._sMessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
if (oDBAccess != null)
{
oDBAccess.Dispose();
oDBAccess = null;
}
if (oDBParameter != null)
{
oDBParameter.Dispose();
oDBParameter = null;
}
}
return(_nCompanyID);
}
