internal string isValidDeleiveryDateForMilma(ParameterSettingsBO parameterSettingsBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(parameterSettingsBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "validateMilmaDeliveryDate";
return(Convert.ToString(sqlHelper.ExecuteScalar(command)));
}
internal int getRequireErb(ParameterSettingsBO parameterSettingsBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(parameterSettingsBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.Text);
command.CommandText = "SELECT RequireERP FROM ParameterSettings";
return(Convert.ToInt32(sqlHelper.ExecuteScalar(command)));
}
internal int RequireSMSForcollection(ParameterSettingsBO parameterSettingsBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(parameterSettingsBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.Text);
command.CommandText = "select IsRequiredSMSCollection from parametersettings";
return(Convert.ToInt32(sqlHelper.ExecuteScalar(command)));
}
internal int getSqliteCount(ParameterSettingsBO dBCredentialBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(dBCredentialBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.Text);
command.CommandText = "select SqliteCount from ParameterSettings";
return(Convert.ToInt32(sqlHelper.ExecuteScalar(command)));
}
internal DataSet GetUserParameters(ParameterSettingsBO parameterSettingsBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(parameterSettingsBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "GetInstanceDetails";
sqlHelper.AddParameter(command, "@UserId", parameterSettingsBO.UserId, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@Date", parameterSettingsBO.date, ParameterDirection.Input);
return(sqlHelper.ExecuteDataSet(command));
}
