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 InsertUpdateGafferMaster()
{
Int64 _nGafferID = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
Object objValue = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nGafferID", this.nGafferID, ParameterDirection.InputOutput, SqlDbType.BigInt);
oDBParameter.Add("@sGafferCode", this.sGafferCode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sGafferName", this.sGafferName, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sGafferAbbrivation", this.sGafferAbbrivation, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sGender", this.sGafferGender, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@dtDOB", this.dtGafferDOB, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@sAge", this.sGafferAge, ParameterDirection.Input, SqlDbType.VarChar);
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("@sAllPhoneNo", this.sAllPhoneNo, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sUserName", this.sUserName, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPassword", this.sPassword, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPin", this.sPin, ParameterDirection.Input, SqlDbType.VarChar);
oDBAccess.OpenConnection(false);
oDBAccess.Execute("lgsp_INUP_GafferMaster", oDBParameter, out objValue);
oDBAccess.CloseConnection(false);
if (objValue != null)
{
_nGafferID = 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(_nGafferID);
}
public Int64 InsertUpdateMaster()
{
Int64 nMasterID = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
Object objValue = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nMasterID", this.nMasterID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@sMasterName", this.sMasterName, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sMasterCode", this.sMasterCode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@nMasterMainID", this.nMasterMainID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nMasterType", this.MasterType.GetHashCode(), ParameterDirection.Input, SqlDbType.Int);
oDBParameter.Add("@bIsAllowAccess", this.IsAllowAccess, ParameterDirection.Input, SqlDbType.Bit);
oDBParameter.Add("@bIsAllowSignatory", this.IsAllowSignatory, ParameterDirection.Input, SqlDbType.Bit);
oDBParameter.Add("@nReturnID", 0, ParameterDirection.InputOutput, SqlDbType.Int);
oDBAccess.OpenConnection(false);
oDBAccess.Execute("lgsp_INUP_Masters", oDBParameter, out objValue);
oDBAccess.CloseConnection(false);
if (objValue != null)
{
nMasterID = Convert.ToInt64(objValue);
}
}
catch (Exception ex)
{
oDBAccess.CloseConnection(false);
nMasterID = -1;
throw 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(nMasterID);
}
public Int64 InsertUpdateLocationMaster()
{
Int64 _nLocationID = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
Object objValue = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nLocationID", this.nLocationID, ParameterDirection.InputOutput, SqlDbType.BigInt);
oDBParameter.Add("@sDescription", this.sDescription, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sLocationCode", this.sLocationCode, ParameterDirection.Input, SqlDbType.VarChar);
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("@sVillageDistTown", this.sVillageDistTown, ParameterDirection.Input, SqlDbType.VarChar);
oDBAccess.OpenConnection(false);
oDBAccess.Execute("lgsp_INUP_LocationMaster", oDBParameter, out objValue);
oDBAccess.CloseConnection(false);
if (objValue != null)
{
_nLocationID = 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(_nLocationID);
}
public int DeleteMaster()
{
int nMasterID = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
Object objValue = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nMasterID", this.nMasterID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nMasterType", this.MasterType.GetHashCode(), ParameterDirection.Input, SqlDbType.Int);
oDBParameter.Add("@nReturnID", 0, ParameterDirection.InputOutput, SqlDbType.Int);
oDBAccess.OpenConnection(false);
oDBAccess.Execute("lgsp_Delete_Masters", oDBParameter, out objValue);
oDBAccess.CloseConnection(false);
if (objValue != null)
{
nMasterID = Convert.ToInt32(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(nMasterID);
}
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 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 Int32 DeleteKitAsset()
{
Int32 nRow = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nKitAssetID", this.nKitAssetID, ParameterDirection.Input, SqlDbType.BigInt);
oDBAccess.OpenConnection(false);
nRow = oDBAccess.Execute("lgsp_Delete_KitAsset", oDBParameter);
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(nRow);
}
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 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);
}
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 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 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);
}
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 InsertUpdateStaffMaster()
{
Int64 _nStaffID = 0;
DatabaseAccess oDBAccess = null;
DatabaseParameters oDBParameter = null;
Object objValue = null;
try
{
oDBAccess = new DatabaseAccess();
oDBParameter = new DatabaseParameters();
oDBParameter.clear();
oDBParameter.Add("@nStaffID", this.nStaffID, ParameterDirection.InputOutput, SqlDbType.BigInt);
oDBParameter.Add("@nDesignationID", this.nDesignationID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@nCompanyID", this.nCompanyID, ParameterDirection.Input, SqlDbType.BigInt);
oDBParameter.Add("@sStaffCode", this.sStaffCode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sStaffName", this.sStaffName, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sStaffAbbrivation", this.sStaffAbbrivation, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@dtDOB", this.dtDOB, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@sAge", this.sAge, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sGender", this.sGender, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPhoneNo", this.sPhoneNo, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPermanentAddressLine1", this.sPermanentAddressLine1, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPermanentAddressLine2", this.sPermanentAddressLine2, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPermanentPincode", this.sPermanentPincode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPermanentDistTown", this.sPermanentDistTown, ParameterDirection.Input, SqlDbType.VarChar);
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("@sCountry", this.sCountry, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPincode", this.sPincode, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sEmail", this.sEmail, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@dtDOJ", this.dtDOJ, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@sGSTNNo", this.sGSTNNo, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPANNo", this.sPANNo, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sAadharNo", this.sAadharNo, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sReferenceBy", this.sReferenceBy, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sAllergies", this.sAllergies, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sBloodGroup", this.sBloodGroup, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sWorkingSince", this.sWorkingSince, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sSalary", this.sSalary, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sDailyWages", this.sDailyWages, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sUnionID", this.sUnionID, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@dtUnionIDRenewalDate", this.dtUnionIDRenewalDate, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@sFirstLicenseNumber", this.sFirstLicenseNumber, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@dtFirstLicenseRenewalDate", this.dtFirstLicenseRenewalDate, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@sSecondLicenseNumber", this.sSecondLicenseNumber, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@dtSecondLicenseRenewalDate", this.dtSecondLicenseRenewalDate, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@sThirdLicenseNumber", this.sThirdLicenseNumber, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@dtThirdLicenseRenewalDate", this.dtThirdLicenseRenewalDate, ParameterDirection.Input, SqlDbType.DateTime);
oDBParameter.Add("@imgPhoto", this.imgPhoto, ParameterDirection.Input, SqlDbType.Image);
oDBParameter.Add("@bIsAllowAccess", this.bIsAllowAccess, ParameterDirection.Input, SqlDbType.Bit);
oDBParameter.Add("@sUserName", this.sUserName, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPin", this.sPin, ParameterDirection.Input, SqlDbType.VarChar);
oDBParameter.Add("@sPassword", this.sPassword, ParameterDirection.Input, SqlDbType.VarChar);
oDBAccess.OpenConnection(false);
oDBAccess.Execute("lgsp_INUP_CompanyStaff", oDBParameter, out objValue);
oDBAccess.CloseConnection(false);
if (objValue != null)
{
_nStaffID = 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(_nStaffID);
}
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);
}