public DataTable getSIGSearch(SIGCodes sigInfo)
{
SqlConnection con = new SqlConnection(ConStr);
DataTable dtable = new DataTable();
try
{
SqlCommand sqlCmd = new SqlCommand("select * from SIG_Codes where SIG_Code = '" + sigInfo.SIGCode + "'", con);
SqlDataReader sqlDr;
// DataRow dr;
con.Open();
sqlDr = sqlCmd.ExecuteReader();
dtable.Load(sqlDr);
}
catch (Exception ex)
{
throw new Exception("**Problem occurred with Searching SIGCode", ex);
}
finally
{
con.Close();
}
return dtable;
}
public string Delete_SIGCodes(SIGCodes sig,string userID)
{
string msg = string.Empty;
SqlConnection con = new SqlConnection(ConStr);
try
{
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = con;
sqlCmd.CommandText = "sp_delete_SIGCodes";
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter pSIG_ID = sqlCmd.Parameters.Add("@SIGID", SqlDbType.Int);
pSIG_ID.Value = sig.SIG_ID;
SqlParameter pUserID = sqlCmd.Parameters.Add("@UserID", SqlDbType.VarChar, 20);
pUserID.Value = userID;
con.Open();
sqlCmd.ExecuteNonQuery();
msg = "SIG Code Deleted Successfully...";
}
catch (SqlException SqlEx)
{
objNLog.Error("SQLException : " + SqlEx.Message);
throw new Exception("Exception re-Raised from DL with SQLError# " + SqlEx.Number + " while Inserting SIG Code.", SqlEx);
}
catch (Exception ex)
{
objNLog.Error("Exception : " + ex.Message);
throw new Exception("**Problem occured with Deleting SIG Code", ex);
}
finally
{
con.Close();
}
return msg;
}
public string Ins_SIGCodes(SIGCodes sig,string userID)
{
string msg = string.Empty;
SqlConnection con = new SqlConnection(ConStr);
try
{
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = con;
sqlCmd.CommandText = "sp_set_SIGCodes";
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter pSIGCode = sqlCmd.Parameters.Add("@SIGCode", SqlDbType.VarChar, 10);
pSIGCode.Value = sig.SIGCode;
SqlParameter pSIGName = sqlCmd.Parameters.Add("@SIGName", SqlDbType.VarChar, 50);
pSIGName.Value = sig.SIGName;
SqlParameter pSIGFactor = sqlCmd.Parameters.Add("@SIGFactor", SqlDbType.Float);
if (sig.SIGFactor != "")
pSIGFactor.Value = float.Parse(sig.SIGFactor);
else
pSIGFactor.Value = Convert.DBNull;
SqlParameter pUserID = sqlCmd.Parameters.Add("@UserID", SqlDbType.VarChar, 20);
pUserID.Value = userID;
con.Open();
sqlCmd.ExecuteNonQuery();
msg = "SIG Code Inserted Successfully...";
}
catch (SqlException SqlEx)
{
objNLog.Error("SQLException : " + SqlEx.Message);
throw new Exception("Exception re-Raised from DL with SQLError# " + SqlEx.Number + " while Inserting SIG Code.", SqlEx);
}
catch (Exception ex)
{
objNLog.Error("Exception : " + ex.Message);
throw new Exception("**Error occured while Inserting SIG Code.", ex);
}
finally
{
con.Close();
}
return msg;
}
