protected void LoadUpdates()
{
string strWrite = "";
string strStatus = "";
string strLink = "";
string strPreview = "";
foreach (DataRow drJournal in EmployeeJournal.GetDSG(Request.Cookies["Speedo"]["UserName"], Convert.ToInt16(ddlJournalYear.SelectedValue), ddlJournalDates.SelectedValue.ToString()).Rows)
{
//if (WeekYear.GetActiveWeekCode().ToString() == drJournal["WeekCode"].ToString())
//{
if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "S" && EmployeeJournal.GetLockStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "0")
{
strLink = "JournalEncoding";
strWrite = strWrite + "<tr>" +
"<td class='GridRows'><img src='../Support/Pending.png' alt='' width='16' height='16' /></td>" +
"<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" +
"<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" +
"</tr>";
}
else if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "F" && EmployeeJournal.GetLockStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "0")
{
strLink = "JournalEncodingM";
strWrite = strWrite + "<tr>" +
"<td class='GridRows'><img src='../Support/MRCF_New.png' alt='' width='16' height='16' /></td>" +
"<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" +
"<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" +
"</tr>";
}
else
{
strLink = "JournalViewer";
strWrite = strWrite + "<tr>" +
"<td class='GridRows'><img src='../Support/MRCF_View.png' alt='' width='16' height='16' /></td>" +
"<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" +
"<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" +
"</tr>";
}
//}
//else
//{
// strLink = "JournalViewer";
// strWrite = strWrite + "<tr>" +
// "<td class='GridRows'><img src='../Support/MRCF_View.png' alt='' /></td>" +
// "<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" +
// "<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" +
// "</tr>";
//}
}
//Response.Write(strWrite);
lblWrite.Text = strWrite;
}
protected void LoadUpdates()
{
string strWrite = "";
string strStatus = "";
string strLink = "";
string strPreview = "";
foreach (DataRow drJournal in EmployeeJournal.GetDSG(ddlEmployee.SelectedValue.ToString(), Convert.ToInt16(ddlJournalYear.SelectedValue), ddlJournalDates.SelectedValue.ToString()).Rows)
{
if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "S" && EmployeeJournal.GetLockStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "0")
{
strLink = "JournalViewer";
strWrite = strWrite + "<tr>" +
"<td class='GridRows'><img src='../Support/MRCF_New.png' alt='' /></td>" +
"<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" +
"<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" +
"</tr>";
}
else if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "F" && EmployeeJournal.GetLockStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "0")
{
strLink = "JournalViewer";
strWrite = strWrite + "<tr>" +
"<td class='GridRows'><img src='../Support/MRCF_New.png' alt='' /></td>" +
"<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" +
"<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" +
"</tr>";
}
else if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(drJournal["JournalCode"])).ToString() == "A")
{
strLink = "JournalViewer";
strWrite = strWrite + "<tr>" +
"<td class='GridRows'><img src='../Support/Approved.png' alt='' width='16' height='16' /></td>" +
"<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" +
"<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" +
"</tr>";
}
else
{
strLink = "JournalViewer";
strWrite = strWrite + "<tr>" +
"<td class='GridRows'><img src='../Support/hammer128.png' alt='' width='16' height='16' /></td>" +
"<td class='GridRows'><a href='" + strLink + ".aspx?JournalCode=" + drJournal["JournalCode"].ToString() + "' style='font-size:small;'>" + drJournal["WeekName"].ToString() + " (" + Convert.ToDateTime(drJournal["DateStart"].ToString()).ToString("MMM dd, yyyy") + " - " + Convert.ToDateTime(drJournal["DateEnd"].ToString()).ToString("MMM dd, yyyy") + ") </a><br></td>" +
"<td class='GridRows'>" + drJournal["ModifiedOn"].ToString() + "</td>" +
"</tr>";
}
}
//Response.Write(strWrite);
lblWrite.Text = strWrite;
}
protected void btnGoToJournal_Click(object sender, EventArgs e)
{
string strLink = "";
using (EmployeeJournal objEmployeeJournal = new EmployeeJournal())
{
if (EmployeeJournal.HasExistingJournal(Request.Cookies["Speedo"]["UserName"].ToString(), Convert.ToInt16(WeekYear.GetActiveWeekCode())))
{
if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()))).ToString() == "S" && EmployeeJournal.GetLockStatus(Convert.ToInt16(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()))).ToString() == "0")
{
strLink = "JournalEncoding";
Response.Redirect("JournalEncoding.aspx?JournalCode=" + EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()).ToString());
}
else if (EmployeeJournal.GetJournalStatus(Convert.ToInt16(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()))).ToString() == "F" && EmployeeJournal.GetLockStatus(Convert.ToInt16(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()))).ToString() == "0")
{
strLink = "JournalEncodingM";
Response.Redirect("JournalEncodingM.aspx?JournalCode=" + EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()).ToString());
}
else
{
strLink = "JournalViewer";
Response.Redirect("JournalViewer.aspx?JournalCode=" + EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()).ToString());
}
}
else
{
objEmployeeJournal.WeekCode = Convert.ToInt16(WeekYear.GetActiveWeekCode());
objEmployeeJournal.Enabled = "1";
objEmployeeJournal.CreatedBy = Request.Cookies["Speedo"]["UserName"].ToString();
objEmployeeJournal.CreatedOn = DateTime.Now;
objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString();
objEmployeeJournal.ModifiedOn = DateTime.Now;
if (objEmployeeJournal.Insert() > 0)
{
Response.Redirect("JournalEncoding.aspx");
}
}
}
}
