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);
}
