/// <summary> /// To Insert details of Fault in FaultTag table /// Created By : VIshal, 11/21/2015 /// Modified By : /// </summary> public ApplicationResult Fault_Insert(FaultBo objFaultBo) { try { pSqlParameter = new SqlParameter[5]; pSqlParameter[0] = new SqlParameter("@TagNo", SqlDbType.VarChar); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objFaultBo.TagNo; pSqlParameter[1] = new SqlParameter("@Description", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objFaultBo.Description; pSqlParameter[2] = new SqlParameter("@Type", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objFaultBo.Type; pSqlParameter[3] = new SqlParameter("@CreatedBy", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objFaultBo.CreatedBy; pSqlParameter[4] = new SqlParameter("@CreatedDate", SqlDbType.DateTime); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objFaultBo.CreatedDate; sSql = "usp_tbl_FaultTag_Insert"; DataTable dtResult = new DataTable(); dtResult = Database.ExecuteDataTable(CommandType.StoredProcedure, sSql, pSqlParameter); ApplicationResult objResults = new ApplicationResult(dtResult); objResults.Status = ApplicationResult.CommonStatusType.Success; return(objResults); //int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter); //if (iResult > 0) //{ // ApplicationResult objResults = new ApplicationResult(); // objResults.Status = ApplicationResult.CommonStatusType.Success; // return objResults; //} //else //{ // ApplicationResult objResults = new ApplicationResult(); // objResults.Status = ApplicationResult.CommonStatusType.Failure; // return objResults; //} } catch (Exception ex) { throw ex; } finally { objFaultBo = null; } }
/// <summary> /// To Update details of Fault in FaultTag table /// Created By : VIshal, 11/21/2015 /// Modified By : /// </summary> public ApplicationResult Fault_Update(FaultBo objFaultBo) { try { pSqlParameter = new SqlParameter[6]; pSqlParameter[0] = new SqlParameter("@Id", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objFaultBo.Id; pSqlParameter[1] = new SqlParameter("@TagNo", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objFaultBo.TagNo; pSqlParameter[2] = new SqlParameter("@Description", SqlDbType.VarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objFaultBo.Description; pSqlParameter[3] = new SqlParameter("@Type", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objFaultBo.Type; pSqlParameter[4] = new SqlParameter("@LastModifiedBy", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objFaultBo.LastModifiedBy; pSqlParameter[5] = new SqlParameter("@LastModifiedDate", SqlDbType.DateTime); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objFaultBo.LastModifiedDate; sSql = "usp_tbl_FaultTag_Update"; DataTable dtResult = new DataTable(); dtResult = Database.ExecuteDataTable(CommandType.StoredProcedure, sSql, pSqlParameter); ApplicationResult objResults = new ApplicationResult(dtResult); objResults.Status = ApplicationResult.CommonStatusType.Success; return(objResults); } catch (Exception ex) { throw ex; } finally { objFaultBo = null; } }
protected void btnSave_OnClick(object sender, EventArgs e) { try { FaultBo objFaultBo = new FaultBo(); FaultBl objFaultBl = new FaultBl(); objFaultBo.TagNo = txtTagNo.Text.Trim(); objFaultBo.Description = txtDescription.Text.Trim(); objFaultBo.Type = Convert.ToInt32(ddlType.SelectedValue); if (ViewState["Mode"].ToString() == "Save") { objFaultBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objFaultBo.CreatedDate = DateTime.UtcNow.AddHours(5.5); var objResult = objFaultBl.Fault_Insert(objFaultBo); 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('" + txtTagNo.Text + " is already exist.');</script>"); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>"); ClearAll(); BindgvFault(); PanelVisibilityMode(true, false); } } } } else if (ViewState["Mode"].ToString() == "Edit") { objFaultBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objFaultBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5); objFaultBo.Id = Convert.ToInt32(ViewState["ID"].ToString()); var objResult = objFaultBl.Fault_Update(objFaultBo); 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('" + txtTagNo.Text + " is already exist.');</script>"); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>"); ClearAll(); BindgvFault(); 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>"); } }