public void LoadDetails()
{
ddlJournalYear.DataSource = EmployeeJournal.GetDSLJournalYearsALL();
ddlJournalYear.DataValueField = "pvalue";
ddlJournalYear.DataTextField = "ptext";
ddlJournalYear.DataBind();
ddlJournalDates.DataSource = EmployeeJournal.GetDSLJournalDatesALL(ddlJournalYear.SelectedValue.ToString());
ddlJournalDates.DataValueField = "pvalue";
ddlJournalDates.DataTextField = "ptext";
ddlJournalDates.DataBind();
ddlDivision.DataSource = clsDivision.GetDdlDsBasedOnApproverModule(Request.Cookies["Speedo"]["UserName"].ToString());
ddlDivision.DataValueField = "pvalue";
ddlDivision.DataTextField = "ptext";
ddlDivision.DataBind();
// ddlDivision.SelectedValue = clsEmployee.GetDivisionCode(Request.Cookies["Speedo"]["UserName"].ToString());
ddlDepartment.DataSource = clsDepartment.GetDdlDsBasedOnModuleApprover(ddlDivision.SelectedValue.ToString(), Request.Cookies["Speedo"]["UserName"].ToString());
ddlDepartment.DataValueField = "pvalue";
ddlDepartment.DataTextField = "ptext";
ddlDepartment.DataBind();
//ddlDepartment.SelectedValue = clsEmployee.GetDepartmentCode(Request.Cookies["Speedo"]["UserName"].ToString());
ddlEmployee.DataSource = clsEmployee.DSLEmployeeList(ddlDepartment.SelectedValue.ToString());
ddlEmployee.DataValueField = "pvalue";
ddlEmployee.DataTextField = "ptext";
ddlEmployee.DataBind();
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
using (EmployeeJournal objEmployeeJournal = new EmployeeJournal())
{
objEmployeeJournal.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString());
objEmployeeJournal.JournalStatus = "F";
objEmployeeJournal.LockStatus = "1";
objEmployeeJournal.Enabled = "1";
objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString();
if (objEmployeeJournal.UpdateStatus() > 0)
{
using (EmployeeJournalApproval objEmployeeJournalApproval = new EmployeeJournalApproval())
{
objEmployeeJournalApproval.EmployeeJournalCode = objEmployeeJournal.EmployeeJournalCode;
objEmployeeJournalApproval.JournalApprover = ddlDeptHead.SelectedValue.ToString();
objEmployeeJournalApproval.JournalAStatus = "F";
objEmployeeJournalApproval.JournalAOrder = 1;
objEmployeeJournalApproval.JournalADate = DateTime.Now;
objEmployeeJournalApproval.Insert();
objEmployeeJournalApproval.EmployeeJournalCode = objEmployeeJournal.EmployeeJournalCode;
objEmployeeJournalApproval.JournalApprover = ddlDivHead.SelectedValue.ToString();
objEmployeeJournalApproval.JournalAStatus = "F";
objEmployeeJournalApproval.JournalAOrder = 2;
objEmployeeJournalApproval.JournalADate = DateTime.Now;
objEmployeeJournalApproval.Insert();
}
Response.Redirect("EmployeeJournalList.aspx");
}
}
}
protected void btnApprove_Click(object sender, EventArgs e)
{
using (EmployeeJournal objEmployeeJournal = new EmployeeJournal())
{
//objEmployeeJournal.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString());
objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]);
objEmployeeJournal.LockStatus = "1";
objEmployeeJournal.Enabled = "1";
objEmployeeJournal.JournalStatus = "F";
objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString();
if (objEmployeeJournal.UpdateStatus() > 0)
{
using (EmployeeJournalApproval objEmployeeJournalApproval = new EmployeeJournalApproval())
{
objEmployeeJournalApproval.EmployeeJournalACode = EmployeeJournalApproval.GetForApprovalJournalACode(objEmployeeJournal.EmployeeJournalCode);
objEmployeeJournalApproval.JournalAStatus = "A";
if (EmployeeJournalApproval.GetForApprovalJournalAOrder(objEmployeeJournal.EmployeeJournalCode) == 1)
{
objEmployeeJournalApproval.Remarks = txtDepartmentHeadsRemarks.Text;
}
else if (EmployeeJournalApproval.GetForApprovalJournalAOrder(objEmployeeJournal.EmployeeJournalCode) == 2)
{
objEmployeeJournal.JournalStatus = "A";
objEmployeeJournal.UpdateStatus();
objEmployeeJournalApproval.Remarks = txtDivisionHeadsRemarks.Text;
}
if (objEmployeeJournalApproval.UpdateStatus() > 0)
{
Response.Redirect("EmployeeJournalListA.aspx");
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
txtDepartmentHeadsRemarks.Visible = true;
txtDivisionHeadsRemarks.Visible = true;
txtDepartmentHeadsRemarks.Enabled = false;
txtDivisionHeadsRemarks.Enabled = false;
txtDepartmentHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "1");
txtDivisionHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "2");
lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + ")";
this.MakeCart();
if (EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "1").ToString() == Request.Cookies["Speedo"]["UserName"].ToString())
{
txtDepartmentHeadsRemarks.Enabled = true;
btnApprove.Text = "Approved";
}
if (EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "2").ToString() == Request.Cookies["Speedo"]["UserName"].ToString())
{
txtDivisionHeadsRemarks.Enabled = true;
btnApprove.Text = "Read and Commented";
}
}
}
protected void LoadUpdates()
{
string strWrite = "";
string strStatus = "";
string strLink = "";
string strPreview = "";
string strJournalStatus = "";
string strEmployeeStatDate = "";
string strDepHeadStatus = "";
string strDivHeadStatus = "";
foreach (DataRow drJournal in EmployeeJournal.GetDSG(Convert.ToInt16(ddlJournalYear.SelectedValue), ddlJournalDates.SelectedValue.ToString(), ddlDepartment.SelectedValue.ToString()).Rows)
{
if (drJournal["JournalStatus"].ToString() == "S" && drJournal["LockStatus"].ToString() == "0")
{
strJournalStatus = "Draft";
strEmployeeStatDate = "(Last Log on " + drJournal["ModifiedOn"].ToString() + ")";
strDepHeadStatus = "";
strDivHeadStatus = "";
}
else if (drJournal["JournalStatus"].ToString() == "F")
{
strJournalStatus = "For Approval";
strEmployeeStatDate = "(Submitted on " + drJournal["ModifiedOn"].ToString() + ")";
if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(drJournal["JournalCode"]), "1") == "A")
{
strDepHeadStatus = "(" + EmployeeJournalApproval.GetApproverADate(Convert.ToInt16(drJournal["JournalCode"]), "1") + ")";
}
else
{
strDepHeadStatus = "(Not Yet Approved)";
}
if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(drJournal["JournalCode"]), "2") == "A")
{
strDivHeadStatus = "(" + EmployeeJournalApproval.GetApproverADate(Convert.ToInt16(drJournal["JournalCode"]), "2") + ")";
}
else
{
strDivHeadStatus = "(Not Yet Approved)";
}
}
else if (drJournal["JournalStatus"].ToString() == "A")
{
strJournalStatus = "Approved";
strEmployeeStatDate = "(Submitted on " + drJournal["ModifiedOn"].ToString() + ")";
strDepHeadStatus = "";
strDivHeadStatus = "";
}
strLink = "JournalViewer";
strWrite = strWrite + "<tr>" +
"<td class='GridRows'>" + clsEmployee.GetName(drJournal["CreatedBy"].ToString()) + "<br />" + strEmployeeStatDate + "</td>" +
"<td class='GridRows'>" + strJournalStatus + "</td>" +
"<td class='GridRows'>" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(drJournal["JournalCode"]), "1") + "<br />" + strDepHeadStatus + "</td>" +
//"<td class='GridRows'>" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(drJournal["JournalCode"]), "2") + "<br />" + strDivHeadStatus + "</td>" +
"</tr>";
}
//Response.Write(strWrite);
lblWrite.Text = strWrite;
}
protected void Page_Load(object sender, EventArgs e)
{
lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + ")";
this.MakeCart();
lblDeptApprover.Text = "(" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") + ")";
lblDepartmentHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "1");
lblDivApprover.Text = "(" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") + ")";
lblDivisionHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "2");
}
public void LoadContents()
{
using (EmployeeJournal objEmployeeJournal = new EmployeeJournal())
{
//objEmployeeJournal.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString());
objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]);
objEmployeeJournal.Fill2();
ckeContents.Text = objEmployeeJournal.Contents;
}
}
protected void btnDraft_Click(object sender, EventArgs e)
{
using (EmployeeJournal objEmployeeJournal = new EmployeeJournal())
{
if (objEmployeeJournal.Update() > 0)
{
Response.Redirect("EmployeeJournalList.aspx");
}
}
}
public void LoadContent()
{
using (EmployeeJournal objEmployeeJournal = new EmployeeJournal())
{
//objEmployeeJournal.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString());
objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]);
objEmployeeJournal.Fill2();
litContent.Text = objEmployeeJournal.Contents;
lblSubmittedDetails.Text = objEmployeeJournal.ModifiedBy + " " + "(" + objEmployeeJournal.ModifiedOn + ")";
//litContent.Text += "<font style='font-size:14px;'>" + objEmployeeJournal.Contents + "</font>";
}
}
protected void MakeCart()
{
DataTable tblCart = new DataTable("Cart");
tblCart.Columns.Add("JournalDCode", System.Type.GetType("System.String"));
tblCart.Columns.Add("JournalCode", System.Type.GetType("System.String"));
tblCart.Columns.Add("ItemNumber", System.Type.GetType("System.String"));
tblCart.Columns.Add("Contents", System.Type.GetType("System.String"));
tblCart = EmployeeJournalDetails.GetDSGCart(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()));
ViewState["Cart"] = tblCart;
LoadGrid();
}
public void LoadContent()
{
using (EmployeeJournal objEmployeeJournal = new EmployeeJournal())
{
objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]);
objEmployeeJournal.Fill2();
//lblSubmittedDetails.Text = "<br />Submitted By: " + objEmployeeJournal.ModifiedBy + "<br />" + "Submitted On: " + objEmployeeJournal.ModifiedOn;
lblSubmittedDetails.Text = objEmployeeJournal.ModifiedBy + " " + "(" + objEmployeeJournal.ModifiedOn + ")";
//litContent.Text += "<font style='font-size:14px;'>" + objEmployeeJournal.Contents + "</font>";
litContent.Text = objEmployeeJournal.Contents;
}
}
protected void Page_Load(object sender, EventArgs e)
{
clsSpeedo.Authenticate();
if (!Page.IsPostBack)
{
string strDeptDetails = "", strDivDetails = "";
string strDeptStatus = "", strDivStatus = "";
lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + ")";
this.MakeCart();
this.LoadContent();
//lblDeptApprover.Text = "(" + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") + ")";
try
{
lblDepartmentHeadsRemarks.Text = EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "1");
if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") == "F")
{
strDeptStatus = "For Review";
}
else if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") == "A")
{
strDeptStatus = "Reviewed";
}
else if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") == "F")
{
strDeptStatus = "Disapproved";
}
strDeptDetails = "Reviewer: " + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "1") + "<br />" +
"Status: " + strDeptStatus + "<br />" +
"Remarks: <br />" + EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "1");
lblDepartmentHeadsRemarks.Text = strDeptDetails;
}
catch { }
//if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") == "F")
//{
// strDivStatus = "For Approval";
//}
//else if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") == "A")
//{
// strDivStatus = "Approved";
//}
//else if (EmployeeJournalApproval.GetApproverAStatus(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") == "F")
//{
// strDivStatus = "Disapproved";
//}
//strDivDetails = "Approver: " + EmployeeJournalApproval.GetApprover(Convert.ToInt16(Request.QueryString["JournalCode"]), "2") + "<br />" +
// "Status: " + strDivStatus + "<br />" +
// "Remarks: <br />" + EmployeeJournalApproval.GetRemarks(Convert.ToInt16(Request.QueryString["JournalCode"]), "2");
//lblDivisionHeadsRemarks.Text = strDivDetails;
}
}
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 ddlJournalYear_SelectedIndexChanged(object sender, EventArgs e)
{
ddlJournalDates.DataSource = EmployeeJournal.GetDSLJournalDatesALL(ddlJournalYear.SelectedValue.ToString());
ddlJournalDates.DataValueField = "pvalue";
ddlJournalDates.DataTextField = "ptext";
ddlJournalDates.DataBind();
try
{
ddlJournalDates.SelectedValue = WeekYear.GetActiveWeekCode();
}
catch { }
}
protected void btnFinalize_Click(object sender, EventArgs e)
{
ViewState["JournalCode"] = Request.QueryString["JournalCode"];
if (lblReviewer.ForeColor == Color.Black)
{
string confirmValue = Request.Form["confirm_value"];
if (confirmValue == "Yes")
{
using (EmployeeJournal objEmployeeJournal = new EmployeeJournal())
{
objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]);
objEmployeeJournal.JournalStatus = "F";
objEmployeeJournal.LockStatus = "1";
objEmployeeJournal.Enabled = "1";
objEmployeeJournal.Contents = ckeContents.Text.Replace("style=\"display: none\"", "");
objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString();
if (objEmployeeJournal.UpdateStatus() > 0)
{
using (EmployeeJournalApproval objEmployeeJournalApproval = new EmployeeJournalApproval())
{
objEmployeeJournalApproval.EmployeeJournalCode = objEmployeeJournal.EmployeeJournalCode;
objEmployeeJournalApproval.JournalApprover = EmployeeReviewer.GetReviewer(Request.Cookies["Speedo"]["UserName"].ToString());
objEmployeeJournalApproval.JournalAStatus = "F";
objEmployeeJournalApproval.JournalAOrder = 1;
objEmployeeJournalApproval.JournalADate = DateTime.Now;
objEmployeeJournalApproval.Insert();
objEmployeeJournal.SendNotification(EmployeeJournal.EJSMailType.FiledAcknowledgementRequestor, Request.Cookies["Speedo"]["UserName"].ToString(), EmployeeReviewer.GetReviewer(Request.Cookies["Speedo"]["UserName"].ToString()));
objEmployeeJournal.SendNotification(EmployeeJournal.EJSMailType.FiledNotificationApprover, Request.Cookies["Speedo"]["UserName"].ToString(), EmployeeReviewer.GetReviewer(Request.Cookies["Speedo"]["UserName"].ToString()));
}
Response.Redirect("EmployeeJournalList.aspx");
}
}
}
else
{
using (EmployeeJournal objEmployeeJournal = new EmployeeJournal())
{
objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]);
objEmployeeJournal.Contents = ckeContents.Text;
objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString();
objEmployeeJournal.ModifiedOn = DateTime.Now;
if (objEmployeeJournal.Update() > 0)
{
Response.Redirect("JournalEncoding.aspx?JournalCode=" + Request.QueryString["JournalCode"]);
}
}
}
}
}
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 btnPreview_Click(object sender, EventArgs e)
{
using (EmployeeJournal objEmployeeJournal = new EmployeeJournal())
{
//objEmployeeJournal.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString());
objEmployeeJournal.EmployeeJournalCode = Convert.ToInt16(Request.QueryString["JournalCode"]);
objEmployeeJournal.Contents = ckeContents.Text.Replace("style=\"display: none\"", "");
objEmployeeJournal.ModifiedBy = Request.Cookies["Speedo"]["UserName"].ToString();
objEmployeeJournal.ModifiedOn = DateTime.Now;
if (objEmployeeJournal.Update() > 0)
{
Response.Redirect("JournalViewer.aspx?JournalCode=" + Request.QueryString["JournalCode"]);
}
}
}
public void LoadDetails()
{
ddlJournalYear.DataSource = EmployeeJournal.GetDSLJournalYearsALL();
ddlJournalYear.DataValueField = "pvalue";
ddlJournalYear.DataTextField = "ptext";
ddlJournalYear.DataBind();
ddlJournalDates.DataSource = EmployeeJournal.GetDSLJournalDatesALL(ddlJournalYear.SelectedValue.ToString());
ddlJournalDates.DataValueField = "pvalue";
ddlJournalDates.DataTextField = "ptext";
ddlJournalDates.DataBind();
try
{
ddlJournalDates.SelectedValue = WeekYear.GetActiveWeekCode();
}
catch { }
}
protected void LoadUpdates()
{
string strWrite = "";
string strStatus = "";
string strLink = "";
string strPreview = "";
foreach (DataRow drJournal in EmployeeJournal.GetDSGForApproval(Request.Cookies["Speedo"]["UserName"]).Rows)
{
strLink = "JournalViewerA";
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>" +
"Submitted by: " + drJournal["ModifiedBy"].ToString() + "<br />" +
"Submitted On: " + drJournal["ModifiedOn"].ToString() + "<br />" +
"</td>" +
"</tr>";
}
Response.Write(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");
}
}
}
}
public void LoadDueValidation()
{
//Response.Write(WeekYear.GetDateDue(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"]))).AddHours(9).ToString());
//Response.Write("<br> " + DateTime.Now.ToString());
//Response.Write(Convert.ToDateTime("11/12/2015 4:50:17 PM").ToString());
if (WeekYear.GetDateDue(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"]))).AddHours(9) < DateTime.Now)
//if (Convert.ToDateTime("11/12/2015 4:57:00 PM") < DateTime.Now)
{
if (JournalExceptions.CountIfExist(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])), Request.Cookies["Speedo"]["UserName"].ToString()) > 0)
{
btnDraft.Enabled = true;
btnFinalize.Enabled = true;
btnPreview.Enabled = true;
}
else
{
btnDraft.Enabled = false;
btnFinalize.Enabled = false;
btnPreview.Enabled = false;
}
}
}
public static int InputIndexValidation()
{
int value;
while (!int.TryParse(Console.ReadLine(), out value) || value < 0)
{
Console.WriteLine("Please enter a valid positive number");
}
if (value < EmployeeJournal.GetEmployees().Length)
{
EmployeeJournal.RemoveAt(value);
Console.WriteLine($"The employee on index {value} was succesffully removed from the list");
Console.WriteLine();
}
else
{
Console.WriteLine("There is no such employee");
}
return(value);
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (EmployeeJournalDetails objEmployeeJournalDetails = new EmployeeJournalDetails())
{
objEmployeeJournalDetails.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString());
objEmployeeJournalDetails.Contents = txtContents.Text;
objEmployeeJournalDetails.ItemNumber = EmployeeJournalDetails.GetTotalRecords(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString())) + 1;
objEmployeeJournalDetails.JournalDate = DateTime.Now;
objEmployeeJournalDetails.CreatedOn = DateTime.Now;
objEmployeeJournalDetails.EndorsedBy = "NA";
objEmployeeJournalDetails.EndorsedOn = DateTime.Now;
objEmployeeJournalDetails.EndoredRemarks = "NA";
objEmployeeJournalDetails.ApprovedBy = "NA";
objEmployeeJournalDetails.ApprovedOn = DateTime.Now;
objEmployeeJournalDetails.ApprovedRemarks = "NA";
objEmployeeJournalDetails.JournalStatus = "F";
objEmployeeJournalDetails.IsEnabled = "1";
if (objEmployeeJournalDetails.Insert() > 0)
{
Response.Redirect("JournalEncodingM.aspx?JournalCode=" + ViewState["JournalCode"].ToString());
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
clsSpeedo.Authenticate();
this.LoadDueValidation();
if (!Page.IsPostBack)
{
//lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(WeekYear.GetActiveWeekCode())).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(WeekYear.GetActiveWeekCode())).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(WeekYear.GetActiveWeekCode())).ToString("MMM dd, yyyy") + ")";
lblWeekDates.Text = WeekYear.GetWeekName(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString() + " (" + WeekYear.GetDateStart(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + " - " + WeekYear.GetDateEnd(Convert.ToInt16(EmployeeJournal.GetWeekCode(Convert.ToInt16(Request.QueryString["JournalCode"])))).ToString("MMM dd, yyyy") + ")";
this.MakeCart();
this.LoadDSLs();
this.LoadContents();
if (EmployeeReviewer.GetReviewer(Request.Cookies["Speedo"]["UserName"].ToString()).Length > 0)
{
lblReviewer.ForeColor = Color.Black;
lblReviewer.Text = EmployeeReviewer.GetReviewer(Request.Cookies["Speedo"]["UserName"].ToString());
}
else
{
lblReviewer.ForeColor = Color.Red;
lblReviewer.Text = "No assigned reviewer.";
}
}
}
static void Main(string[] args)
{
EmployeeJournal.OpenFile();
do
{
Console.Clear();
Console.WriteLine("=======MENU=======");
Console.WriteLine("1. Add new employee");
Console.WriteLine("2. Check all employees");
Console.WriteLine("3. Remove employee");
Console.WriteLine("4. Total hours worked by the team");
Console.WriteLine("5. Exit");
Menu menu = (Menu)InputIntValidation();
switch (menu)
{
case Menu.AddNewEmployee:
{
Console.Clear();
Console.Write("Please enter the passport number of the employee: ");
int passport = InputIntValidation();
Console.Write("Please enter the name of the employee: ");
string name = Console.ReadLine();
Console.Write("Please enter the age of the employee: ");
int age = InputIntValidation();
Console.Write("Please enter the position of the employee: ");
string position = Console.ReadLine();
Console.Write("Please enter the name of the team: ");
string team = Console.ReadLine();
Console.Write("Please enter the number of hours worked: ");
double hoursWorked = InputDoubleValidation();
Employee employee = new Employee
(
passport: passport,
name: name,
age: age,
position: position,
team: team,
hoursWorked: hoursWorked
);
EmployeeJournal.Add(employee);
}
break;
case Menu.CheckEmployees:
{
Console.Clear();
foreach (var employee in EmployeeJournal.GetEmployees())
{
Console.WriteLine($"==========\n{employee}");
}
Console.ReadKey();
}
break;
case Menu.RemoveEmployee:
{
Console.Write("Please enter the index of the emplyoyee you would like to remove: ");
InputIndexValidation();
Console.ReadKey();
}
break;
case Menu.TeamHoursWorked:
{
Console.Write("Please enter the name of the team: ");
string team = Console.ReadLine();
double teamHoursWorked = EmployeeJournal.TeamHours(team);
Console.WriteLine($"The total hours worked by team {team}: {teamHoursWorked}");
Console.ReadKey();
} break;
case Menu.Exit:
{
EmployeeJournal.SaveToFile();
return;
}
default:
{
Console.WriteLine("There is no such command");
}
break;
}
} while (true);
}
private async Task View_Loading()
{
try
{
var main = View.Main;
_usersJournal = new EmployeeJournal(main.DGV_Employees, true);
_workingHoursJournal = new WorkingHourJournal(main.DGV_WorkingHours);
_unitsJournal = new UnitJournal(main.DGV_Unit);
_nomenclaturesJournal = new NomenclatureJournal(main.DGV_Nomenclatures);
_optionsJournal = new OptionJournal(main.DGV_Options);
_reasonsJournal = new ReasonJournal(main.DGV_Reasons);
_marksJournal = new MarkJournal(main.DGV_Marks);
_modelsJournal = new ModelJournal(main.DGV_Models);
_contractorsJournal = new ContractorJournal(main.DGV_Contractors);
_applicationsJournal = new ApplicationJournal(main.DGV_Apptications);
using (var context = new DbSSContext())
{
int countViewСontractor = await context.ViewСontractor.CountAsync();
int countTypeManifestation = await context.TypeManifestation.CountAsync();
int countTypeRepair = await context.TypeRepair.CountAsync();
var countTypeNomenclature = await context.TypeNomenclature.CountAsync();
if (countViewСontractor == 0)
{
List <ViewСontractorModel> view = new List <ViewСontractorModel>()
{
new ViewСontractorModel {
View = "Юридическое лицо"
},
new ViewСontractorModel {
View = "Физическое лицо"
}
};
context.ViewСontractor.AddRange(view);
}
if (countTypeManifestation == 0)
{
List <TypeManifestationModel> type = new List <TypeManifestationModel>()
{
new TypeManifestationModel {
Type = "Внешнее"
},
new TypeManifestationModel {
Type = "Втуреннее"
}
};
context.TypeManifestation.AddRange(type);
}
if (countTypeRepair == 0)
{
List <TypeRepairModel> type = new List <TypeRepairModel>()
{
new TypeRepairModel {
Type = "Гарантийный"
},
new TypeRepairModel {
Type = "Текущий"
}
};
context.TypeRepair.AddRange(type);
}
if (countTypeNomenclature == 0)
{
List <TypeNomenclatureModel> type = new List <TypeNomenclatureModel>()
{
new TypeNomenclatureModel {
Type = "Товар"
},
new TypeNomenclatureModel {
Type = "Работа"
}
};
context.TypeNomenclature.AddRange(type);
}
await context.SaveChangesAsync();
}
await _applicationsJournal.Update();
}
catch (Exception ex)
{
ShowError(ex.Message);
}
}
