internal DataSet GetBuildNo(VersionLogBO versionLogBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(versionLogBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "usp_GETVersionNO";
sqlHelper.AddParameter(command, "@Mode", "4", ParameterDirection.Input);
return(sqlHelper.ExecuteDataSet(command));
}
internal int GetVersionLog(VersionLogBO versionLogBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(versionLogBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "uspWSGetPreviousDayOrdersCount";
sqlHelper.AddParameter(command, "@UserId", versionLogBO.UserId, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@OrderDate", versionLogBO.VersionNo, ParameterDirection.Input);
return(Convert.ToInt32(sqlHelper.ExecuteScalar(command)));
}
internal int UpdateVersionLog(VersionLogBO versionLogBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(versionLogBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "uspVersionLog";
sqlHelper.AddParameter(command, "@userId", versionLogBO.UserId, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@versionNo", versionLogBO.VersionNo, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@buildNo", versionLogBO.BuildNo, ParameterDirection.Input);
return(Convert.ToInt32(sqlHelper.ExecuteNonQuery(command)));
}