/// <summary>
/// Get list of all local waiver status
/// </summary>
/// <returns></returns>
internal List<WaiverStatusLatest> getWaiverStatusLocal( )
{
List<WaiverStatusLatest> def = new List<WaiverStatusLatest>();
List<WaiverStatusLatest> allWaiverStatus = new List<WaiverStatusLatest>();
string sql = "select * from WAIVER_STATUS ";
using (MedMidsContext db = new MedMidsContext())
{
var data = db.Database.SqlQuery<WaiverStatusLatest>(sql);
if (data.Count() == 0)
{
WaiverStatusLatest wsl = new WaiverStatusLatest();
def.Add(wsl);
return def;
}
allWaiverStatus = data.ToList();
}
// List<WaiverStatusLatest> allWaiverStatus = data.ToList();
String spname="pkg_mm_waivers.get_error_waivers";
ParameterDirection pout = ParameterDirection.Output;
using (var conn = new OracleConnection(dbConn) )
using (var command = new OracleCommand(spname,conn)
{
CommandType=CommandType.StoredProcedure
})
{
OracleParameter[] parameters = new OracleParameter[2];
parameters[0] = new OracleParameter();
parameters[0].ParameterName = "P_CUR";
parameters[0].OracleDbType = OracleDbType.RefCursor;
parameters[0].Direction = pout;
parameters[1] = new OracleParameter();
parameters[1].ParameterName = "P_ERRM";
parameters[1].OracleDbType = OracleDbType.Varchar2;
parameters[1].Direction = pout;
command.Parameters.AddRange(parameters);
conn.Open();
OracleDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var wsId = reader["WAIVER_STATUS_ID"];
foreach (WaiverStatusLatest wsl in allWaiverStatus)
{
if (wsl.Waiver_Status_Id == Convert.ToInt64(wsId))
{
wsl.waiverError = 1;
}
// def.Add(wsl);
}
}
logger.Debug(allWaiverStatus.Count());
return allWaiverStatus;
// if (def.Count > 0) {
// return allWaiverStatus;
// }else {
// return data.ToList();
// }
}
//return data.ToList();
}
/// <summary>
///
/// </summary>
/// <param name="wfd"></param>
/// <returns></returns>
private string buildWaiverSetby(WaiverFinalDecision wfd, Int64 setBy, WaiverStatusLatest currentStatus,long uid)
{
string setby_user = this.getUserNameById(uid);
StringBuilder sb = new StringBuilder("update WAIVER_STATUS set ");
//RL
if (!string.IsNullOrEmpty(wfd.rl) && !wfd.rl.Equals(currentStatus.rl) )
{
sb.Append("rl='" + wfd.rl + "', rl_setby=" + setBy + ", dt_rl=sysdate ,rl_sb_userid='" + setby_user + "' ");
addActionLog(uid, currentStatus.case_Id, "Updating WW rl Status for " +currentStatus.midn_Id+" : "+wfd.rl , "WAIVER STATUS", currentStatus.midn_Id);
}
else if (string.IsNullOrEmpty(wfd.rl) && !isSameNullEmpty(wfd.rl,currentStatus.rl) )// !wfd.rl.Equals(currentStatus.rl))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" rl=null, rl_setby=null, dt_rl=sysdate , rl_sb_userid=null ");
addActionLog(uid, currentStatus.case_Id, "Clearing rl Status for " + currentStatus.midn_Id + " : " + wfd.rl, "WAIVER STATUS", currentStatus.midn_Id);
}
//UL
if (!string.IsNullOrEmpty(wfd.ul) && !wfd.ul.Equals(currentStatus.ul))
{
if (sb.Length>26){ sb.Append(", "); }
sb.Append("ul='" + wfd.ul + "', ul_setby=" + setBy + ", dt_ul=sysdate ,ul_sb_userid='" + setby_user + "' ");
addActionLog(uid, currentStatus.case_Id, "Updating WW ul Status for " + currentStatus.midn_Id + " : " + wfd.ul, "WAIVER STATUS", currentStatus.midn_Id);
}
else if (string.IsNullOrEmpty(wfd.ul) && !isSameNullEmpty(wfd.ul, currentStatus.ul))//!wfd.ul.Equals(currentStatus.ul))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" ul=null, ul_setby=null, dt_ul=sysdate, ul_sb_userid=null ");
addActionLog(uid, currentStatus.case_Id, "Clearing ul Status for " + currentStatus.midn_Id + " : " + wfd.ul, "WAIVER STATUS", currentStatus.midn_Id);
}
//SWO
if (!string.IsNullOrEmpty(wfd.swo) && !wfd.swo.Equals(currentStatus.swo))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" swo='" + wfd.swo + "', swo_setby=" + setBy + ", dt_swo=sysdate ,swo_sb_userid='" + setby_user + "' ");
addActionLog(uid, currentStatus.case_Id, "Updating WW swo Status for " + currentStatus.midn_Id + " : " + wfd.swo, "WAIVER STATUS", currentStatus.midn_Id);
}
else if (string.IsNullOrEmpty(wfd.swo) && !isSameNullEmpty(wfd.swo, currentStatus.swo))// !wfd.swo.Equals(currentStatus.swo))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" swo=null, swo_setby=null, dt_swo=sysdate , swo_sb_userid=null ");
addActionLog(uid, currentStatus.case_Id, "Clearing swo Status for " + currentStatus.midn_Id + " : " + wfd.swo, "WAIVER STATUS", currentStatus.midn_Id);
}
//USMC
if (!string.IsNullOrEmpty(wfd.usmc) && !wfd.usmc.Equals(currentStatus.usmc))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" usmc='" + wfd.usmc + "', usmc_setby=" + setBy + ", dt_usmc=sysdate ,usmc_sb_userid='" + setby_user + "' ");
addActionLog(uid, currentStatus.case_Id, "Updating WW usmc Status for " + currentStatus.midn_Id + " : " + wfd.usmc, "WAIVER STATUS", currentStatus.midn_Id);
}
else if (string.IsNullOrEmpty(wfd.usmc) && !isSameNullEmpty(wfd.usmc,currentStatus.usmc) )//!wfd.usmc.Equals(currentStatus.usmc) &&
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" usmc=null, usmc_setby=null, dt_usmc=sysdate , usmc_sb_userid=null ");
addActionLog(uid, currentStatus.case_Id, "Clearing usmc Status for " + currentStatus.midn_Id + " : " + wfd.usmc, "WAIVER STATUS", currentStatus.midn_Id);
}
//NUKE
if (!string.IsNullOrEmpty(wfd.nuke) && !wfd.nuke.Equals(currentStatus.nuke) )
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" nuke='" + wfd.nuke + "', nuke_setby=" + setBy + ", dt_nuke=sysdate ,nuke_sb_userid='" + setby_user + "' ");
addActionLog(uid, currentStatus.case_Id, "Updating SDW nuke Status for " + currentStatus.midn_Id + " : " + wfd.nuke, "WAIVER STATUS", currentStatus.midn_Id);
}
else if (string.IsNullOrEmpty(wfd.nuke) && !isSameNullEmpty(wfd.nuke,currentStatus.nuke) )
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" nuke=null, nuke_setby=null, dt_nuke=sysdate , nuke_sb_userid=null ");
addActionLog(uid, currentStatus.case_Id, "Clearing nuke Status for " + currentStatus.midn_Id + " : " + wfd.nuke, "WAIVER STATUS", currentStatus.midn_Id);
}
//SUB
if (!string.IsNullOrEmpty(wfd.sub) && !wfd.sub.Equals(currentStatus.sub))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" sub='" + wfd.sub + "', sub_setby=" + setBy + ", dt_sub=sysdate ,sub_sb_userid='" + setby_user + "' ");
addActionLog(uid, currentStatus.case_Id, "Updating SDW sub Status for " + currentStatus.midn_Id + " : " + wfd.sub, "WAIVER STATUS", currentStatus.midn_Id);
}
else if (string.IsNullOrEmpty(wfd.sub) && !isSameNullEmpty(wfd.sub, currentStatus.sub))//!wfd.sub.Equals(currentStatus.sub))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" sub=null, sub_setby=null, dt_sub=sysdate , sub_sb_userid=null ");
addActionLog(uid, currentStatus.case_Id, "Clearing sub Status for " + currentStatus.midn_Id + " : " + wfd.sub, "WAIVER STATUS", currentStatus.midn_Id);
}
//SPECWAR
if (!string.IsNullOrEmpty(wfd.specwar) && !wfd.specwar.Equals(currentStatus.specwar))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" specwar='" + wfd.specwar + "', specwar_setby=" + setBy + ", dt_specwar=sysdate ,specwar_sb_userid='" + setby_user + "' ");
addActionLog(uid, currentStatus.case_Id, "Updating SDW specwar Status for " + currentStatus.midn_Id + " : " + wfd.specwar, "WAIVER STATUS", currentStatus.midn_Id);
}
else if (string.IsNullOrEmpty(wfd.specwar) && !isSameNullEmpty(wfd.specwar, currentStatus.specwar))// !wfd.specwar.Equals(currentStatus.specwar))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" specwar=null, specwar_setby=null, dt_specwar=sysdate , specwar_sb_userid=null ");
addActionLog(uid, currentStatus.case_Id, "Clearing specwar Status for " + currentStatus.midn_Id + " : " + wfd.specwar, "WAIVER STATUS", currentStatus.midn_Id);
}
//DIVE
if (!string.IsNullOrEmpty(wfd.dive) && !wfd.dive.Equals(currentStatus.dive))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" dive='" + wfd.dive + "', dive_setby=" + setBy + ", dt_dive=sysdate ,dive_sb_userid='" + setby_user + "' ");
addActionLog(uid, currentStatus.case_Id, "Updating SDW dive Status for " + currentStatus.midn_Id + " : " + wfd.dive, "WAIVER STATUS", currentStatus.midn_Id);
}
else if (string.IsNullOrEmpty(wfd.dive) && !isSameNullEmpty(wfd.dive, currentStatus.dive))// !wfd.dive.Equals(currentStatus.dive))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" dive=null, dive_setby=null, dt_dive=sysdate , dive_sb_userid=null ");
addActionLog(uid, currentStatus.case_Id, "Clearing dive Status for " + currentStatus.midn_Id + " : " + wfd.dive, "WAIVER STATUS", currentStatus.midn_Id);
}
//REAB
if (!string.IsNullOrEmpty(wfd.reab) && !wfd.reab.Equals(currentStatus.reab))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" reab='" + wfd.reab + "', reab_setby=" + setBy + ", dt_reab=sysdate ,reab_sb_userid='" + setby_user + "' ");
addActionLog(uid, currentStatus.case_Id, "Updating reab Status for " + currentStatus.midn_Id + " : " + wfd.reab, "WAIVER STATUS", currentStatus.midn_Id);
}
else if (string.IsNullOrEmpty(wfd.reab) && !isSameNullEmpty(wfd.reab, currentStatus.reab))// !wfd.reab.Equals(currentStatus.reab))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" reab=null, reab_setby=null, dt_reab=sysdate , reab_sb_userid=null ");
addActionLog(uid, currentStatus.case_Id, "Clearing reab Status for " + currentStatus.midn_Id + " : " + wfd.reab, "WAIVER STATUS", currentStatus.midn_Id);
}
//SNFO
if (!string.IsNullOrEmpty(wfd.snfo) && !wfd.snfo.Equals(currentStatus.snfo))
{
if (sb.Length > 26 ){ sb.Append(", "); }
sb.Append(" snfo='" + wfd.snfo + "', snfo_setby=" + setBy + ", dt_snfo=sysdate ,snfo_sb_userid='" + setby_user + "' ");
addActionLog(uid, currentStatus.case_Id, "Updating snfo Status for " + currentStatus.midn_Id + " : " + wfd.snfo, "WAIVER STATUS", currentStatus.midn_Id);
}
else if (string.IsNullOrEmpty(wfd.snfo) && !isSameNullEmpty(wfd.snfo, currentStatus.snfo))// !wfd.snfo.Equals(currentStatus.snfo))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" snfo=null, snfo_setby=null, dt_snfo=sysdate, snfo_sb_userid=null ");
addActionLog(uid, currentStatus.case_Id, "Clearing snfo Status for " + currentStatus.midn_Id + " : " + wfd.snfo, "WAIVER STATUS", currentStatus.midn_Id);
}
//SNA
if (!string.IsNullOrEmpty(wfd.sna) && !wfd.sna.Equals(currentStatus.sna))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" sna='" + wfd.sna + "', sna_setby=" + setBy + ", dt_sna=sysdate ,sna_sb_userid='" + setby_user + "' ");
addActionLog(uid, currentStatus.case_Id, "Updating sna Status for " + currentStatus.midn_Id + " : " + wfd.sna, "WAIVER STATUS", currentStatus.midn_Id);
}
else if (string.IsNullOrEmpty(wfd.sna) && !isSameNullEmpty(wfd.sna, currentStatus.sna))// !wfd.sna.Equals(currentStatus.sna))
{
if (sb.Length > 26) { sb.Append(", "); }
sb.Append(" sna=null, sna_setby=null, dt_sna=sysdate, sna_sb_userid=null ");
addActionLog(uid, currentStatus.case_Id, "Clearing sna Status for " + currentStatus.midn_Id + " : " + wfd.sna, "WAIVER STATUS", currentStatus.midn_Id);
}
sb.Append( " where midn_id=:m and case_Id=:z") ;
return sb.ToString();
}
internal IEnumerable<WaiverStatusLatest> getWaiverStatusById(string midnId)
{
List<WaiverStatusLatest> def = new List<WaiverStatusLatest>();
Int64 id = Convert.ToInt64(midnId);
string sql = "select * from WAIVER_STATUS where midn_Id=" + id;
string sql2 = "select u.lastname userName, ws.* from waiver_status ws,users u where ws.user_id=u.NMOID and midn_Id=" + id;
using (MedMidsContext db = new MedMidsContext())
{
var data = db.Database.SqlQuery<WaiverStatusLatest>(sql2);
if (data.Count() == 0)
{
WaiverStatusLatest wsl = new WaiverStatusLatest();
def.Add(wsl);
return def;
}
else
{
return data.ToList();
}
}
}
