public void OpenBlockedDate() { String Status = ""; SqlParameter param = new SqlParameter(); List <SqlParameter> paramList = new List <SqlParameter>(); param = SQLHelper.CreateParameter("@dateEntered", SqlDbType.DateTime); param.Value = Convert.ToDateTime(DtCurrentDate.ToShortDateString()); paramList.Add(param); param = SQLHelper.CreateParameter("@CloseDate", SqlDbType.DateTime); param.Value = Convert.ToDateTime(DtCloseDate.ToShortDateString()); paramList.Add(param); param = SQLHelper.CreateParameter("@userId", SqlDbType.VarChar, 50); param.Value = User.StrUserName; paramList.Add(param); //param = SQLHelper.CreateParameter("@dateEntered", SqlDbType.DateTime); //param.Value = Convert.ToDateTime(DtCurrentDate.ToShortDateString()); //paramList.Add(param); SqlCommand cmd = new SqlCommand(); cmd = SQLHelper.CreateCommand("SPDtBlock_OpenBlockedDate", CommandType.StoredProcedure, paramList); SQLHelper.ExecuteNonQuery(cmd); cmd.Dispose(); }
public Boolean IsDateOpened() { Boolean Status = false; SqlParameter param = new SqlParameter(); SqlParameter statusParam = new SqlParameter(); SqlParameter identityParam = new SqlParameter(); List <SqlParameter> paramList = new List <SqlParameter>(); param = SQLHelper.CreateParameter("@dateEntered", SqlDbType.DateTime); param.Value = Convert.ToDateTime(DtCurrentDate.ToShortDateString()); paramList.Add(param); SqlCommand cmd = new SqlCommand(); cmd = SQLHelper.CreateCommand("SPDtBlock_IsDateOpened", CommandType.StoredProcedure, paramList); statusParam = cmd.Parameters.Add("@status", SqlDbType.Bit); statusParam.Direction = ParameterDirection.Output; SQLHelper.ExecuteNonQuery(cmd); Status = Convert.ToBoolean(statusParam.Value.ToString()); cmd.Dispose(); return(Status); }
public String CheckDateDifference() { String Status = ""; SqlParameter param = new SqlParameter(); SqlParameter statusParam = new SqlParameter(); SqlParameter identityParam = new SqlParameter(); List <SqlParameter> paramList = new List <SqlParameter>(); param = SQLHelper.CreateParameter("@dateEntered", SqlDbType.DateTime); param.Value = Convert.ToDateTime(DtCurrentDate.ToShortDateString()); paramList.Add(param); SqlCommand cmd = new SqlCommand(); cmd = SQLHelper.CreateCommand("SPDtBlock_DateDurations", CommandType.StoredProcedure, paramList); statusParam = cmd.Parameters.Add("@status", SqlDbType.VarChar, 50); statusParam.Direction = ParameterDirection.Output; SQLHelper.ExecuteNonQuery(cmd); Status = statusParam.Value.ToString(); cmd.Dispose(); return(Status); }