protected void LoadMRCFHistoryHeader(string pHandlerCode)
{
//if (Request.QueryString["mrcfcode"] == null) { return; }
clsMRCFAssign objMRCFAssign = new clsMRCFAssign();
string strWrite = "";
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Speedo"].ToString()))
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = "SELECT (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode) AS MRCFcode,(SELECT createon FROM CIS.MrcfAssign WHERE hdlrcode= CIS.MrcfAssignDetails.hdlrcode) AS DateAssign,(SELECT assignby FROM CIS.MrcfAssignDetails WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode and isactive='1') AS MainAssignby,(SELECT intended FROM CIS.Mrcf WHERE mrcfcode = (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode)) AS IntendedFor,statcode,assignto,assignby,createby,remarks,(SELECT statdesc FROM CIS.MrcfAssignStatus WHERE statcode = CIS.MrcfAssignDetails.statcode) AS StatusDescription,createon FROM CIS.mrcfassigndetails WHERE hdlrcode = '" + pHandlerCode + "' and isactive= '1' order by createon desc";
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
strWrite += "<div class='GridBorder' style='padding-top: 5px;'> <table width='100%' cellpadding='5' class='grid'> " +
"<tr id='tr1' runat='server'> <td class='GridRows' style='width:25%;'>MRCF Code :</td> " +
"<td class='GridRows' style='width: 479px'> <a href='MRCFUpdateStatus.aspx?mrcfcode=" + dr["mrcfcode"] + "&updatecode=" + "000" + "' style='font-size:small;'>" + dr["mrcfcode"] + "</a> </td> " +
"</tr> <tr id='tr1' runat='server'> <td class='GridRows' style='width:25%;'>MRCF Intended for :</td> " +
"<td class='GridRows' style='width: 479px'>" + dr["IntendedFor"] + " </td> " +
"</tr> <tr> <td class='GridRows' style='width:25%;'>Assigned by :</td> " +
"<td class='GridRows' style='width: 479px'> <a href='../../Userpage/UserPage.aspx?username="******"Mainassignby"] + "'>" + dr["Mainassignby"] + "</a></td> " +
"</tr> <tr> <td class='GridRows' style='width:25%;'>Date Assigned :</td> " +
"<td class='GridRows' style='width: 479px'> " + Convert.ToDateTime(dr["DateAssign"]).ToString("MMMM dd, yyyy hh:mm:ss tt") + " </td> </tr> </table> <br /> </div>";
Response.Write(strWrite);
dr.Close();
}
}
}
protected void LoadCurrentStatus()
{
clsMRCFAssign objMRCFAssign = new clsMRCFAssign();
string strWrite = "";
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Speedo"].ToString()))
{
SqlCommand cmd = cn.CreateCommand();
//cmd.CommandText = "SELECT (SELECT intended FROM CIS.Mrcf WHERE mrcfcode = (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode)) AS IntendedFor,statcode,(SELECT createon FROM CIS.MrcfAssign WHERE hdlrcode= CIS.MrcfAssignDetails.hdlrcode) AS DateAssign,(SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode) AS MRCFcode,hdlrcode,assignto,assignby,remarks,(SELECT statdesc FROM CIS.MrcfAssignStatus WHERE statcode = CIS.MrcfAssignDetails.statcode) AS StatusDescription,createon FROM CIS.mrcfassigndetails WHERE hdlrcode = (SELECT hdlrcode FROM CIS.MrcfAssign WHERE mrcfcode ='" + Request.QueryString["mrcfcode"] + "' AND isactive = '1') AND isactive = '1' ORDER BY hdlrcode ASC";
cmd.CommandText = "SELECT (SELECT intended FROM CIS.Mrcf WHERE mrcfcode = (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode)) AS IntendedFor,statcode,(SELECT createon FROM CIS.MrcfAssign WHERE hdlrcode= CIS.MrcfAssignDetails.hdlrcode) AS DateAssign,(SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode) AS MRCFcode,hdlrcode,assignto,assignby,remarks,(SELECT statdesc FROM CIS.MrcfAssignStatus WHERE statcode = CIS.MrcfAssignDetails.statcode) AS StatusDescription,createon FROM CIS.mrcfassigndetails WHERE hdlrcode = (SELECT TOP 1 hdlrcode FROM CIS.MrcfAssign WHERE mrcfcode ='" + Request.QueryString["mrcfcode"] + "' AND isactive = '1' ORDER BY hdlrcode DESC) AND isactive = '1' ORDER BY hdlrcode ASC";
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string strStatus = "";
strStatus = dr["statcode"].ToString() == "000" ? "<table width='100%' style='text-align:center; border: 0px solid grey; padding:0px ;'cellpadding='0' cellspacing='0'><tr><td><table height='16px' width='100%' style='border-radius:0px; border: 1px solid grey; padding:1px ; text-align:left;' cellpadding='0' cellspacing='0'><tr><td width='100%'><table height='10px' width='100%' border='0' cellpadding='0' cellspacing='0' ><tr><td bgcolor='red' style='border-radius:1px; ' width= '100%'></td></tr></table></td></tr></table>" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%</tr></td></table>" : "<table width='100%' style='text-align:center; border: 0px solid grey; padding:0px ;'cellpadding='0' cellspacing='0'><tr><td><table height='16px' width='100%' style='border-radius:0px; border: 1px solid grey; padding:1px ; text-align:left;' cellpadding='0' cellspacing='0'><tr><td width='100%'><table height='10px' width='" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%' border='0' cellpadding='0' cellspacing='0' ><tr><td bgcolor='#1874cd' style='border-radius:1px; ' width= '" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%'></td></tr></table></td></tr></table>" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%</tr></td></table>";
strWrite = strWrite +
dr["StatusDescription"].ToString() +
strStatus;
}
dr.Close();
}
Response.Write(strWrite);
}
protected void UpdateAssignedMRCF()
{
clsMRCFAssign objMRCFAssign = new clsMRCFAssign();
string strWrite = "";
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Speedo"].ToString()))
{
SqlCommand cmd = cn.CreateCommand();
// cmd.CommandText = "SELECT (SELECT intended FROM CIS.Mrcf WHERE mrcfcode = (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode)) AS IntendedFor,statcode,(SELECT createon FROM CIS.MrcfAssign WHERE hdlrcode= CIS.MrcfAssignDetails.hdlrcode) AS DateAssign,(SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode) AS MRCFcode,hdlrcode,assignto,assignby,remarks,(SELECT statdesc FROM CIS.MrcfAssignStatus WHERE statcode = CIS.MrcfAssignDetails.statcode) AS StatusDescription,createon FROM CIS.mrcfassigndetails WHERE hdlrcode = (SELECT hdlrcode FROM CIS.MrcfAssign WHERE mrcfcode = '" + Request.QueryString["mrcfcode"] + "') AND isactive = '1' ORDER BY hdlrcode ASC";
cmd.CommandText = "SELECT (SELECT intended FROM CIS.Mrcf WHERE mrcfcode = (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode)) AS IntendedFor,statcode,(SELECT createon FROM CIS.MrcfAssign WHERE hdlrcode= CIS.MrcfAssignDetails.hdlrcode) AS DateAssign,(SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode) AS MRCFcode,hdlrcode,assignto,assignby,remarks,(SELECT statdesc FROM CIS.MrcfAssignStatus WHERE statcode = CIS.MrcfAssignDetails.statcode) AS StatusDescription,createon FROM CIS.mrcfassigndetails WHERE hdlrcode = (SELECT hdlrcode FROM CIS.MrcfAssign WHERE mrcfcode = '" + Request.QueryString["mrcfcode"] + "') AND isactive = '1' ORDER BY hdlrcode ASC";
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
strWrite = strWrite +
"<a href='MRCFDetailsDH.aspx?mrcfcode=" + dr["mrcfcode"] + "' style='font-size:small;'>" + dr["IntendedFor"] + "</a><br>" +
"Assigned by: <a href='../../Userpage/UserPage.aspx?username="******"assignby"] + "'>" + dr["assignby"] + "</a><br>" +
"Date Assigned: " + Convert.ToDateTime(dr["DateAssign"]).ToString("MMMM dd, yyyy") + "<br>" +
"Remarks: " + dr["Remarks"];
}
dr.Close();
}
Response.Write(strWrite);
}
/* ******************
* * *Page Event* * *
* ******************
*/
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["CurPage"] == null)
{
CurPage = 1;
}
else if (Convert.ToInt32(Request.QueryString["CurPage"].ToString()) == 0 || string.IsNullOrEmpty(Request.QueryString["CurPage"].ToString()))
{
CurPage = 1;
}
else
{
CurPage = Convert.ToInt32(Request.QueryString["CurPage"].ToString());
}
clsSpeedo.Authenticate();
if (!Page.IsPostBack)
{
BindEmployee();
BindAssignStatus();
//ddlAssignStatus.SelectedValue = "999";
if (string.IsNullOrEmpty(Request.QueryString["pUser"]))
{
ddlEmployee.SelectedValue = "999";
}
else
{
ddlEmployee.SelectedValue = Request.QueryString["pUser"].ToString();
}
if (string.IsNullOrEmpty(Request.QueryString["pStatCode"]))
{
ddlAssignStatus.SelectedValue = "999";
}
else
{
ddlAssignStatus.SelectedValue = Request.QueryString["pStatCode"].ToString();
}
using (clsMRCFAssign objAssign = new clsMRCFAssign())
{
if (objAssign.GetProcurementManager("PROCMNGR").ToString() == Request.Cookies["Speedo"]["UserName"].ToString())
{
trEmployee.Visible = true;
}
else
{
trEmployee.Visible = false;
}
}
}
//if (Request.QueryString["hdlrcode"] == null) { return; }
LoadListAssigned(ddlAssignStatus.SelectedValue.ToString(), GetUser(), CurPage);
}
protected void btnUpdateReassign_Click(object sender, EventArgs e)
{
clsMRCFAssign objAssign = new clsMRCFAssign();
objAssign.HandlerCode = objAssign.GetHandlerCode(Request.QueryString["mrcfcode"].ToString());
objAssign.AssignBy = Request.Cookies["Speedo"]["UserName"].ToString(); //objAssign.GetProcurementManager("PROCMNGR");
objAssign.CreateBy = Request.Cookies["Speedo"]["UserName"].ToString();
objAssign.IsActive = "1"; //1 = Active , 0 = Inactive
objAssign.AssignTo = ddlReassign.SelectedValue.ToString();
objAssign.Remarks = txtReassignRemarks.Text;
objAssign.StatusCode = objAssign.LoadCurrentStatus(Request.QueryString["mrcfcode"]);
objAssign.AssignEmployeeDetails("Reassign");
Response.Redirect("MRCFMenu.aspx");
}
public string GetUser()
{
string strHandler;
using (clsMRCFAssign objAssign = new clsMRCFAssign())
{
if (objAssign.GetProcurementManager("PROCMNGR").ToString() == Request.Cookies["Speedo"]["UserName"].ToString())
{
strHandler = ddlEmployee.SelectedValue.ToString();
}
else
{
strHandler = Request.Cookies["Speedo"]["UserName"].ToString();
}
}
return(strHandler);
}
protected void LoadAirlines()
{
HtmlTableCell CellMain = tAirlines;
HtmlTable tblAirlines = new HtmlTable();
HtmlTableRow row = new HtmlTableRow();
HtmlTableCell Cell = new HtmlTableCell();
CellMain.Controls.Clear();
clsMRCFAssign objMRCFAssign = new clsMRCFAssign();
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Speedo"].ToString()))
{
DataTable tblReturn = new DataTable();
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = "SELECT Airldesc,url FROM cis.mrcfairlines WHERE status = '1' ORDER BY airldesc ASC";
cn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(tblReturn);
foreach (DataRow dr in tblReturn.Rows)
{
HtmlAnchor A = new HtmlAnchor();
HyperLink links = new HyperLink();
links.Text = "<li>" + dr["airldesc"].ToString() + "</li>";
links.Target = "_blank";
links.NavigateUrl = dr["url"].ToString();
Cell.Controls.Add(links);
}
cn.Close();
if (tblReturn.Rows.Count == 0)
{
Label lbl = new Label();
lbl.Text = "No available Airlines reference";
Cell.Controls.Add(lbl);
}
}
tblAirlines.Attributes.Add("cellspacing", "0");
tblAirlines.Attributes.Add("cellpadding", "0");
row.Cells.Add(Cell);
tblAirlines.Rows.Add(row);
tAirlines.Controls.Add(tblAirlines);
}
protected void LoadMRCFHistory(string pHandlerCode)
{
clsMRCFAssign objMRCFAssign = new clsMRCFAssign();
string strWrite = "";
int intCtr = 0;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Speedo"].ToString()))
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = "SELECT (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode) AS MRCFcode,(SELECT createon FROM CIS.MrcfAssign WHERE hdlrcode= CIS.MrcfAssignDetails.hdlrcode) AS DateAssign,(SELECT assignby FROM CIS.MrcfAssignDetails WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode and isactive='1') AS MainAssignby,(SELECT intended FROM CIS.Mrcf WHERE mrcfcode = (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode)) AS IntendedFor,statcode,assignto,assignby,createby,remarks,(SELECT statdesc FROM CIS.MrcfAssignStatus WHERE statcode = CIS.MrcfAssignDetails.statcode) AS StatusDescription,createon FROM CIS.mrcfassigndetails WHERE hdlrcode = '" + pHandlerCode + "' order by createon desc";
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string strStatus = "";
strStatus = dr["statcode"].ToString() == "000" ? "<table width='100%' style='text-align:center; border: 0px solid grey; padding:0px ;'cellpadding='0' cellspacing='0'><tr><td><table height='16px' width='100%' style='border-radius:0px; border: 1px solid grey; padding:1px ; text-align:left;' cellpadding='0' cellspacing='0'><tr><td width='100%'><table height='10px' width='100%' border='0' cellpadding='0' cellspacing='0' ><tr><td bgcolor='red' style='border-radius:1px; ' width= '100%'></td></tr></table></td></tr></table>" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%</tr></td></table>" : "<table width='100%' style='text-align:center; border: 0px solid grey; padding:0px ;'cellpadding='0' cellspacing='0'><tr><td><table height='16px' width='100%' style='border-radius:0px; border: 1px solid grey; padding:1px ; text-align:left;' cellpadding='0' cellspacing='0'><tr><td width='100%'><table height='10px' width='" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%' border='0' cellpadding='0' cellspacing='0' ><tr><td bgcolor='#1874cd' style='border-radius:1px; ' width= '" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%'></td></tr></table></td></tr></table>" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%</tr></td></table>";
strWrite += "<tr>" +
"<td class='GridRows'>" +
"Assigned to : <a href='../../Userpage/UserPage.aspx?username="******"assignto"] + "'>" + dr["assignto"] + "</a><br>" +
"Assigned by: <a href='../../Userpage/UserPage.aspx?username="******"assignby"] + "'>" + dr["assignby"] + "</a><br>" +
"Date Modified: " + Convert.ToDateTime(dr["createon"]).ToString("MMMM dd, yyyy") + "<br>" +
"Modified by: <a href='../../Userpage/UserPage.aspx?username="******"createby"] + "'>" + dr["createby"] + "</a><br>" +
"Remarks: " + dr["Remarks"] +
"</td>" +
"<td class='GridRows'>" + dr["StatusDescription"].ToString() +
strStatus +
"</td>" +
"</tr>";
intCtr++;
}
dr.Close();
}
Response.Write(strWrite);
if (intCtr == 0)
{
Response.Write(strWrite += "<tr><td colspan='2' class='GridRows'>No record found</td></tr>");
}
else
{
Response.Write(strWrite += "<tr><td colspan='2' class='GridRows'>[ " + intCtr + " records found ]</td></tr>");
}
}
protected void LoadListAssigned()
{
clsMRCFAssign objMRCFAssign = new clsMRCFAssign();
string strWrite = "";
int intCtr = 0;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Speedo"].ToString()))
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = "SELECT Top 10 (SELECT intended FROM CIS.Mrcf WHERE mrcfcode = (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode)) AS IntendedFor,statcode,(SELECT createon FROM CIS.MrcfAssign WHERE hdlrcode= CIS.MrcfAssignDetails.hdlrcode) AS DateAssign,(SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode) AS MRCFcode,hdlrcode,assignto,assignby,remarks,(SELECT statdesc FROM CIS.MrcfAssignStatus WHERE statcode = CIS.MrcfAssignDetails.statcode) AS StatusDescription,createon FROM CIS.mrcfassigndetails WHERE assignto = '" + Request.Cookies["Speedo"]["UserName"] + "' AND isactive = '1' and statcode <> '001' AND statcode <> '000' ORDER BY hdlrcode DESC";
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
//Response.Cookies["MRCF"]["MRCFCODE"] = dr["mrcfcode"].ToString();
strWrite = strWrite + "<tr>" +
"<td runat='server' class='GridRows'>" +
"<a href='MRCFUpdateStatus.aspx?mrcfcode=" + dr["mrcfcode"] + "' runat='server' onClick=''><img src='../../Support/approval.png' alt='' /></a>" +
"<a href='MRCFPrint.aspx?mrcfcode=" + dr["mrcfcode"] + "' runat='server' onClick=''><img src='../../Support/print32.png' alt='' /></a>" +
"<td class='GridRows'>" +
"<a href='MRCFUpdateStatus.aspx?mrcfcode=" + dr["mrcfcode"] + "&updatecode=" + "000" + "' style='font-size:small;'>" + dr["IntendedFor"] + "</a><br>" +
"Assigned by: <a href='../../Userpage/UserPage.aspx?username="******"assignby"] + "'>" + dr["assignby"] + "</a><br>" +
"Date Assigned: " + Convert.ToDateTime(dr["DateAssign"]).ToString("MMMM dd, yyyy") + "<br>" +
"Remarks: " + dr["Remarks"] +
"</td>" +
"<td class='GridRows'>" + dr["StatusDescription"].ToString() +
"<table width='100%' style='text-align:center; border: 0px solid grey; padding:0px ;'cellpadding='0' cellspacing='0'><tr><td><table height='16px' width='100%' style='border-radius:0px; border: 1px solid grey; padding:1px ; text-align:left;' cellpadding='0' cellspacing='0'><tr><td width='100%'><table height='10px' width='" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%' border='0' cellpadding='0' cellspacing='0' ><tr><td bgcolor='#1874cd' style='border-radius:1px; ' width= '" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%'></td></tr></table></td></tr></table>" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%</tr></td></table>" +
"</td>" +
"</tr>";
intCtr++;
}
dr.Close();
}
Response.Write(strWrite);
if (intCtr == 0)
{
Response.Write("<tr><td colspan='3' class='GridRows'>No record found</td></tr>");
}
else
{
Response.Write("<tr><td colspan='3' class='GridRows'>[ " + intCtr + " records found ]</td></tr>");
}
}
protected void LoadAirlines()
{
clsMRCFAssign objMRCFAssign = new clsMRCFAssign();
string strWrite = "";
int intCtr = 0;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Speedo"].ToString()))
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = "SELECT airlcode,Airldesc,URL,status FROM cis.mrcfairlines ORDER BY airldesc ASC";
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string strStatus = "<td runat='server' class='GridRows' style='vertical-align:middle;'><center> <a href='#' runat='server' id='" + dr["airlcode"].ToString() + "' onclick='UpdateStatus(this.id)'><img src='../../Support/unchecked.png' alt='' /></a> </center>";
if (dr["status"].ToString() == "1")
{
strStatus = "<td runat='server' class='GridRows' style='vertical-align:middle;'><center> <a href='#' runat='server' id='" + dr["airlcode"].ToString() + "' onclick='UpdateStatus(this.id)'><img src='../../Support/checked.png' alt='' /></a> </center>";
}
//Response.Cookies["MRCF"]["MRCFCODE"] = dr["mrcfcode"].ToString();'" + + "'
strWrite = strWrite + "<tr>" +
"<td runat='server' class='GridRows' style='vertical-align:middle; text-align:center;'>" +
"<a href='#' runat='server' id='" + dr["airlcode"].ToString() + "' onclick='ModalPop(this.id)'><img src='../../Support/edit16.png' alt='' /></a>" +
"<td class='GridRows'style='vertical-align:middle;'><a href=javascript:winpop('" + dr["URL"].ToString() + "',800,600,0,0,1); runat='server'>" + dr["airldesc"].ToString() + "</a>" +
strStatus +
"</tr>";
intCtr++;
}
dr.Close();
}
Response.Write(strWrite);
if (intCtr == 0)
{
Response.Write("<tr><td colspan='3' class='GridRows' style='text-align:center'>No record found</td></tr>");
}
else
{
Response.Write("<tr><td colspan='3' class='GridRows' style='text-align:center'>[ " + intCtr + " records found ]</td></tr>");
}
}
protected void LoadCurrentHandler()
{
clsMRCFAssign objMRCFAssign = new clsMRCFAssign();
string strWrite = "";
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Speedo"].ToString()))
{
SqlCommand cmd = cn.CreateCommand();
//cmd.CommandText = "SELECT (SELECT intended FROM CIS.Mrcf WHERE mrcfcode = (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode)) AS IntendedFor,statcode,(SELECT createon FROM CIS.MrcfAssign WHERE hdlrcode= CIS.MrcfAssignDetails.hdlrcode) AS DateAssign,(SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode) AS MRCFcode,hdlrcode,assignto,assignby,remarks,(SELECT statdesc FROM CIS.MrcfAssignStatus WHERE statcode = CIS.MrcfAssignDetails.statcode) AS StatusDescription,createon FROM CIS.mrcfassigndetails WHERE hdlrcode = (SELECT hdlrcode FROM CIS.MrcfAssign WHERE mrcfcode ='" + Request.QueryString["mrcfcode"] + "' AND isactive = '1') AND isactive = '1' ORDER BY hdlrcode ASC";
cmd.CommandText = "SELECT (SELECT intended FROM CIS.Mrcf WHERE mrcfcode = (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode)) AS IntendedFor,statcode,(SELECT createon FROM CIS.MrcfAssign WHERE hdlrcode= CIS.MrcfAssignDetails.hdlrcode) AS DateAssign,(SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode) AS MRCFcode,hdlrcode,assignto,assignby,remarks,(SELECT statdesc FROM CIS.MrcfAssignStatus WHERE statcode = CIS.MrcfAssignDetails.statcode) AS StatusDescription,createon FROM CIS.mrcfassigndetails WHERE hdlrcode = (SELECT TOP 1 hdlrcode FROM CIS.MrcfAssign WHERE mrcfcode ='" + Request.QueryString["mrcfcode"] + "' AND isactive = '1' ORDER BY hdlrcode DESC) AND isactive = '1' ORDER BY hdlrcode ASC";
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ddlAssignStatus.SelectedValue = dr["statcode"].ToString();
strWrite = strWrite +
dr["Assignto"].ToString();
}
dr.Close();
}
Response.Write(strWrite);
}
protected void LoadListAssigned(string pStatCode, string pUser, int PPage)
{
int page = ((PPage - 1) * 20) + 1;
clsMRCFAssign objMRCFAssign = new clsMRCFAssign();
string strWrite = "";
int intCtr = 0;
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Speedo"].ToString()))
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = "SELECT TOP 20 * FROM (SELECT ROW_NUMBER() OVER(ORDER BY hdlrcode DESC) AS RowNo, (SELECT btchcode FROM CIS.MrcfBatch WHERE mrcfcode = (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode)) as btchcode,(SELECT intended FROM CIS.Mrcf WHERE mrcfcode = (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode)) AS IntendedFor,statcode,(SELECT createon FROM CIS.MrcfAssign WHERE hdlrcode= CIS.MrcfAssignDetails.hdlrcode) AS DateAssign,(SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode) AS MRCFcode,hdlrcode,assignto,assignby,remarks,(SELECT statdesc FROM CIS.MrcfAssignStatus WHERE statcode = CIS.MrcfAssignDetails.statcode) AS StatusDescription,createon FROM CIS.mrcfassigndetails WHERE isactive = '1' AND assignto LIKE '" + (pUser == "999" ? "%" : pUser) + "' AND statcode LIKE '" + (pStatCode == "999" ? "%" : pStatCode) + "')AS QRY WHERE (QRY.RowNo >=@RowNo) AND (QRY.RowNo<=@RowNo+20) ORDER BY hdlrcode DESC";
//cmd.CommandText = "SELECT TOP 20 * FROM (SELECT ROW_NUMBER() OVER(ORDER BY hdlrcode ASC) AS RowNo, (SELECT btchcode FROM CIS.MrcfBatch WHERE mrcfcode = (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode)) as btchcode,(SELECT intended FROM CIS.Mrcf WHERE mrcfcode = (SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode)) AS IntendedFor,statcode,(SELECT createon FROM CIS.MrcfAssign WHERE hdlrcode= CIS.MrcfAssignDetails.hdlrcode) AS DateAssign,(SELECT mrcfcode FROM CIS.MrcfAssign WHERE hdlrcode = CIS.MrcfAssignDetails.hdlrcode) AS MRCFcode,hdlrcode,assignto,assignby,remarks,(SELECT statdesc FROM CIS.MrcfAssignStatus WHERE statcode = CIS.MrcfAssignDetails.statcode) AS StatusDescription,createon FROM CIS.mrcfassigndetails WHERE isactive = '1' AND assignto LIKE '" + (pUser == "999" ? "%" : pUser) + "' AND statcode LIKE '" + (pStatCode == "999" ? "%" : pStatCode) + "')AS QRY WHERE RowNo >=@RowNo ORDER BY hdlrcode DESC";
cmd.Parameters.AddWithValue("@RowNo", page);
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string strStatus = "";
if (pUser == "999")
{
strStatus = dr["statcode"].ToString() == "000" ? "<table width='100%' style='text-align:center; border: 0px solid grey; padding:0px ;'cellpadding='0' cellspacing='0'><tr><td><table height='16px' width='100%' style='border-radius:0px; border: 1px solid grey; padding:1px ; text-align:left;' cellpadding='0' cellspacing='0'><tr><td width='100%'><table height='10px' width='100%' border='0' cellpadding='0' cellspacing='0' ><tr><td bgcolor='red' style='border-radius:1px; ' width= '100%'></td></tr></table></td></tr></table>" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%</tr></td></table>" : "<table width='100%' style='text-align:center; border: 0px solid grey; padding:0px ;'cellpadding='0' cellspacing='0'><tr><td><table height='16px' width='100%' style='border-radius:0px; border: 1px solid grey; padding:1px ; text-align:left;' cellpadding='0' cellspacing='0'><tr><td width='100%'><table height='10px' width='" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%' border='0' cellpadding='0' cellspacing='0' ><tr><td bgcolor='#1874cd' style='border-radius:1px; ' width= '" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%'></td></tr></table></td></tr></table>" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%</tr></td></table>";
strWrite = strWrite + "<tr>" +
"<td runat='server' class='GridRows'>" +
"<a href='MRCFUpdateStatus.aspx?mrcfcode=" + dr["mrcfcode"] + "' runat='server' ><img src='../../Support/approval.png' alt='' style='padding-bottom:10px;'/></a>" +
"<center><a href='#' id='" + dr["hdlrcode"].ToString() + "' runat='server' onclick='ModalPop(this.id)'><img src='../../Support/viewtext22.png' alt='' style='padding-bottom:10px;'/></a></center>" +
"<a href='MRCFPrint.aspx?mrcfcode=" + dr["mrcfcode"] + "' runat='server' onClick=''><img src='../../Support/print32.png' alt='' /></a>" +
"<td class='GridRows'>" +
"<a href='MRCFUpdateStatus.aspx?mrcfcode=" + dr["mrcfcode"] + "&updatecode=" + "000" + "' style='font-size:small;'>" + dr["IntendedFor"] + "</a><br>" +
"Current Handler: <a href='../../Userpage/UserPage.aspx?username="******"assignto"] + "'>" + dr["assignto"] + "</a><br>" +
"Assigned by: <a href='../../Userpage/UserPage.aspx?username="******"assignby"] + "'>" + dr["assignby"] + "</a><br>" +
"Date Assigned: " + Convert.ToDateTime(dr["DateAssign"]).ToString("MMMM dd, yyyy") + "<br>" +
"MRCF Code: " + dr["mrcfcode"] + "<br>" +
"Batch Code: " + dr["btchcode"] + "<br>" +
"Remarks: " + dr["Remarks"] +
"</td>" +
"<td class='GridRows'>" + dr["StatusDescription"].ToString() +
strStatus +
"</td>" +
"</tr>";
intCtr++;
}
else
{
try
{
strStatus = dr["statcode"].ToString() == "000" ? "<table width='100%' style='text-align:center; border: 0px solid grey; padding:0px ;'cellpadding='0' cellspacing='0'><tr><td><table height='16px' width='100%' style='border-radius:0px; border: 1px solid grey; padding:1px ; text-align:left;' cellpadding='0' cellspacing='0'><tr><td width='100%'><table height='10px' width='100%' border='0' cellpadding='0' cellspacing='0' ><tr><td bgcolor='red' style='border-radius:1px; ' width= '100%'></td></tr></table></td></tr></table>" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%</tr></td></table>" : "<table width='100%' style='text-align:center; border: 0px solid grey; padding:0px ;'cellpadding='0' cellspacing='0'><tr><td><table height='16px' width='100%' style='border-radius:0px; border: 1px solid grey; padding:1px ; text-align:left;' cellpadding='0' cellspacing='0'><tr><td width='100%'><table height='10px' width='" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%' border='0' cellpadding='0' cellspacing='0' ><tr><td bgcolor='#1874cd' style='border-radius:1px; ' width= '" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%'></td></tr></table></td></tr></table>" + objMRCFAssign.GetProjectPercentage(dr["statcode"].ToString()).ToString("N0") + "%</tr></td></table>";
strWrite = strWrite + "<tr>" +
"<td runat='server' class='GridRows'>" +
"<a href='MRCFUpdateStatus.aspx?mrcfcode=" + dr["mrcfcode"] + "' runat='server' ><img src='../../Support/approval.png' alt='' style='padding-bottom:10px;'/></a>" +
"<center><a href='#' id='" + dr["hdlrcode"].ToString() + "' runat='server' onclick='ModalPop(this.id)'><img src='../../Support/viewtext22.png' alt='' style='padding-bottom:10px;'/></a></center>" +
"<a href='MRCFPrint.aspx?mrcfcode=" + dr["mrcfcode"] + "' runat='server' onClick=''><img src='../../Support/print32.png' alt='' /></a>" +
"<td class='GridRows'>" +
"<a href='MRCFUpdateStatus.aspx?mrcfcode=" + dr["mrcfcode"] + "&updatecode=" + "000" + "' style='font-size:small;'>" + dr["IntendedFor"] + "</a><br>" +
"Assigned by: <a href='../../Userpage/UserPage.aspx?username="******"assignby"] + "'>" + dr["assignby"] + "</a><br>" +
"Date Assigned: " + Convert.ToDateTime(dr["DateAssign"]).ToString("MMMM dd, yyyy") + "<br>" +
"MRCF Code: " + dr["mrcfcode"] + "<br>" +
"Batch Code: " + dr["btchcode"] + "<br>" +
"Remarks: " + dr["Remarks"] +
"</td>" +
"<td class='GridRows'>" + dr["StatusDescription"].ToString() +
strStatus +
"</td>" +
"</tr>";
intCtr++;
}
catch { }
}
}
dr.Close();
}
//Response.Write(lblSearch.Text);
if (intCtr == 0)
{
strWrite += "<tr><td colspan='3' class='GridRows'>No record found</td></tr>";
}
else
{
strWrite += "<tr><td colspan='2' class='GridRows'>[ " + intCtr + " records found ]</td><td id='tdPaging' style='text-align:right;' class='GridRows'>" + Paging(GetUser(), ddlAssignStatus.SelectedValue.ToString()) + "</td></tr>";
}
lblSearch.Text = strWrite;
}
protected void btnApprove_Click(object sender, EventArgs e)
{
if (!clsOracleMrcf.IsOracleUp())
{
Response.Redirect("OracleDatabaseProblem.aspx");
}
clsMRCFAssign objAssign = new clsMRCFAssign();
objAssign.MRCFCode = Request.QueryString["mrcfcode"].ToString();
objAssign.AssignBy = objAssign.GetProcurementManager("PROCMNGR");
objAssign.CreateBy = objAssign.GetProcurementManager("PROCMNGR");
objAssign.IsActive = "1"; //1 = Active , 0 = Inactive
objAssign.AssignTo = ddlAssign.SelectedValue.ToString();
objAssign.Remarks = txtAssignRemarks.Text;
objAssign.StatusCode = objAssign.GetInitialStatusCode();
objAssign.AssignEmployee();
objAssign.AssignEmployeeDetails("None");
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Speedo"].ToString()))
{
SqlCommand cmd = cn.CreateCommand();
cn.Open();
//Retrieve information of MRCF
DataTable tblMRCF = clsOracleMrcf.GetMRCFDetails(Request.QueryString["mrcfcode"]);
using (clsOracleMrcf ReqMrcf = new clsOracleMrcf())
{
//Update MRCF status
cmd.CommandText = "UPDATE CIS.Mrcf SET status='A',procstat='A',sprvstat=@sprvstat,headstat=@headstat,procdate='" + DateTime.Now + "',procrem=@procrem WHERE mrcfcode='" + Request.QueryString["mrcfcode"] + "'";
cmd.Parameters.Add("@procrem", SqlDbType.VarChar, 200);
cmd.Parameters.Add("@sprvstat", SqlDbType.Char, 1);
cmd.Parameters.Add("@headstat", SqlDbType.Char, 1);
cmd.Parameters["@procrem"].Value = txtProcMngrRem.Text;
cmd.Parameters["@sprvstat"].Value = (hdnGrpHeadStat.Value == "F" ? "N" : hdnGrpHeadStat.Value);
cmd.Parameters["@headstat"].Value = (hdnDiviHeadStat.Value == "F" ? "N" : hdnDiviHeadStat.Value);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
//Update MRCF Details
cmd.CommandText = "UPDATE CIS.MrcfDetails SET itemspec=@itemspec WHERE mitmcode=@mitmcode";
cmd.Parameters.Add("@itemspec", SqlDbType.VarChar, 5000);
cmd.Parameters.Add("@mitmcode", SqlDbType.BigInt);
foreach (DataGridItem itm in dgItems.Items)
{
HiddenField phdnMitmCode = (HiddenField)itm.FindControl("hdnMitmCode");
TextBox ptxtItemSpec = (TextBox)itm.FindControl("txtItemSpec");
cmd.Parameters["@itemspec"].Value = ptxtItemSpec.Text;
cmd.Parameters["@mitmcode"].Value = phdnMitmCode.Value;
cmd.ExecuteNonQuery();
}
cmd.Parameters.Clear();
clsMRCF.SendNotification(clsMRCF.MRCFMailType.ApproveToRequestor, txtRequestorName.Text, txtProcMngrName.Text, hdnRequestorMail.Value, txtMrcfCode.Text);
clsMRCF.SendNotification(clsMRCF.MRCFMailType.ApproveToApproverPM, txtRequestorName.Text, txtProcMngrName.Text, clsUsers.GetEmail(Request.Cookies["Speedo"]["UserName"].ToString()), txtMrcfCode.Text);
//Validate if the Request is not canvass only. If Not it will enter the ORACLE for Interfacing.
if (clsMRCF.GetRequestType(Request.QueryString["mrcfcode"]) != "C")
{
//Generate batch entry number
int intBatchCode = 0;
cmd.CommandText = "SELECT pvalue FROM Speedo.Keys WHERE pkey='btchcode'";
intBatchCode = cmd.ExecuteScalar().ToString().ToInt() + 1;
cmd.Parameters.Clear();
ReqMrcf.BatchId = intBatchCode;
if (ReqMrcf.Insert(tblMRCF) == 1)
{
//Delete MRCF and Batch if existing
cmd.CommandText = "DELETE FROM CIS.MrcfBatch WHERE mrcfcode= @mrcfcode";
cmd.Parameters.Add(new SqlParameter("@mrcfcode", Request.QueryString["mrcfcode"].ToString()));
cmd.Parameters.Add(new SqlParameter("@btchcode", intBatchCode));
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
//Insert MRCFCode and Batch code of Approved MRCF that is uploaded in interface table
cmd.CommandText = "INSERT INTO CIS.MrcfBatch VALUES (@mrcfcode,@btchcode)";
cmd.Parameters.Add(new SqlParameter("@mrcfcode", Request.QueryString["mrcfcode"].ToString()));
cmd.Parameters.Add(new SqlParameter("@btchcode", intBatchCode));
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
//Increment Batchcode in SPeedo.Keys
cmd.CommandText = "UPDATE Speedo.Keys SET pvalue=(pvalue+1) WHERE pkey='btchcode'";
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
Response.Redirect("MRCFMenu.aspx");
}
else
{
Response.Redirect("MRCFMenu.aspx");
}
}
}
}
