public static Int32 validateuserid(string user)
{
DbCommand cmd = BaseDb.CreateSqlCommand();
cmd.CommandText = "select count(*) from usermaster where ltrim(rtrim(userid))='" + user + "'";
int cnt = Convert.ToInt32(BaseDb.ExecuteScalar(cmd).ToString());
return(cnt);
}
public static Int32 chkuser()
{
int cnt;
DbCommand cmd = BaseDb.CreateSqlCommand();
cmd.CommandText = "select count(*) from viewusermaster1 where ACCESS_FOR_DATA_UPLOAD=1";
cnt = Convert.ToInt32(BaseDb.ExecuteScalar(cmd).ToString());
return(cnt);
}
public static DataTable GetwebPassword(string userid)
{
DbCommand dbComm = BaseDb.CreateSqlCommand();
dbComm.CommandText = "select password from viewusermaster1 where userid= '" + userid + "' and access_for_data_upload=1";
DataTable fieldData;
try
{
fieldData = BaseDb.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return(fieldData);
}
public static Int32 chktruncate()
{
int j = 0;
DbCommand sqlcmd = BaseDb.CreateSqlCommand();
sqlcmd.CommandText = "select count(*) from dataparameter";
int cnt = Convert.ToInt32(BaseDb.ExecuteScalar(sqlcmd).ToString());
if (cnt == 0)
{
sqlcmd.CommandText = "select count(*) from misngdatadet";
cnt = Convert.ToInt32(BaseDb.ExecuteScalar(sqlcmd).ToString());
if (cnt == 0)
{
sqlcmd.CommandText = "select count(*) from avlbldatadet";
cnt = Convert.ToInt32(BaseDb.ExecuteScalar(sqlcmd).ToString());
if (cnt == 0)
{
sqlcmd.CommandText = "select count(*) from datatype";
cnt = Convert.ToInt32(BaseDb.ExecuteScalar(sqlcmd).ToString());
if (cnt == 0)
{
j = 0;
}
else
{
j = 1;
}
}
else
{
j = 1;
}
}
else
{
j = 1;
}
}
else
{
j = 1;
}
return(j);
}
