public static string GetTexniksAndothers(int lg)
{
int DispId = (int)Mydb.ExecuteScalar("select DISP_ID from DISP_ACC where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", lg) }, CommandType.Text);
DataTable dt = Mydb.ExecuteReadertoDataTable("select a.LOG_IN_ID,a.ACCOUNT_NAME,da.ROLE_ID from ACCOUNT a , DISP_ACC da where da.DISP_ID=@d and(da.ROLE_ID=6 or ROLE_ID=2 or ROLE_ID=15) and da.LOG_IN_ID=a.LOG_IN_ID", new SqlParameter[] { new SqlParameter("@d", DispId) }, CommandType.Text);
List <Account_> accs = new List <Account_>();
//string currdispname = Mydb.ExecuteScalar("select ACCOUNT_NAME from ACCOUNT where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", lg) }, CommandType.Text).ToString();
//Account_ ac_c = new Account_();
//ac_c.LOG_IN_ID = lg;
//ac_c.ACCOUNT_NAME = currdispname;
//ac_c.RS = "3";
//accs.Add(ac_c);
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.RS = item["ROLE_ID"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
public static string GetAccDetail(int LogId_)
{
DataTable dtAcc = Mydb.ExecuteReadertoDataTable("select * from ACCOUNT where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LogId_) }, CommandType.Text);
List <Account_> accs = new List <Account_>();
foreach (DataRow item in dtAcc.Rows)
{
Account_ acc = new Account_();
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.E_MAIL = item["E_MAIL"].ToString();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
// acc.MODULE_ROLES = item["MODULE_ROLES"].ToString();
acc.PASSWORD = item["PASSWORD"].ToString();
acc.PHONE_NUMBER = item["PHONE_NUMBER"].ToString();
acc.LOGIN = item["LOGIN"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js_accs = new JavaScriptSerializer();
int COuntOf_Mr = (int)Mydb.ExecuteScalar("select COUNT(*)from ACCOUNT_ROLE where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LogId_) }, CommandType.Text);
return(js_accs.Serialize(accs));
}
public static string getAccForSelRole(int C, List <Roles> rls)
{
DataTable dt = null;
List <Account_> accs = new List <Account_>();
foreach (Roles ite_m in rls)
{
dt = Mydb.ExecuteReadertoDataTable("select * from ACCOUNT where CLIENT_ID =@C and LOG_IN_ID in (select LOG_IN_ID from ACCOUNT_ROLE where MR_ID in (select MR_ID from MODUL_ROLE where ROLE_ID=@R))", new SqlParameter[] { new SqlParameter("@C", C), new SqlParameter("@R", ite_m.ROLE_ID) }, CommandType.Text);
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.E_MAIL = item["E_MAIL"].ToString();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
// acc.MODULE_ROLES = item["MODULE_ROLES"].ToString();
acc.PASSWORD = item["PASSWORD"].ToString();
acc.PHONE_NUMBER = item["PHONE_NUMBER"].ToString();
accs.Add(acc);
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
public static string getDispsENgsTexs(int DD, int R)
{
//DataTable dt = Mydb.ExecuteReadertoDataTable("GetDispEngTex", new SqlParameter[] { new SqlParameter("@d",DD),new SqlParameter("@R",R) }, CommandType.StoredProcedure);
//
//foreach (DataRow item in dt.Rows)
//{
// Account_ ac = new Account_();
// ac.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
// ac.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
// ass.Add(ac);
//}
//JavaScriptSerializer js = new JavaScriptSerializer();
//return js.Serialize(ass);
DataTable dt = Mydb.ExecuteReadertoDataTable("select LOG_IN_ID from DISP_ACC where DISP_ID=@d and ROLE_ID=@r", new SqlParameter[] { new SqlParameter("@d", DD), new SqlParameter("@r", R) }, CommandType.Text);
List <Account_> ass = new List <Account_>();
foreach (DataRow item in dt.Rows)
{
Account_ a = new Account_();
a.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
a.ACCOUNT_NAME = Mydb.ExecuteScalar("select ACCOUNT_NAME from ACCOUNT where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", Convert.ToInt32(item["LOG_IN_ID"])) }, CommandType.Text).ToString();
ass.Add(a);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(ass));
}
public static string GetDetailClient(int Cl)
{
int countRelationalDatas = (int)Mydb.ExecuteScalar("select count(*)from ACCOUNT a,CLIENT c, ENTITY_ADRESS e, ENTITY_TYPE et where et.ENTITY_TYPE_ID = c.ENTITY_TYPE_ID and e.ADRESS_ID = c.ADRESS_ID and c.CLIENT_ID = @c", new SqlParameter[] { new SqlParameter("@c", Cl) }, CommandType.Text);
if (countRelationalDatas == 0)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select E_MAIL,PASSWORD from ACCOUNT where CLIENT_ID=@cl and LOGIN is null", new SqlParameter[] { new SqlParameter("@cl", Cl) }, CommandType.Text);
List <Account_> accs = new List <Account_>();
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.E_MAIL = item["E_MAIL"].ToString();
acc.PASSWORD = item["PASSWORD"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
else
{
List <Account_> accs = new List <Account_>();
DataTable dt = Mydb.ExecuteReadertoDataTable("getDetailClient", new SqlParameter[] { new SqlParameter("@c", Cl) }, CommandType.StoredProcedure);
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.COMPANY_NAME = item["COMPANY_NAME"].ToString();
acc.ENTITY_TYPE_ID = Convert.ToInt32(item["ENTITY_TYPE_ID"]);
acc.E_MAIL = item["E_MAIL"].ToString();
acc.HOUSE = item["HOUSE"].ToString();
acc.INN = item["INN"].ToString();
acc.KPP = item["KPP"].ToString();
acc.BNAME = item["BNAME"].ToString();
acc.INNB = item["INNB"].ToString();
acc.KPPB = item["KPPB"].ToString();
acc.ADRESS_ID = item["ADRESS_ID"].ToString();
acc.BIK = item["BIK"].ToString();
acc.BKRS = item["BKRS"].ToString();
acc.RS = item["RS"].ToString();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
acc.OGRN_OGRNIP = item["OGRN_OGRNIP"].ToString();
acc.OKPO = item["OKPO"].ToString();
acc.PASSWORD = item["PASSWORD"].ToString();
acc.PHONE_NUMBER = item["PHONE_NUMBER"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
}
public static string gtSpecials(int rid)
{
System.Data.DataTable dt = Mydb.ExecuteReadertoDataTable(" select ACCOUNT_NAME from ACCOUNT where LOG_IN_ID=(select SPECIALIS_ID from REQUEST where REQUEST_ID=@rid)", new SqlParameter[] { new SqlParameter("@rid", rid) }, CommandType.Text);
List <Account_> accs = new List <Account_>();
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
public static string GetTexniks(int lg)
{
//int clientId = (int)Mydb.ExecuteScalar("select CLIENT_ID from ACCOUNT where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg",lg) }, CommandType.Text);
//int MId = 4;
//int RId = 6;
//DataTable dt = Mydb.ExecuteReadertoDataTable("GetAccForCLforMR", new SqlParameter[] { new SqlParameter("@C", clientId), new SqlParameter("@M", MId), new SqlParameter("@R", RId) }, CommandType.StoredProcedure);
//string currdispname = Mydb.ExecuteScalar("select ACCOUNT_NAME from ACCOUNT where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg",lg) }, CommandType.Text).ToString();
//List<Account_> accs = new List<Account_>();
//Account_ ac_c = new Account_();
//ac_c.LOG_IN_ID = lg;
//ac_c.ACCOUNT_NAME = currdispname;
//accs.Add(ac_c);
//foreach (DataRow item in dt.Rows)
//{
// Account_ acc = new Account_();
// acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
// acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
// accs.Add(acc);
//}
int DispId = (int)Mydb.ExecuteScalar("select DISP_ID from DISP_ACC where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", lg) }, CommandType.Text);
DataTable dt = Mydb.ExecuteReadertoDataTable("select a.LOG_IN_ID,a.ACCOUNT_NAME,da.ROLE_ID from ACCOUNT a , DISP_ACC da where da.DISP_ID=@d and(da.ROLE_ID=6 or ROLE_ID=2) and da.LOG_IN_ID=a.LOG_IN_ID", new SqlParameter[] { new SqlParameter("@d", DispId) }, CommandType.Text);
List <Account_> accs = new List <Account_>();
string currdispname = Mydb.ExecuteScalar("select ACCOUNT_NAME from ACCOUNT where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", lg) }, CommandType.Text).ToString();
Account_ ac_c = new Account_();
ac_c.LOG_IN_ID = lg;
ac_c.ACCOUNT_NAME = currdispname;
ac_c.RS = "15";
accs.Add(ac_c);
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.RS = item["ROLE_ID"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
public static string GetEngineers(int clientId)
{
int MId = 4;
int RId = 2;
DataTable dt = Mydb.ExecuteReadertoDataTable("GetAccForCLforMR", new SqlParameter[] { new SqlParameter("@C", clientId), new SqlParameter("@M", MId), new SqlParameter("@R", RId) }, CommandType.StoredProcedure);
List <Account_> accs = new List <Account_>();
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
public static string getSortedTable(string sr_t, int C)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("GetAccListandSort", new SqlParameter[] { new SqlParameter("@C", C), new SqlParameter("@sort", sr_t) }, CommandType.StoredProcedure);
List <Account_> accs = new List <Account_>();
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.E_MAIL = item["E_MAIL"].ToString();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
// acc.MODULE_ROLES = item["MODULE_ROLES"].ToString();
acc.PASSWORD = item["PASSWORD"].ToString();
acc.PHONE_NUMBER = item["PHONE_NUMBER"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
public static string GetACCList(int clId)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("sp_ConstructorAPI_GetAccountsList", new SqlParameter[] { new SqlParameter("@CLIENT_ID", clId) }, CommandType.StoredProcedure);
List <Account_> accs = new List <Account_>();
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.E_MAIL = item["E_MAIL"].ToString();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
acc.MODULE_ROLES = item["MODULE_ROLES"].ToString();
acc.PASSWORD = item["PASSWORD"].ToString();
acc.PHONE_NUMBER = item["PHONE_NUMBER"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
public override int GetHashCode()
{
int hash = 1;
if (Account_.Length != 0)
{
hash ^= Account_.GetHashCode();
}
if (Password.Length != 0)
{
hash ^= Password.GetHashCode();
}
if (Data.Length != 0)
{
hash ^= Data.GetHashCode();
}
if (_unknownFields != null)
{
hash ^= _unknownFields.GetHashCode();
}
return(hash);
}
public static string GetAccForMR(int CId, int MId, int RId)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select LOG_IN_ID,ACCOUNT_NAME from ACCOUNT where CLIENT_ID=@C and LOGIN is not null and LOG_IN_ID in (select LOG_IN_ID from ACCOUNT_ROLE where MR_ID in (select MR_ID from MODUL_ROLE where MODUL_ID=@M and ROLE_ID=@R) and LOG_IN_ID not in (select LOG_IN_ID from DISP_ACC))", new SqlParameter[] { new SqlParameter("@C", CId), new SqlParameter("@M", MId), new SqlParameter("@R", RId) }, CommandType.Text);
List <Account_> accs = new List <Account_>();
foreach (DataRow item in dt.Rows)
{
int MR_id = (int)Mydb.ExecuteScalar("select MR_ID from ACCOUNT_ROLE where MR_ID in( select MR_ID from MODUL_ROLE where MODUL_ID=@m and ROLE_ID=@r)and LOG_IN_ID=@lg", new SqlParameter[] {
new SqlParameter("@m", MId),
new SqlParameter("@r", RId),
new SqlParameter("@lg", Convert.ToInt32(item["LOG_IN_ID"]))
}, CommandType.Text);
Account_ acc = new Account_();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.KPP = MR_id.ToString();;
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
public static string SearchAcc(string Stext_, int clId)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("SearchAcc", new SqlParameter[] { new SqlParameter("@Stext", Stext_), new SqlParameter("@C", clId) }, CommandType.StoredProcedure);
if (dt.Rows.Count != 0)
{
List <Account_> accs = new List <Account_>();
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.E_MAIL = item["E_MAIL"].ToString();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
// acc.MODULE_ROLES = item["MODULE_ROLES"].ToString();
acc.PASSWORD = item["PASSWORD"].ToString();
acc.PHONE_NUMBER = item["PHONE_NUMBER"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
else
{
DataTable dtm = Mydb.ExecuteReadertoDataTable("SearchForModul", new SqlParameter[] { new SqlParameter("@SModul", Stext_), new SqlParameter("@C", clId) }, CommandType.StoredProcedure);
if (dtm.Rows.Count != 0)
{
List <Account_> accs = new List <Account_>();
foreach (DataRow item in dtm.Rows)
{
Account_ acc = new Account_();
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.E_MAIL = item["E_MAIL"].ToString();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
// acc.MODULE_ROLES = item["MODULE_ROLES"].ToString();
acc.PASSWORD = item["PASSWORD"].ToString();
acc.PHONE_NUMBER = item["PHONE_NUMBER"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
else
{
dt = Mydb.ExecuteReadertoDataTable("SearchForRole", new SqlParameter[] { new SqlParameter("@SRole", Stext_), new SqlParameter("@C", clId) }, CommandType.StoredProcedure);
List <Account_> accs = new List <Account_>();
foreach (DataRow item in dt.Rows)
{
Account_ acc = new Account_();
acc.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString();
acc.E_MAIL = item["E_MAIL"].ToString();
acc.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]);
// acc.MODULE_ROLES = item["MODULE_ROLES"].ToString();
acc.PASSWORD = item["PASSWORD"].ToString();
acc.PHONE_NUMBER = item["PHONE_NUMBER"].ToString();
accs.Add(acc);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(accs));
}
}
}
