private void BindgvBreakdowneMaintainance() { try { MaintainanceBL objBreakdowneMaintainanceBl = new MaintainanceBL(); var objResult = objBreakdowneMaintainanceBl.Maintainance_SelectAll_ForBreakDown(1); if (objResult != null) { if (objResult.ResultDt.Rows.Count > 0) { gvBreakdownMaintainance.DataSource = objResult.ResultDt; gvBreakdownMaintainance.DataBind(); PanelVisibilityMode(true, false); } else { PanelVisibilityMode(false, true); } } } catch (Exception ex) { throw ex; } }
protected void btnGo_OnClick(object sender, EventArgs e) { try { MaintainanceBL objMaintainanceBl = new MaintainanceBL(); DateTime dtFromDate = DateTime.ParseExact(txtFromDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); DateTime dtToDate = DateTime.ParseExact(txtToDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); var objResult = objMaintainanceBl.Maintainance_SelectAll_forRoutineReport(dtFromDate, dtToDate, 0); gvRoutine.DataSource = objResult.ResultDt; gvRoutine.DataBind(); if (gvRoutine.Rows.Count > 0) { divExport.Visible = true; divNo.Visible = false; } else { divExport.Visible = false; divNo.Visible = true; } } catch (Exception ex) { log.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>"); } }
private void BindgvMaintainance() { ApplicationResult objResult = new ApplicationResult(); MaintainanceBL objRoutineMaintainanceBl = new MaintainanceBL(); objResult = objRoutineMaintainanceBl.Maintainance_SelectAll_forDashboard(); if (objResult != null) { //gvMaintainance.DataSource = objResult.ResultDt; //gvMaintainance.DataBind(); } }
private void BindgvRoutineMaintainance() { try { MaintainanceBL objRoutineMaintainanceBl = new MaintainanceBL(); var objResult = objRoutineMaintainanceBl.Maintainance_SelectAll(0); if (objResult != null) { gvRoutineMaintainance.DataSource = objResult.ResultDt; gvRoutineMaintainance.DataBind(); PanelVisibilityMode(true, false); } } catch (Exception ex) { throw ex; } }
protected void btnSave_OnClick(object sender, EventArgs e) { try { MaintainanceBo objBreakdowneMaintainanceBo = new MaintainanceBo(); //ApplicationResult objResult = new ApplicationResult(); MaintainanceBL objBreakdowneMaintainanceBl = new MaintainanceBL(); objBreakdowneMaintainanceBo.EquipmentTagNo = (txtEquipmentNo.Text.Trim()); objBreakdowneMaintainanceBo.EquipmentName = (txtEquipmentName.Text.Trim()); objBreakdowneMaintainanceBo.MaintainanceDate = DateTime.ParseExact(txtMaintainanceDate.Text.Trim(), "dd/MM/yyyy", CultureInfo.InvariantCulture); objBreakdowneMaintainanceBo.StartTime = DateTime.ParseExact(txtStartDate.Text.Trim(), "HH:mm:ss", CultureInfo.InvariantCulture); objBreakdowneMaintainanceBo.EndTime = DateTime.ParseExact(txtEndDate.Text.Trim(), "HH:mm:ss", CultureInfo.InvariantCulture); objBreakdowneMaintainanceBo.PartNo = txtPartNo.Text.Trim(); objBreakdowneMaintainanceBo.PartName = txtPartName.Text.Trim(); objBreakdowneMaintainanceBo.Section = txtSection.Text.Trim(); objBreakdowneMaintainanceBo.Cause = txtCause.Text.Trim(); objBreakdowneMaintainanceBo.DetailBreakDown = txtDetailBreakdown.Text.Trim(); objBreakdowneMaintainanceBo.Area = txtArea.Text.Trim(); objBreakdowneMaintainanceBo.Department = txtDepartment.Text.Trim(); objBreakdowneMaintainanceBo.ActionTaken = txtAction.Text.Trim(); objBreakdowneMaintainanceBo.RectifiedBy = txtRectified.Text.Trim(); objBreakdowneMaintainanceBo.Remark = txtRemark.Text.Trim(); objBreakdowneMaintainanceBo.UserId = Convert.ToInt32(Session[ApplicationSession.Userid]); objBreakdowneMaintainanceBo.Type = 1; objBreakdowneMaintainanceBo.IsBreackDown = 1; switch (ViewState["Mode"].ToString()) { case "Save": objBreakdowneMaintainanceBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objBreakdowneMaintainanceBo.CreatedDate = DateTime.UtcNow.AddHours(5.5); break; case "Edit": objBreakdowneMaintainanceBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objBreakdowneMaintainanceBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5); break; } if (ViewState["Mode"].ToString() == "Save") { var objResult = objBreakdowneMaintainanceBl.Maintainance_Insert_ForBreakdown(objBreakdowneMaintainanceBo); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>"); ClearAll(); BindgvBreakdowneMaintainance(); // PanelVisibilityMode(true, false); } } else if (ViewState["Mode"].ToString() == "Edit") { objBreakdowneMaintainanceBo.Id = Convert.ToInt32(ViewState["BreakdowneMaintainanceID"].ToString()); var objResult = objBreakdowneMaintainanceBl.Maintainance_Update_ForBreakdown(objBreakdowneMaintainanceBo); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>"); ClearAll(); BindgvBreakdowneMaintainance(); // PanelVisibilityMode(true, false); } } } catch (Exception ex) { log.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>"); } }
protected void gvBreakdownMaintainance_OnRowCommand(object sender, GridViewCommandEventArgs e) { try { MaintainanceBL objBreakdowneMaintainanceBL = new MaintainanceBL(); if (e.CommandName == "Edit1") { ViewState["Mode"] = "Edit"; ViewState["BreakdowneMaintainanceID"] = e.CommandArgument.ToString(); var objResult = objBreakdowneMaintainanceBL.Maintainance_Select(Convert.ToInt32(ViewState["BreakdowneMaintainanceID"].ToString())); if (objResult != null) { if (objResult.Status == ApplicationResult.CommonStatusType.Success) { if (objResult.ResultDt.Rows.Count > 0) { txtEquipmentNo.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_EQUIPMENTTAGNO].ToString(); txtEquipmentName.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_EQUIPMENTTAGNO].ToString(); txtMaintainanceDate.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_MAINTAINANCEDATE].ToString(); txtStartDate.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_STARTTIME].ToString(); txtEndDate.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_ENDTIME].ToString(); txtPartNo.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_PARTNO].ToString(); txtPartName.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_PARTNAME].ToString(); txtSection.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_SECTION].ToString(); txtCause.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_CAUSE].ToString(); txtDetailBreakdown.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_DETAILBREAKDOWN].ToString(); txtAction.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_ACTIONTAKEN].ToString(); txtRectified.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_RECTIFIEDBY].ToString(); txtRemark.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_REMARK].ToString(); txtArea.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_AREA].ToString(); txtDepartment.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_DEPARTMENT].ToString(); PanelVisibilityMode(false, true); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You can not Update this BreakdowneMaintainance because it is in used.');</script>"); } } } } else if (e.CommandName == "Delete1") { var objResult = objBreakdowneMaintainanceBL.Maintainance_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.Userid].ToString()), DateTime.UtcNow.AddHours(5.5).ToString()); var objRes = objResult.ResultDt.Rows[0]["Id"].ToString(); //if (objResult.Status == ApplicationResult.CommonStatusType.Success) if (objRes == "Completed") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Deleted Successfully.');</script>"); // PanelVisibilityMode(true, false); BindgvBreakdowneMaintainance(); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You can not delete this BreakdowneMaintainance because it is in used.');</script>"); } } else if (e.CommandName == "Status1") { var objResult = objBreakdowneMaintainanceBL.Maintainance_UpdateStatusForBreackDown(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.Userid]), DateTime.UtcNow.AddHours(5.5).ToString()); var objRes = objResult.ResultDt.Rows[0]["Id"].ToString(); //if (objResult.Status == ApplicationResult.CommonStatusType.Success) if (objRes == "Completed") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Breakdowne Maintainance status change Successfully.');</script>"); // PanelVisibilityMode(true, false); BindgvBreakdowneMaintainance(); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You can not Status change this BreakdowneMaintainance because it is in used.');</script>"); } } } catch (Exception ex) { log.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>"); } }
protected void btnSave_OnClick(object sender, EventArgs e) { try { if (Page.IsValid) { MaintainanceBo objRoutineMaintainanceBo = new MaintainanceBo(); MaintainanceBL objRoutineMaintainanceBl = new MaintainanceBL(); objRoutineMaintainanceBo.EquipmentTagNo = (txtEquipmentNo.Text.Trim()); objRoutineMaintainanceBo.EquipmentName = (txtEquipmentName.Text.Trim()); objRoutineMaintainanceBo.MaintainanceDate = DateTime.ParseExact(txtMaintainanceDate.Text.Trim(), "dd/MM/yyyy", CultureInfo.InvariantCulture); objRoutineMaintainanceBo.StartTime = DateTime.ParseExact(txtStartDate.Text.Trim(), "HH:mm:ss", CultureInfo.InvariantCulture); objRoutineMaintainanceBo.EndTime = DateTime.ParseExact(txtEndDate.Text.Trim(), "HH:mm:ss", CultureInfo.InvariantCulture); objRoutineMaintainanceBo.PartNo = txtPartNo.Text.Trim(); objRoutineMaintainanceBo.PartName = txtPartName.Text.Trim(); objRoutineMaintainanceBo.Section = txtSection.Text.Trim(); objRoutineMaintainanceBo.DueDate = DateTime.ParseExact(txtDueDate.Text.Trim(), "dd/MM/yyyy", CultureInfo.InvariantCulture); objRoutineMaintainanceBo.NextDueDate = DateTime.ParseExact(txtNextDueDate.Text.Trim(), "dd/MM/yyyy", CultureInfo.InvariantCulture); objRoutineMaintainanceBo.Department = txtDepartment.Text.Trim(); objRoutineMaintainanceBo.Area = txtArea.Text.Trim(); //objRoutineMaintainanceBo.DueDate = DateTime.ParseExact(txtDueDate.Text.Trim(), "dd/MM/yyyy", // CultureInfo.InvariantCulture); //objRoutineMaintainanceBo.NextDueDate = (txtNextDueDate.Text != "") // ? DateTime.ParseExact(txtNextDueDate.Text.Trim(), "dd/MM/yyyy", CultureInfo.InvariantCulture) // : DateTime.ParseExact("01/01/2015", "dd/MM/yyyy", CultureInfo.InvariantCulture); //objRoutineMaintainanceBo.NextDueDate = ; objRoutineMaintainanceBo.ActionTaken = txtAction.Text.Trim(); objRoutineMaintainanceBo.RectifiedBy = txtRectified.Text.Trim(); objRoutineMaintainanceBo.Remark = txtRemark.Text.Trim(); objRoutineMaintainanceBo.Type = 0; objRoutineMaintainanceBo.UserId = Convert.ToInt32(Session[ApplicationSession.Userid]); objRoutineMaintainanceBo.IsBreackDown = 0; if (ViewState["Mode"].ToString() == "Save") { objRoutineMaintainanceBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objRoutineMaintainanceBo.CreatedDate = DateTime.UtcNow.AddHours(5.5); var objResult = objRoutineMaintainanceBl.Maintainance_Insert(objRoutineMaintainanceBo); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>"); ClearAll(); BindgvRoutineMaintainance(); PanelVisibilityMode(true, false); } } else if (ViewState["Mode"].ToString() == "Edit") { objRoutineMaintainanceBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objRoutineMaintainanceBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5); objRoutineMaintainanceBo.Id = Convert.ToInt32(ViewState["RoutineMaintainanceID"].ToString()); var objResult = objRoutineMaintainanceBl.Maintainance_Update(objRoutineMaintainanceBo); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>"); ClearAll(); BindgvRoutineMaintainance(); PanelVisibilityMode(true, false); } } else if (ViewState["Mode"].ToString() == "Status") { objRoutineMaintainanceBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objRoutineMaintainanceBo.CreatedDate = DateTime.UtcNow.AddHours(5.5); MaintainanceBL objRoutineMaintainanceBL = new MaintainanceBL(); var objResult = objRoutineMaintainanceBL.Maintainance_UpdateStatus(objRoutineMaintainanceBo, Convert.ToInt32(ViewState["RoutineStatusID"].ToString())); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Routine Maintainance status change Successfully.');</script>"); PanelVisibilityMode(true, false); BindgvRoutineMaintainance(); } } } } catch (Exception ex) { log.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>"); } }
protected void gvRoutineMaintainance_OnRowCommand(object sender, GridViewCommandEventArgs e) { try { MaintainanceBL objRoutineMaintainanceBL = new MaintainanceBL(); ClearAll(); if (e.CommandName == "Edit1" && e.CommandArgument.ToString().Split('~')[1] != "Completed") { ViewState["Mode"] = "Edit"; ViewState["RoutineMaintainanceID"] = e.CommandArgument.ToString().Split('~')[0]; var objResult = objRoutineMaintainanceBL.Maintainance_Select_Routine(Convert.ToInt32(ViewState["RoutineMaintainanceID"].ToString())); if (objResult != null) { if (objResult.ResultDt.Rows.Count > 0) { txtEquipmentNo.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_EQUIPMENTTAGNO].ToString(); txtEquipmentName.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_EQUIPMENTNAME].ToString(); txtMaintainanceDate.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_MAINTAINANCEDATE].ToString(); txtStartDate.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_STARTTIME].ToString(); txtEndDate.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_ENDTIME].ToString(); txtPartNo.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_PARTNO].ToString(); txtPartName.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_PARTNAME].ToString(); txtSection.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_SECTION].ToString(); txtArea.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_AREA].ToString(); txtDepartment.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_DEPARTMENT].ToString(); txtDueDate.Text = objResult.ResultDt.Rows[0]["DueDate"].ToString(); txtNextDueDate.Text = objResult.ResultDt.Rows[0]["NextDueDate"].ToString(); //txtDueDate.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_DUEDATE].ToString(); //if (objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_NEXTDUEDATE].ToString() == // "01/01/2015") //{ // txtNextDueDate.Text = ""; //} //else //{ //txtNextDueDate.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_NEXTDUEDATE].ToString(); //} txtAction.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_ACTIONTAKEN].ToString(); txtRectified.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_RECTIFIEDBY].ToString(); txtRemark.Text = objResult.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_REMARK].ToString(); PanelVisibilityMode(false, true); } } } else if (e.CommandName == "Delete1" && e.CommandArgument.ToString().Split('~')[1] != "Completed") { var objResult = objRoutineMaintainanceBL.Maintainance_Delete(Convert.ToInt32(e.CommandArgument.ToString().Split('~')[0]), Convert.ToInt32(Session[ApplicationSession.Userid].ToString()), System.DateTime.UtcNow.AddHours(5.5).ToString()); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Deleted Successfully.');</script>"); PanelVisibilityMode(true, false); BindgvRoutineMaintainance(); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You can not delete this RoutineMaintainance because it is in used.');</script>"); } } else if (e.CommandName == "Status1" && e.CommandArgument.ToString().Split('~')[1] != "Completed") { ViewState["Mode"] = "Status"; ViewState["RoutineStatusID"] = e.CommandArgument.ToString().Split('~')[0]; rfAction.Enabled = true; rfNextDueDate.Enabled = true; rfRectified.Enabled = true; var objResultStatus = objRoutineMaintainanceBL.Maintainance_Select_Routine(Convert.ToInt32(ViewState["RoutineStatusID"].ToString())); if (objResultStatus != null) { if (objResultStatus.ResultDt.Rows.Count > 0) { txtEquipmentNo.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_EQUIPMENTTAGNO].ToString(); txtEquipmentName.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_EQUIPMENTNAME].ToString(); txtMaintainanceDate.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_MAINTAINANCEDATE].ToString(); txtStartDate.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_STARTTIME].ToString(); txtEndDate.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_ENDTIME].ToString(); txtPartNo.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_PARTNO].ToString(); txtPartName.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_PARTNAME].ToString(); txtSection.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_SECTION].ToString(); txtArea.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_AREA].ToString(); txtDepartment.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_DEPARTMENT].ToString(); txtDueDate.Text = objResultStatus.ResultDt.Rows[0]["DueDate"].ToString(); txtNextDueDate.Text = objResultStatus.ResultDt.Rows[0]["NextDueDate"].ToString(); //txtDueDate.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_DUEDATE].ToString(); //if (objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_NEXTDUEDATE].ToString() == // "01/01/2015") //{ // txtNextDueDate.Text = ""; //} //else //{ // txtNextDueDate.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_NEXTDUEDATE].ToString(); //} txtAction.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_ACTIONTAKEN].ToString(); txtRectified.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_RECTIFIEDBY].ToString(); txtRemark.Text = objResultStatus.ResultDt.Rows[0][MaintainanceBo.MAINTAINANCE_REMARK].ToString(); PanelVisibilityMode(false, true); } } } } catch (Exception ex) { log.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>"); } }