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 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>"); } }
public void LoadMRCFHistoryDetailed(string pHandlerCode) { string strWrite; string strMRCFHistoryHeader = ""; string strMRCFHistory = ""; clsMRCFAssign objMRCFAssign = new clsMRCFAssign(); 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 = '" + pHandlerCode + "' 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(); while (dr.Read()) { strMRCFHistoryHeader += "<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'>" + dr["mrcfcode"] + " </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'> " + dr["Mainassignby"] + "</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>"; // dr.Close(); } } 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 = '" + pHandlerCode + "' 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>"; strMRCFHistory += "<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(); } if (intCtr == 0) { strMRCFHistory += "<tr><td colspan='2' class='GridRows'>No record found</td></tr>"; } else { strMRCFHistory += "<tr><td colspan='2' class='GridRows'>[ " + intCtr + " records found ]</td></tr>"; } strWrite = strMRCFHistoryHeader + " <table width='100%' cellpadding='5' class='Grid'>" + "<tr> <td class='GridColumns' style='width:70%;'><b>MRCF Status Details</b></td> <td class='GridColumns' style='width:30%;'><b>Status</b></td> </tr> " + strMRCFHistory + "</table>"; //Response.Write( strWrite); Label1.Text = strWrite; }
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); }