public DataSet GetLocationMaster()
{
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
DataSet _dsCompanyMaster = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBAccess.OpenConnection(false);
oDBAccess.Retrive("lgsp_Get_CSCMasterData", out _dsCompanyMaster);
oDBAccess.CloseConnection(false);
}
catch (Exception ex)
{
oDBAccess.CloseConnection(false);
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(_dsCompanyMaster);
}
public Int64 GetDeleteMasterType(int nMasterType, Int64 nID)
{
Int64 nSequencNo = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
DataTable _dt = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nMasterType", nMasterType, ParameterDirection.Input, SqlDbType.Int);
oDBParameter.Add("@nID", nID, ParameterDirection.Input, SqlDbType.BigInt);
oDBAccess.OpenConnection(false);
oDBAccess.Retrive("lgsp_Delete_MasterType", oDBParameter, out _dt);
oDBAccess.CloseConnection(false);
if (_dt != null && _dt.Rows.Count > 0)
{
nSequencNo = Convert.ToInt64(_dt.Rows[0][0]);
}
}
catch (Exception ex)
{
oDBAccess.CloseConnection(false);
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(nSequencNo);
}
public DataTable GetAssetCode()
{
DatabaseAccess oDBAccess = null;
DataTable dtAssetCode = null;
//DatabaseParameters oDBParameter = 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.Retrive("lgsp_Get_AllNotUsedAsset", out dtAssetCode);
oDBAccess.CloseConnection(false);
}
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;
}
}
return(dtAssetCode);
}
public Int64 GetSequenceNumber_Transaction(TransactionType oTransactionType)
{
Int64 nSequencNo = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
DataTable _dt = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nTransactionType", oTransactionType.GetHashCode(), ParameterDirection.Input, SqlDbType.Int);
oDBAccess.OpenConnection(false);
oDBAccess.Retrive("lgsp_Get_SequenceNoTransaction", oDBParameter, out _dt);
oDBAccess.CloseConnection(false);
if (_dt != null && _dt.Rows.Count > 0)
{
nSequencNo = Convert.ToInt64(_dt.Rows[0][0]);
}
}
catch (Exception ex)
{
oDBAccess.CloseConnection(false);
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(nSequencNo);
}
public DataTable GetLocationInformation(Int64 nLocationID)
{
DataSet ds = null;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
DataTable _dt = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nLocationID", nLocationID, ParameterDirection.Input, SqlDbType.BigInt);
oDBAccess.OpenConnection(false);
oDBAccess.Retrive("lgsp_Get_LocationDetails", oDBParameter, out _dt);
oDBAccess.CloseConnection(false);
}
catch (Exception ex)
{
oDBAccess.CloseConnection(false);
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(_dt);
}
public DataTable GetMasterTypeDataBbValue(Int32 nMasterType, string sSearchString = "")
{
DataTable dt = null;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nMasterType", nMasterType, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@sSearchString", sSearchString, ParameterDirection.Input, SqlDbType.VarChar);
oDBAccess.OpenConnection(false);
oDBAccess.Retrive("lgsp_Get_AllMastersData_Search", oDBParameter, out dt);
oDBAccess.CloseConnection(false);
}
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(dt);
}
public DataTable GetKitAssetList(Int64 nKitID = 0)
{
DataTable dt = null;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nKitID", nKitID, ParameterDirection.Input, SqlDbType.BigInt);
oDBAccess.OpenConnection(false);
oDBAccess.Retrive("lgsp_Get_KitAssetList", oDBParameter, out dt);
oDBAccess.CloseConnection(false);
}
catch (Exception ex)
{
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(dt);
}
public DataSet GetAllMasterData_ByMainType(Int64 nAssetMainType)
{
DataSet ds = null;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nAssetType", nAssetMainType, ParameterDirection.Input, SqlDbType.BigInt);
oDBAccess.OpenConnection(false);
oDBAccess.Retrive("lgsp_Get_AssetMasterData_ByMainType", oDBParameter, out ds);
oDBAccess.CloseConnection(false);
}
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(ds);
}
public DataTable GetListData(string sListType)
{
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
DataTable _dt = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@sListType", sListType, ParameterDirection.Input, SqlDbType.VarChar);
oDBAccess.OpenConnection(false);
oDBAccess.Retrive("lgsp_Get_ListData", oDBParameter, out _dt);
oDBAccess.CloseConnection(false);
}
catch (Exception ex)
{
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(_dt);
}
public DataTable GetAssetMainMasterType(Int32 nAssetType = 0)
{
DataTable dt = null;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nAssetType", nAssetType, ParameterDirection.Input, SqlDbType.VarChar);
oDBAccess.OpenConnection(false);
oDBAccess.Retrive("lgsp_getAssetMasterList", oDBParameter, out dt);
oDBAccess.CloseConnection(false);
}
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(dt);
}
