private void BindgvReception() { ReceptionBl objReceptionBl = new ReceptionBl(); var objResult = objReceptionBl.Reception_SelectAll(); if (objResult != null) { gvReception.DataSource = objResult.ResultDt; gvReception.DataBind(); PanelVisibilityMode(true, false); } }
//#region Bind Tanker Id //protected void BindTankerId() //{ // //ddlTankerID.Items.Clear(); // Controls objControls = new Controls(); // DateTime dtFromDateTime = DateTime.ParseExact(txtFromDate.Text + " " + txtFromTime.Text, "dd/MM/yyyy HH:mm:ss", // CultureInfo.InvariantCulture); // DateTime dtToDateTime = DateTime.ParseExact(txtToDate.Text + " " + txtToTime.Text, "dd/MM/yyyy HH:mm:ss", // CultureInfo.InvariantCulture); // Reception_PLCBl objReceptionPlcBl = new Reception_PLCBl(); // var objResult = objReceptionPlcBl.Reception_PLC_SelectAll(Convert.ToInt32(ddlReceptionLineNo.SelectedValue),dtFromDateTime,dtToDateTime); // if (objResult != null) // { // if (objResult.ResultDt.Rows.Count > 0) // { // objControls.BindDropDown_ListBox(objResult.ResultDt, ddlTankerID, "Tanker_ID", "Tanker_ID"); // } // ddlTankerID.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1")); // } //} //#endregion #region Bind Reception Line NO protected void BindReceptionLineNo() { Controls objControls = new Controls(); ReceptionBl objReceptionBl = new ReceptionBl(); var objResult = objReceptionBl.Reception_SelectAll(); if (objResult != null) { if (objResult.ResultDt.Rows.Count > 0) { objControls.BindDropDown_ListBox(objResult.ResultDt, ddlReceptionLineNo, "Name", "PLCValue"); } ddlReceptionLineNo.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1")); } }
protected void gvReception_OnRowCommand(object sender, GridViewCommandEventArgs e) { try { ReceptionBl objReceptionBL = new ReceptionBl(); if (e.CommandName == "Edit1") { ViewState["Mode"] = "Edit"; ViewState["ReceptionID"] = e.CommandArgument.ToString(); var objResult = objReceptionBL.Reception_Select(Convert.ToInt32(ViewState["ReceptionID"].ToString())); if (objResult != null) { if (objResult.ResultDt.Rows.Count > 0) { txtRecName.Text = objResult.ResultDt.Rows[0][ReceptionBo.RECEPTION_NAME].ToString(); txtDescription.Text = objResult.ResultDt.Rows[0][ReceptionBo.RECEPTION_DESCRIPTION].ToString(); txtPLCValue.Text = objResult.ResultDt.Rows[0][ReceptionBo.RECEPTION_PLCVALUE].ToString(); PanelVisibilityMode(false, true); } } } else if (e.CommandName == "Delete1") { var objResult = objReceptionBL.Reception_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.Userid].ToString()), 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); BindgvReception(); } 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>"); } }
protected void btnSave_OnClick(object sender, EventArgs e) { try { ReceptionBo objReceptionBo = new ReceptionBo(); ReceptionBl objReceptionBl = new ReceptionBl(); objReceptionBo.Name = txtRecName.Text.Trim(); objReceptionBo.Description = txtDescription.Text.Trim(); objReceptionBo.PLCValue = Convert.ToInt32(txtPLCValue.Text); if (ViewState["Mode"].ToString() == "Save") { objReceptionBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objReceptionBo.CreatedDate = DateTime.UtcNow.AddHours(5.5); var objResult = objReceptionBl.Reception_Insert(objReceptionBo); if (objResult != null) { if (objResult.ResultDt.Rows.Count > 0) { int intStatus = Convert.ToInt32(objResult.ResultDt.Rows[0]["Status"].ToString()); if (intStatus == 0) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('" + txtRecName.Text + " is already exist.');</script>"); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>"); ClearAll(); BindgvReception(); PanelVisibilityMode(true, false); } } } } else if (ViewState["Mode"].ToString() == "Edit") { objReceptionBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objReceptionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5); objReceptionBo.ReceptionId = Convert.ToInt32(ViewState["ReceptionID"].ToString()); var objResult = objReceptionBl.Reception_Update(objReceptionBo); if (objResult != null) { if (objResult.ResultDt.Rows.Count > 0) { int intStatus = Convert.ToInt32(objResult.ResultDt.Rows[0]["Status"].ToString()); if (intStatus == 0) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('" + txtRecName.Text + " is already exist.');</script>"); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>"); ClearAll(); BindgvReception(); 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>"); } }