public static bool IsInstantPeriodicIntervalModified()
{
SqlParameter[] sqlparams = null;
try
{
sqlparams = new SqlParameter[1];
sqlparams[0] = new SqlParameter();
sqlparams[0].ParameterName = "@IsModified";
sqlparams[0].Direction = ParameterDirection.Output;
sqlparams[0].SqlDbType = SqlDbType.Bit;
SqlHelper.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "rsp_IsInstantPeriodicIntervalModified", (SqlParameter[])sqlparams);
if (sqlparams[0].Value != DBNull.Value)
{
bool value = false;
bool.TryParse(sqlparams[0].Value.ToString(), out value);
return(value);
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(false);
}
public static void UpdatePendingRecords()
{
try
{
DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateInProgressVerificationRecords");
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
}
//1
public static void InsertVLTDetails()
{
try
{
SqlHelper.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_insertAAMSVerification");
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
//6
public static void ResetAAMSVerificationRecords()
{
try
{
SqlHelper.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_ResetAAMSVerificationRecords");
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
public static DataTable GetUnprocessedMC300VerDetails()
{
try
{
return(SqlHelper.ExecuteDataset(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "rsp_GetUnprocessedMC300VerificationRecords").Tables[0]);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return(new DataTable());
}
}
public static DataTable GetInstallationDetailsForPortBlocking()
{
try
{
return(SqlHelper.ExecuteDataset(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "rsp_GetInstallationDetailsForPortBlocking").Tables[0]);
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
return(new DataTable());
}
}
public static DataTable GetInstallationsToUpdateOptionFileParams()
{
try
{
return(SqlHelper.ExecuteDataset(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "rsp_GetInstallationsToUpdateOptionFileParams").Tables[0]);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return(new DataTable());
}
}
public static DataTable GetActiveMachinesForCompVerification()
{
try
{
return(SqlHelper.ExecuteDataset(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "rsp_GetActiveMachinesForComponentVerification").Tables[0]);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return(new DataTable());
}
}
public static void UpdateAAMSVerification(int ReferenceID, int IH_Status)
{
try
{
DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateAAMSIHVerification",
DataBaseServiceHandler.AddParameter <int>("@Reference_ID", DbType.Int32, ReferenceID),
DataBaseServiceHandler.AddParameter <int>("@IH_Status", DbType.Int32, IH_Status));
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
}
public static DataTable GetInstallationsForInstantPeriodicInterval()
{
try
{
return(SqlHelper.ExecuteDataset(DBBuilder.GetConnectionString(),
CommandType.StoredProcedure, "rsp_GetInstallationsForInstantPeriodicInterval").Tables[0]);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return(new DataTable());
}
}
public static DataTable GetNoSyncInstallations(char syncStatus)
{
SqlParameter[] sqlparam = new SqlParameter[1];
sqlparam[0] = new SqlParameter("@SyncStatus", syncStatus);
try
{
return(SqlHelper.ExecuteDataset(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "rsp_GetNoSyncInstallations", sqlparam).Tables[0]);
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
return(new DataTable());
}
}
public static void UpdateDailyVerificationData(string strSerialNo)
{
try
{
SqlParameter[] sqlparam = new SqlParameter[1];
sqlparam[0] = new SqlParameter("@SerialNo", strSerialNo);
SqlHelper.ExecuteNonQuery(DBBuilder.GetConnectionString(), "usp_UpdateDailyComponentVerificationData", sqlparam);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
public static void UpdateLP21Status(int ReferenceID, string Command, string UpdateType)
{
try
{
DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateLP21Status",
DataBaseServiceHandler.AddParameter <int>("@Reference_ID", DbType.Int32, ReferenceID),
DataBaseServiceHandler.AddParameter <string>("@EntityCommand", DbType.String, Command),
DataBaseServiceHandler.AddParameter <string>("@UpdateType", DbType.String, UpdateType));
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
}
public static DataTable GetComponentTypes(int iInstallationID)
{
try
{
SqlParameter[] sqlparam = new SqlParameter[1];
sqlparam[0] = new SqlParameter("@iInstallationID", iInstallationID);
return(SqlHelper.ExecuteDataset(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "rsp_GetComponentTypesForCompDetailsRequest", sqlparam).Tables[0]);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return(new DataTable());
}
}
public static bool SyncInstallationStatus(int Installation_No, char syncStatus)
{
try
{
DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_SyncInstallationStatus",
DataBaseServiceHandler.AddParameter <int>("@Installation_No", DbType.Int32, Installation_No), DataBaseServiceHandler.AddParameter <char>("@SyncStatus", DbType.String, syncStatus));
return(true);
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
return(false);
}
}
public static bool UpdateB5ReqStatus(int RefID)
{
try
{
DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateB5ReqStatus",
DataBaseServiceHandler.AddParameter <int>("@BAD_ID", DbType.Int32, RefID));
return(true);
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
return(false);
}
}
public static void InsertExportHistory(string Type, string Reference)
{
try
{
DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_Export_History",
DataBaseServiceHandler.AddParameter <string>("@Reference1", DbType.String, Reference),
DataBaseServiceHandler.AddParameter <string>("@Reference2", DbType.String, ""),
DataBaseServiceHandler.AddParameter <string>("@Type", DbType.String, Type),
DataBaseServiceHandler.AddParameter <string>("@Status", DbType.String, ""));
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
}
public static bool UpdatePortDisabledStatusForPortBlocking(int installationNo)
{
try
{
DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdatePortDisabledStatus",
DataBaseServiceHandler.AddParameter <int>("@InstallationNo", DbType.Int32, installationNo));
return(true);
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
return(false);
}
}
//7
public static bool UpdateLastRuninSetting(string date)
{
SqlParameter[] sqlparam = new SqlParameter[1];
sqlparam[0] = new SqlParameter("@date", date.ToString());
try
{
SqlHelper.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateLastRuninSetting", sqlparam);
return(true);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return(false);
}
}
//5
public static bool UpdateAAMSVerificationStatus(int IHID, int Status)
{
SqlParameter[] sqlparam = new SqlParameter[2];
sqlparam[0] = new SqlParameter("@IH_ID", IHID);
sqlparam[1] = new SqlParameter("@IH_Status", Status);
try
{
SqlHelper.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateAAMSVerificationStatus", sqlparam);
return(true);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return(false);
}
}
//4
public static string GetVLTDetailsinXML(string Serial, string MessageAAMSID)
{
SqlParameter[] sqlparam = new SqlParameter[3];
sqlparam[0] = new SqlParameter("@Serial", Serial);
sqlparam[1] = new SqlParameter("@MessageAAMSID", MessageAAMSID);
sqlparam[2] = new SqlParameter("@Type", "");
try
{
return(SqlHelper.ExecuteScalar(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "rsp_GetVLTDetailsinXML", sqlparam).ToString());
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return(string.Empty);
}
}
public static bool UpdateGMUSiteCodeStatus(int iInstallationNo, int iStatus)
{
try
{
SqlParameter[] sqlparam = new SqlParameter[2];
sqlparam[0] = new SqlParameter("@InstallationNo", iInstallationNo);
sqlparam[1] = new SqlParameter("@Status", iStatus);
SqlHelper.ExecuteNonQuery(DBBuilder.GetConnectionString(), "usp_UpdateGMUSiteCodeStatus", sqlparam);
return(true);
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
return(false);
}
}
public static bool UpdateInstallationcRC(int Installation_No, string cRC)
{
try
{
var output = DataBaseServiceHandler.AddParameter <bool>("@Out", DbType.Boolean, false);
DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateInstallationcRC",
DataBaseServiceHandler.AddParameter <int>("@Installation_No", DbType.Int32, Installation_No),
DataBaseServiceHandler.AddParameter <string>("@cRC", DbType.String, cRC), output);
return(Convert.ToBoolean(output.Value));
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
return(false);
}
}
public static void UpdateSector203(int Installation_No, string cRC, string updateType)
{
try
{
//var output = DataBaseServiceHandler.AddParameter<bool>("@Verified", DbType.Boolean, false);
DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateSector203UpdateforCRC",
DataBaseServiceHandler.AddParameter <int>("@Installation_No", DbType.Int32, Installation_No),
DataBaseServiceHandler.AddParameter <string>("@cRC", DbType.String, cRC),
DataBaseServiceHandler.AddParameter <string>("@UpdateType", DbType.String, updateType));
//return Convert.ToBoolean(output.Value);
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
//return false;
}
}
public static string UpdateComponentRequestedStatus(string strSerialNo)
{
try
{
SqlParameter[] sqlparam = new SqlParameter[2];
sqlparam[0] = new SqlParameter("@SerialNo", strSerialNo);
SqlParameter param = new SqlParameter();
param.DbType = DbType.String;
param.Direction = ParameterDirection.Output;
param.TypeName = "@Status";
sqlparam[1] = param;
SqlHelper.ExecuteDataset(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateComponentRequestedData");
return(sqlparam[1].Value.ToString());
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return(string.Empty);
}
}
public static string UpdateComponentData(int iInstallationNo, int iCompIndex)
{
try
{
SqlParameter[] sqlparam = new SqlParameter[3];
sqlparam[0] = new SqlParameter("@InstallationID", iInstallationNo);
sqlparam[1] = new SqlParameter("@ComponentID", iCompIndex);
SqlParameter param = new SqlParameter();
param.DbType = DbType.Int32;
param.Direction = ParameterDirection.Output;
param.TypeName = "@Status";
sqlparam[2] = param;
SqlHelper.ExecuteNonQuery(DBBuilder.GetConnectionString(), "usp_UpdateComponentVerificationData", sqlparam);
return(sqlparam[2].Value.ToString());
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return(string.Empty);
}
}