public void UpdateCaseStatus(string status, int caseId, string DocName)
{
_objSPNames = new SPNames();
DataSet ds = new DataSet();
try
{
SqlTransaction sqlTrans;
SqlCommand cmdPtabDownloadStatus;
m_sConnectionString = ConfigurationManager.AppSettings["LitigationConnectionString"];
using (SqlConnection cnnPtabCase = new SqlConnection(m_sConnectionString))
{
cnnPtabCase.Open();
//changed the stored procedure name
using (cmdPtabDownloadStatus = new SqlCommand("usp_update_PTAB_Download_Status_test", cnnPtabCase))
{
cmdPtabDownloadStatus.CommandType = CommandType.StoredProcedure;
cmdPtabDownloadStatus.Parameters.AddWithValue("@caseId", caseId);
cmdPtabDownloadStatus.Parameters.AddWithValue("@docname", DocName);
cmdPtabDownloadStatus.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveFileName(string CaseNo, string FileName, string Type, string ExibitNo)
{
_objSPNames = new SPNames();
try
{
SqlTransaction sqlTrans;
SqlCommand cmdPtabCaseDetails;
m_sConnectionString = ConfigurationManager.AppSettings["LitigationConnectionString"];
using (SqlConnection cnnUpdatePtabCase = new SqlConnection(m_sConnectionString))
{
cnnUpdatePtabCase.Open();
using (sqlTrans = cnnUpdatePtabCase.BeginTransaction())
{
try
{
using (cmdPtabCaseDetails = new SqlCommand(_objSPNames.PTABFileNameSave, cnnUpdatePtabCase, sqlTrans))
{
cmdPtabCaseDetails.CommandType = CommandType.StoredProcedure;
cmdPtabCaseDetails.Parameters.AddWithValue("@pCaseNumber", CheckDBNull(CaseNo));
cmdPtabCaseDetails.Parameters.AddWithValue("@pFileName", CheckDBNull(FileName));
cmdPtabCaseDetails.Parameters.AddWithValue("@pType", CheckDBNull(Type));
cmdPtabCaseDetails.Parameters.AddWithValue("@pExibitNumber", CheckDBNull(ExibitNo));
cmdPtabCaseDetails.ExecuteNonQuery();
sqlTrans.Commit();
}
}
catch (Exception ex)
{
sqlTrans.Rollback();
}
}
}
}
catch (Exception ex)
{
// InsertLog.WriteToFile("Error in connection to server. " + ex.Message);
int linenum = new System.Diagnostics.StackTrace(ex, true).GetFrame(0).GetFileLineNumber();
LogFile.WriteToFile("Error Line :" + linenum + "-" + ex.Message); // Log
}
}
public DataSet GetCaseNUmberforDownload(int Mode)
{
_objSPNames = new SPNames();
DataSet ds = new DataSet();
try
{
SqlTransaction sqlTrans;
SqlCommand cmdPtabCaseDetails;
m_sConnectionString = ConfigurationManager.AppSettings["LitigationConnectionString"];
using (SqlConnection cnnPtabCase = new SqlConnection(m_sConnectionString))
{
cnnPtabCase.Open();
using (sqlTrans = cnnPtabCase.BeginTransaction())
{
try
{
string sp_name = ConfigurationManager.AppSettings["GetCaseDetailsProc"].ToString();;
using (cmdPtabCaseDetails = new SqlCommand(sp_name, cnnPtabCase, sqlTrans))
{
cmdPtabCaseDetails.CommandType = CommandType.StoredProcedure;
//cmdPtabCaseDetails.Parameters.AddWithValue("@Mode", Mode);
SqlDataAdapter sqdaa = new SqlDataAdapter(cmdPtabCaseDetails);
sqdaa.Fill(ds);
}
}
catch (Exception ex)
{
sqlTrans.Rollback();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(ds);
}
public int CheckISDoc_Lock(string caseno, string caseID)
{
_objSPNames = new SPNames();
int ds = 0;
try
{
SqlTransaction sqlTrans;
SqlCommand cmdPtabCaseDetails;
m_sConnectionString = ConfigurationManager.AppSettings["LitigationConnectionString"];
using (SqlConnection cnnPtabCase = new SqlConnection(m_sConnectionString))
{
cnnPtabCase.Open();
using (sqlTrans = cnnPtabCase.BeginTransaction())
{
try
{
using (cmdPtabCaseDetails = new SqlCommand("usp_ptab_CheckDoc_log", cnnPtabCase, sqlTrans))
{
cmdPtabCaseDetails.CommandType = CommandType.StoredProcedure;
cmdPtabCaseDetails.Parameters.AddWithValue("@Value", CheckDBNull(caseno));
cmdPtabCaseDetails.Parameters.AddWithValue("@Caseid", caseID);
ds = Convert.ToInt32(cmdPtabCaseDetails.ExecuteScalar());
sqlTrans.Commit();
}
}
catch (Exception)
{
sqlTrans.Rollback();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(ds);
}