private void BindgvLabReport(string strFromDt, string strToDate) { ApplicationResult objResult = new ApplicationResult(); LabReportBl objLabReportBl = new LabReportBl(); objResult = objLabReportBl.LabReport(strFromDt, strToDate); if (objResult != null) { gvLabReport.DataSource = objResult.ResultDt; gvLabReport.DataBind(); PanelVisibilityMode(true, false); } }
private void BindgvLabReport(string strFromDt, string strToDate) { ApplicationResult objResult = new ApplicationResult(); LabReportBl objLabReportBl = new LabReportBl(); objResult = objLabReportBl.LabReport(strFromDt, strToDate); gvLabReport.DataSource = objResult.ResultDt; gvLabReport.DataBind(); PanelVisibilityMode(true, false); if (gvLabReport.Rows.Count > 0) { divExport.Visible = true; divNo.Visible = false; } else { divExport.Visible = false; divNo.Visible = true; } }
protected void gvLabReport_OnRowCommand(object sender, GridViewCommandEventArgs e) { try { ApplicationResult objResult = new ApplicationResult(); LabReportBl objLabReportBl = new LabReportBl(); if (e.CommandName == "Edit1") { ViewState["ID"] = e.CommandArgument.ToString(); objResult = objLabReportBl.LabReport_Select(Convert.ToInt32(ViewState["ID"].ToString())); if (objResult != null) { if (objResult.ResultDt.Rows.Count > 0) { txtLabDate.Text = objResult.ResultDt.Rows[0]["LabDate"].ToString(); txtVehicleNo.Text = objResult.ResultDt.Rows[0]["VehicleNumber"].ToString(); hfVehicleNo.Value = objResult.ResultDt.Rows[0]["VehicleNumber"].ToString(); hfVehicleId.Value = objResult.ResultDt.Rows[0]["VehicleId"].ToString(); txtVehicleId.Text = objResult.ResultDt.Rows[0]["VehicleCode"].ToString(); txtRouteNo.Text = objResult.ResultDt.Rows[0]["RouteNo"].ToString(); //ddlRouteNo.SelectedValue = objResult.ResultDt.Rows[0]["RouteId"].ToString(); ddlProduct.SelectedValue = objResult.ResultDt.Rows[0]["ProductId"].ToString(); ddlOT.SelectedValue = objResult.ResultDt.Rows[0]["OT"].ToString(); txtTemp.Text = objResult.ResultDt.Rows[0]["Temp"].ToString(); txtFat.Text = objResult.ResultDt.Rows[0]["Fat"].ToString(); txtSNF.Text = objResult.ResultDt.Rows[0]["SNF"].ToString(); txtAcidity.Text = objResult.ResultDt.Rows[0]["Acidity"].ToString(); ddlCOB.SelectedValue = objResult.ResultDt.Rows[0]["COB"].ToString(); txtAlcoholNo.Text = objResult.ResultDt.Rows[0]["AlcoholNo"].ToString(); ddlNeutralizer.SelectedValue = objResult.ResultDt.Rows[0]["Neutralizer"].ToString(); ddlUrea.SelectedValue = objResult.ResultDt.Rows[0]["Urea"].ToString(); ddlSalt.SelectedValue = objResult.ResultDt.Rows[0]["Salt"].ToString(); ddlStartch.SelectedValue = objResult.ResultDt.Rows[0]["Startch"].ToString(); txtFPD.Text = objResult.ResultDt.Rows[0]["FPD"].ToString(); ddlStatus.SelectedValue = objResult.ResultDt.Rows[0]["Status"].ToString(); PanelVisibilityMode(false, true); ViewState["Mode"] = "Edit"; } //ViewState["CheckRoleId"] = ViewState["RoleID"]; } } else if (e.CommandName == "Delete1") { objResult = objLabReportBl.LabReport_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.Userid].ToString()), System.DateTime.UtcNow.AddHours(5.5).ToString()); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { //log.Info("User role has been deleted."); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Deleted Successfully.');</script>"); PanelVisibilityMode(true, false); getDatesofMonth(); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You can not delete this Reception 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>"); //throw ex; } }
protected void btnSave_OnClick(object sender, EventArgs e) { try { if (txtVehicleNo.Text == hfVehicleNo.Value) { LabReportBo objLabReportBo = new LabReportBo(); ApplicationResult objResult = new ApplicationResult(); LabReportBl objLabReportBl = new LabReportBl(); objLabReportBo.LabDate = txtLabDate.Text.Trim(); objLabReportBo.VehicleId = Convert.ToInt32(hfVehicleId.Value); objLabReportBo.VehicleCode = txtVehicleId.Text; // objLabReportBo.RouteId = Convert.ToInt32(ddlRouteNo.SelectedValue); objLabReportBo.ProductId = Convert.ToInt32(ddlProduct.SelectedValue); objLabReportBo.OT = (ddlOT.SelectedValue != "-1") ? Convert.ToInt32(ddlOT.SelectedValue) : -1; objLabReportBo.Temp = (txtTemp.Text != "") ? Convert.ToDouble(txtTemp.Text) : 0.0; objLabReportBo.Fat = (txtFat.Text != "") ? Convert.ToDouble(txtFat.Text) : 0.0; objLabReportBo.SNF = (txtSNF.Text != "") ? Convert.ToDouble(txtSNF.Text) : 0.0; objLabReportBo.Acidity = (txtAcidity.Text != "") ? Convert.ToDouble(txtAcidity.Text) : 0.0; objLabReportBo.COB = (ddlCOB.SelectedValue != "-1") ? ddlCOB.SelectedValue : "-1"; objLabReportBo.AlcoholNo = txtAlcoholNo.Text; objLabReportBo.Neutralizer = (ddlNeutralizer.SelectedValue != "-1") ? ddlNeutralizer.SelectedValue : "-1"; objLabReportBo.Urea = (ddlUrea.SelectedValue != "-1") ? ddlUrea.SelectedValue : "-1"; objLabReportBo.Salt = (ddlSalt.SelectedValue != "-1") ? ddlSalt.SelectedValue : "-1"; objLabReportBo.Startch = (ddlStartch.SelectedValue != "-1") ? ddlStartch.SelectedValue : "-1"; objLabReportBo.FPD = txtFPD.Text; objLabReportBo.Status = Convert.ToInt32(ddlStatus.SelectedValue); if (ViewState["Mode"].ToString() == "Save") { objLabReportBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objLabReportBo.CreatedDate = DateTime.UtcNow.AddHours(5.5); objResult = objLabReportBl.LabReport_Insert(objLabReportBo); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>"); ClearAll(); getDatesofMonth(); PanelVisibilityMode(true, false); } } else if (ViewState["Mode"].ToString() == "Edit") { objLabReportBo.Id = Convert.ToInt32(ViewState["ID"].ToString()); objLabReportBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objLabReportBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5); objResult = objLabReportBl.LabReport_Update(objLabReportBo); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>"); ClearAll(); getDatesofMonth(); PanelVisibilityMode(true, false); } } } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Vehicle No is not exist.');</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>"); } }