public sOptonModels GetPollingModels(otherData otherData, string cuurip)
{
bool isbreak = true;
database database = new database();
List <Dictionary <string, object> > items = new List <Dictionary <string, object> >();
while (isbreak)
{
Thread.Sleep(5000);
List <dbparam> dbparamlist = new List <dbparam>();
int itemCount = int.Parse(database.checkSelectSql("mssql", "flyformstring", "exec web.countmainform;", dbparamlist).Rows[0]["itemCount"].ToString().TrimEnd()), values = int.Parse(otherData.values.TrimEnd());
if (itemCount > values)
{
dbparamlist.Clear();
dbparamlist.Add(new dbparam("@length", itemCount - values));
dbparamlist.Add(new dbparam("@inoper", otherData.userid.TrimEnd()));
foreach (DataRow dr in new database().checkSelectSql("mssql", "flyformstring", "exec web.searchmaining @length,@inoper;", dbparamlist).Rows)
{
items.Add(new Dictionary <string, object>()
{
{ "id", dr["formId"].ToString().TrimEnd() }, { "tile", dr["tile"].ToString().TrimEnd() }, { "datetime", dr["indate"].ToString().TrimEnd() }, { "showOther", false }, { "showFinish", dr["finish"].ToString().TrimEnd() == "1" }
});
}
isbreak = false;
}
}
return(new sOptonModels()
{
items = items
});
}
public sOptonModels GetSoperModels(otherData otherData, string cuurip)
{
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@department", otherData.values.TrimEnd()));
List <Dictionary <string, object> > items = new List <Dictionary <string, object> >();
foreach (DataRow dr in new database().checkSelectSql("mssql", "epaperstring", "exec web.searchdertoper @department;", dbparamlist).Rows)
{
items.Add(new Dictionary <string, object>()
{
{ "newid", dr["newid"].ToString().TrimEnd() }, { "userid", dr["userid"].ToString().TrimEnd() }, { "name", dr["username"].ToString().TrimEnd() }, { "showOper", false }
});
}
return(new sOptonModels()
{
items = items
});
}
public sTypeModels GetSTypeModels(otherData otherData, string cuurip)
{
database database = new database();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@value", otherData.values.TrimEnd()));
List <Dictionary <string, object> > items = new List <Dictionary <string, object> >(); string value = "";
foreach (DataRow dr in database.checkSelectSql("mssql", "flyformstring", "exec web.searchoperationform @value;", dbparamlist).Rows)
{
value = dr["operationValue"].ToString().TrimEnd();
items.Add(new Dictionary <string, object>()
{
{ "optionPadding", dr["optionPadding"].ToString().TrimEnd() == "1" }, { "value", dr["operationValue"].ToString().TrimEnd() }
});
}
return(new sTypeModels()
{
value = value, items = items, status = "istrue"
});
}
public statusModels GetBadgeFormModels(otherData otherData, string cuurip)
{
bool isbreak = true;
string badge = "0";
database database = new database();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@newid", otherData.userid.TrimEnd()));
dbparamlist.Add(new dbparam("@status", "0"));
while (isbreak)
{
Thread.Sleep(5000);
badge = database.checkSelectSql("mssql", "flytrainstring", "exec web.countnoticeform @newid,@status;", dbparamlist).Rows[0]["counts"].ToString().TrimEnd();
if (badge != otherData.values.TrimEnd())
{
isbreak = false;
}
}
return(new statusModels()
{
status = badge
});
}
public statusModels GetCodeUserModels(otherData otherData, string cuurip)
{
switch (string.IsNullOrWhiteSpace(otherData.userid))
{
case true:
return(new statusModels()
{
status = "nousers"
});
}
switch (string.IsNullOrWhiteSpace(otherData.values))
{
case true:
return(new statusModels()
{
status = "errorCode"
});
}
DataTable userRows = new DataTable();
database database = new database();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@newid", otherData.userid.TrimEnd()));
dbparamlist.Add(new dbparam("@vecode", otherData.values.TrimEnd()));
dbparamlist.Add(new dbparam("@status", "1"));
userRows = database.checkSelectSql("mssql", "epaperstring", "exec web.codesiteber @newid,@vecode,@status;", dbparamlist);
switch (userRows.Rows.Count)
{
case 0:
return(new statusModels()
{
status = "nodata"
});
}
switch (userRows.Rows[0]["isused"].ToString().TrimEnd())
{
case "0":
return(new statusModels()
{
status = "islock"
});
}
datetime datetime = new datetime();
string date = datetime.sqldate("mssql", "epaperstring"), time = datetime.sqltime("mssql", "epaperstring");
DateTime startdate = DateTime.Parse(date + " " + time);
DateTime enddate = DateTime.Parse(userRows.Rows[0]["vedate"].ToString().TrimEnd() + " " + userRows.Rows[0]["vetime"].ToString().TrimEnd()).AddMinutes(10);
if (enddate >= startdate)
{
dbparamlist.Clear();
dbparamlist.Add(new dbparam("@vedate", ""));
dbparamlist.Add(new dbparam("@vetime", ""));
dbparamlist.Add(new dbparam("@vecode", ""));
dbparamlist.Add(new dbparam("@modate", date));
dbparamlist.Add(new dbparam("@motime", time));
dbparamlist.Add(new dbparam("@newid", otherData.userid.TrimEnd()));
if (database.checkActiveSql("mssql", "epaperstring", "update web.siteber set vedate = @vedate,vetime = @vetime,vecode = @vecode,modate = @modate,motime = @motime where newid = @newid;", dbparamlist) != "istrue")
{
return(new statusModels()
{
status = "error"
});
}
return(new statusModels()
{
status = "istrue"
});
}
Random random = new Random();
string vecode = random.Next(100000, 999999).ToString().TrimEnd();
dbparamlist.Clear();
dbparamlist.Add(new dbparam("@vedate", date));
dbparamlist.Add(new dbparam("@vetime", time));
dbparamlist.Add(new dbparam("@vecode", vecode));
dbparamlist.Add(new dbparam("@modate", date));
dbparamlist.Add(new dbparam("@motime", time));
dbparamlist.Add(new dbparam("@newid", otherData.userid.TrimEnd()));
if (database.checkActiveSql("mssql", "epaperstring", "update web.siteber set vedate = @vedate,vetime = @vetime,vecode = @vecode,modate = @modate,motime = @motime where newid = @newid;", dbparamlist) != "istrue")
{
return(new statusModels()
{
status = "error"
});
}
return(new statusModels()
{
status = "resend"
});
}
public statusModels GetResendUserModels(otherData otherData, string cuurip)
{
switch (string.IsNullOrWhiteSpace(otherData.userid))
{
case true:
return(new statusModels()
{
status = "nousers"
});
}
switch (string.IsNullOrWhiteSpace(otherData.values))
{
case true:
return(new statusModels()
{
status = "errorResend"
});
}
DataTable userRows = new DataTable();
database database = new database();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@newid", otherData.userid.TrimEnd()));
dbparamlist.Add(new dbparam("@status", "1"));
userRows = database.checkSelectSql("mssql", "epaperstring", "exec web.resendsiteber @newid,@status;", dbparamlist);
switch (userRows.Rows.Count)
{
case 0:
return(new statusModels()
{
status = "nodata"
});
}
switch (userRows.Rows[0]["isused"].ToString().TrimEnd())
{
case "0":
return(new statusModels()
{
status = "islock"
});
}
datetime datetime = new datetime();
string date = datetime.sqldate("mssql", "epaperstring"), time = datetime.sqltime("mssql", "epaperstring");
dbparamlist.Clear();
dbparamlist.Add(new dbparam("@password", new sha256().encry256(otherData.values.TrimEnd())));
dbparamlist.Add(new dbparam("@modate", date));
dbparamlist.Add(new dbparam("@motime", time));
dbparamlist.Add(new dbparam("@newid", otherData.userid.TrimEnd()));
if (database.checkActiveSql("mssql", "epaperstring", "update web.siteber set password = @password,modate = @modate,motime = @motime where newid = @newid;", dbparamlist) != "istrue")
{
return(new statusModels()
{
status = "error"
});
}
return(new statusModels()
{
status = "istrue"
});
}