public static string GetOtcet(int log, string CrFrom, string CrTo) { System.Data.DataTable dt = Mydb.ExecuteReadertoDataTable("usp_DispReportRequestTypesCount", new SqlParameter[] { new SqlParameter("@lg", log), new SqlParameter("@from", CrFrom), new SqlParameter("@to", CrTo) }, CommandType.StoredProcedure); Random r = new Random(); int rand = r.Next(); string startupPath = @"C:\inetpub\wwwroot\"; //AppDomain.CurrentDomain.BaseDirectory; string filePath = startupPath + @"Disp_Admin\excelOt\" + rand.ToString() + ".csv"; string virtPath = @"excelOt/" + rand.ToString() + ".csv"; //workbook.SaveAs(filePath); string strbuld = GenerateCSV(dt); File.WriteAllText(filePath, strbuld, Encoding.UTF8); List <Request> rs = new List <Utilities.Request>(); Request r_ = new Utilities.Request(); r_.ACCOUNT_NAME = virtPath; rs.Add(r_); JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rs));// @"[{Path : "+filePath+"}]"; }
public static string AllSearch1(int dd, string txt, int lg) { DataTable dt = Mydb.ExecuteReadertoDataTable("uspo_AllSearchRequest", new SqlParameter[] { new SqlParameter("@dd", dd), new SqlParameter("@Stext", txt) }, CommandType.StoredProcedure); List <Request> rs = new List <Utilities.Request>(); foreach (DataRow item in dt.Rows) { Request r = new Utilities.Request(); r.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString(); r.ROOM_TYPE = item["ROOM_TYPE"].ToString(); r.ROOM_NUMBER = item["ROOM_NUMBER"].ToString(); r.CR_DATE = item["CR_DATE"].ToString(); r.REQUEST_ID = Convert.ToInt32(item["REQUEST_ID"]); r.REQUEST_TEXT = item["REQUEST_TEXT"].ToString(); // r.SERVICE_NAME = item["SERVICE_NAME"].ToString(); r.STATUS = item["STATUS"].ToString(); r.PLAN_END_DATE = item["PLAN_END_DATE"].ToString(); r.INDIVIDUAL_ID = Convert.ToInt32(item["INDIVIDUAL_ID"]); r.FIRST_NAME = item["FIRST_NAME"].ToString(); r.STATUS_ID = item["STATUS_ID"].ToString(); r.ATRIBUTE = (item["LOG_IN_ID"] != lg.ToString() || item["LOG_IN_ID"] == null) ? "NotC" : "Curr"; //r.DELIVERY_TYPE_ID = 1; r.ADRESS = item["OBJECT_ADRESS"].ToString(); r.EMERGENCY_TREATMENT = (bool)item["EMERGENCY_TREATMENT"]; r.COMMENT_FILE = item["PAYMENT"].ToString(); rs.Add(r); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rs)); }
public static string GetRequestTableForResponsibles(int LogId) { System.Data.DataTable dt = Mydb.ExecuteReadertoDataTable("GetRequestTableForResponsibles", new SqlParameter[] { new SqlParameter("@L", LogId) }, CommandType.StoredProcedure); List <Resp_Request> rs = new List <Resp_Request>(); foreach (DataRow item in dt.Rows) { Resp_Request r = new Resp_Request(); r.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString(); r.ROOM_TYPE = item["ROOM_TYPE"].ToString(); r.CR_DATE = item["CR_DATE"].ToString(); r.REQUEST_ID = Convert.ToInt32(item["REQUEST_ID"]); r.REQUEST_TEXT = item["REQUEST_TEXT"].ToString(); // r.SERVICE_NAME = item["SERVICE_NAME"].ToString(); r.STATUS = item["STATUS"].ToString(); r.PLAN_END_DATE = item["PLAN_END_DATE"].ToString(); r.INDIVIDUAL_ID = (item["INDIVIDUAL_ID"] == DBNull.Value) ? -1 : Convert.ToInt32(item["INDIVIDUAL_ID"]); r.FIRST_NAME = item["FIRST_NAME"].ToString(); r.STATUS_ID = item["STATUS_ID"].ToString(); r.REQUEST_COMMENT = item["PAYMENT"].ToString(); r.EMERGENCY_TREATMENT = (item["ORDER"].ToString() == "1") ? true : false; //(bool)item["EMERGENCY_TREATMENT"]; r.ADRESS = item["OBJECT_ADRESS"].ToString(); r.MOBILE_NUMBER = item["MOBILE_NUMBER"].ToString(); rs.Add(r); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rs)); }
public static string Super_Supplier_Requests() { System.Data.DataTable dt = Mydb.ExecuteReadertoDataTable("Super_Supplier_Requests", new SqlParameter[] {}, CommandType.StoredProcedure); List <Request> rs = new List <Request>(); foreach (DataRow item in dt.Rows) { Request r = new Request(); r.ACCOUNT_NAME = item["SUPPLIER"].ToString(); // r.ROOM_TYPE = item["ROOM_TYPE"].ToString(); r.CR_DATE = item["CRDATE"].ToString(); r.REQUEST_ID = Convert.ToInt32(item["ID"]); r.REQUEST_TEXT = item["COMMENT"].ToString(); // r.SERVICE_NAME = item["SERVICE_NAME"].ToString(); r.STATUS = item["STATUS"].ToString(); r.PLAN_END_DATE = item["WORKDATE"].ToString(); r.ATRIBUTE = item["GUID"].ToString(); r.FIRST_NAME = item["CLIENT"].ToString(); r.STATUS_ID = item["STATUS_ID"].ToString(); r.REQUEST_COMMENT = item["PAYED"].ToString(); // r.EMERGENCY_TREATMENT = (item["ORDER"].ToString() == "1") ? true : false; //(bool)item["EMERGENCY_TREATMENT"]; r.ADRESS = item["OBJECT"].ToString(); rs.Add(r); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rs)); }
public static string GetRole(int M_Id) { //List<Kvorum_App.Client_Admin.Utilities.Roles> rs = new List<Kvorum_App.Client_Admin.Utilities.Roles>(); //DataTable dt = Mydb.ExecuteReadertoDataTable("select * from ROLE", new SqlParameter[] {}, CommandType.Text); //foreach (DataRow item in dt.Rows) //{ // Kvorum_App.Client_Admin.Utilities.Roles role = new Kvorum_App.Client_Admin.Utilities.Roles(); // role.ROLE_NAME = item["ROLE_NAME"].ToString(); // role.ROLE_ID = Convert.ToInt32(item["ROLE_ID"]); // rs.Add(role); //} //JavaScriptSerializer js = new JavaScriptSerializer(); //return js.Serialize(rs); List <Kvorum_App.Client_Admin.Utilities.Roles> rs = new List <Kvorum_App.Client_Admin.Utilities.Roles>(); DataTable dt = Mydb.ExecuteReadertoDataTable("select r.ROLE_ID,r.ROLE_NAME from RolesForModul rm, ROLE r where r.ROLE_ID=rm.R_ID and M_ID=@m", new SqlParameter[] { new SqlParameter("@m", M_Id) }, CommandType.Text); foreach (DataRow item in dt.Rows) { Utilities.Roles r = new Utilities.Roles(); r.ROLE_ID = Convert.ToInt32(item["ROLE_ID"]); r.ROLE_NAME = item["ROLE_NAME"].ToString(); rs.Add(r); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rs)); }
public static string GetDetailUO(int CLId_, int UoId_) { DataTable dt = Mydb.ExecuteReadertoDataTable("select * from MAN_COMPANY where MAN_COMPANY_ID=@id and CLIENT_ID=@ClId", new SqlParameter[] { new SqlParameter("@id", UoId_), new SqlParameter("@ClId", CLId_) }, CommandType.Text); DataRow item = dt.Rows[0]; Kvorum_App.Client_Admin.Utilities.ManCompany ms = new Kvorum_App.Client_Admin.Utilities.ManCompany(); ms.ADRESS = item["ADRESS"].ToString(); ms.ADRESS_ID = item["ADRESS_ID"].ToString(); ms.CLIENT_ID = Convert.ToInt32(item["CLIENT_ID"]); ms.EMAIL = item["EMAIL"].ToString(); ms.FB = item["FB"].ToString(); ms.INN = item["INN"].ToString(); ms.KPP = item["KPP"].ToString(); ms.LICENCE = item["LICENCE"].ToString(); ms.MAN_COMPANY_ID = Convert.ToInt32(item["MAN_COMPANY_ID"]); ms.NAME = item["NAME"].ToString(); ms.OGRN = item["OGRN_OGRNIP"].ToString(); ms.OK = item["OK"].ToString(); ms.OKPO = item["OKPO"].ToString(); ms.PHONE = item["PHONE"].ToString(); ms.TW = item["TW"].ToString(); ms.VK = item["VK"].ToString(); JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(ms)); }
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 GetCheckedObjects(int DD, string Cl_Id) { DataTable dt = Mydb.ExecuteReadertoDataTable("select * from OBJECT where ISNULL(IS_DELETED,0)<>1 and CLIENT_ID=@C", new SqlParameter[] { new SqlParameter("@C", Cl_Id) }, CommandType.Text); List <ObjectS> os = new List <ObjectS>(); foreach (DataRow item in dt.Rows) { ObjectS o = new ObjectS(); int COuntCHecked = (int)Mydb.ExecuteScalar("select COUNT(*) from DISP_OBJECT where DISP_ID=@d and OBJECT_ID=@o", new SqlParameter[] { new SqlParameter("@d", DD), new SqlParameter("@o", Convert.ToInt32(item["OBJECT_ID"])) }, CommandType.Text); if (COuntCHecked == 1) { o.Object_Id = Convert.ToInt32(item["Object_Id"]); o.ObjectAdress = item["OBJECT_ADRESS"].ToString(); o.ObjectPhoto = "1"; } if (COuntCHecked == 0) { int IsOtherDispObj = (int)Mydb.ExecuteScalar("select COUNT(*) from DISP_OBJECT where OBJECT_ID=@o", new SqlParameter[] { new SqlParameter("@o", Convert.ToInt32(item["Object_Id"])) }, CommandType.Text); if (IsOtherDispObj == 0) { o.Object_Id = Convert.ToInt32(item["Object_Id"]); o.ObjectAdress = item["OBJECT_ADRESS"].ToString(); o.ObjectPhoto = "0"; } } os.Add(o); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(os)); }
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 SearchLog(int l_g, string Stext, int Cl) { if (Stext.Contains("|")) { Stext.Replace("|", ":"); } DataTable dt = Mydb.ExecuteReadertoDataTable("Orx_Search_Log", new SqlParameter[] { new SqlParameter("@C", l_g), new SqlParameter("@Stext", Stext) }, CommandType.StoredProcedure); List <LOG_GLOBAL> lgs = new List <LOG_GLOBAL>(); foreach (DataRow item in dt.Rows) { LOG_GLOBAL lg = new LOG_GLOBAL(); lg.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString(); lg.DATESTAMP = item["DATESTAMP"].ToString(); lg.EVENT_MAKER = item["EVENT_MAKER"].ToString(); lg.EVENT_MESSAGE = item["EVENT_MESSAGE"].ToString(); lg.EVENT_MODULE = item["EVENT_MODULE"].ToString(); lg.EVENT_ROLE = item["EVENT_ROLE"].ToString(); lg.EVENT_STATUS = item["EVENT_STATUS"].ToString(); lg.EVENT_TYPE = item["EVENT_TYPE"].ToString(); lg.E_MAIL = item["E_MAIL"].ToString(); lg.id = item["id"].ToString(); lgs.Add(lg); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(lgs)); }
public static string GetNotDispAcc(int ClId, int DD) { 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 ROLE_ID=6 or ROLE_ID=2 or ROLE_ID=3))", new SqlParameter[] { new SqlParameter("@c", ClId) }, CommandType.Text); //List<Account_> ass = new List<Account_>(); List <Account_Disp> ads = new List <Account_Disp>(); foreach (DataRow item in dt.Rows) { // Account_ a = new Account_();// Account_Disp ad = new Account_Disp(); int Countlog = (int)Mydb.ExecuteScalar("select count(*) from DISP_ACC where LOG_IN_ID=@lg ", new SqlParameter[] { new SqlParameter("@lg", Convert.ToInt32(item["LOG_IN_ID"])) }, CommandType.Text);//, new SqlParameter("@d", DD) and DISP_ID=@d if (Countlog == 0) { //a.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString(); //a.LOG_IN_ID = Convert.ToInt32(item["LOG_IN_ID"]); //a.ENTITY_TYPE_ID = (int)Mydb.ExecuteScalar("select ROLE_ID from MODUL_ROLE where MR_ID=(select MR_ID from ACCOUNT_ROLE where LOG_IN_ID=@lg)", new SqlParameter[] { new SqlParameter("@lg", a.LOG_IN_ID) }, CommandType.Text); //ass.Add(a); ad.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString(); ad.LOG_IN_ID = item["LOG_IN_ID"].ToString(); DataTable dtRoles = Mydb.ExecuteReadertoDataTable("select ROLE_ID from MODUL_ROLE where MR_ID in (select MR_ID from ACCOUNT_ROLE where LOG_IN_ID=@lg)", new SqlParameter[] { new SqlParameter("@lg", Convert.ToInt32(ad.LOG_IN_ID)) }, CommandType.Text); List <Roles> rls = new List <Roles>(); foreach (DataRow itemrls in dtRoles.Rows) { Roles rl = new Roles(); rl.ROLE_ID = Convert.ToInt32(itemrls["ROLE_ID"]); rls.Add(rl); } ad.roles = rls; ads.Add(ad); } } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(ads)); }
public static string GetMeterDetail(int mid) { DataTable dt = Mydb.ExecuteReadertoDataTable("GetMeterDetail ", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.StoredProcedure); List <METERS> ms = new List <METERS>(); foreach (DataRow item in dt.Rows) { METERS m = new METERS(); m.AMUNT_TARIF = item["AMUNT_TARIF"].ToString(); m.LOG_IN_ID = item["ARXIV"].ToString() + "|" + item["SUSBEND"].ToString(); m.METERS_ID = item["METERS_ID"].ToString(); m.METERS_NUMBER = item["METERS_NUMBER"].ToString(); m.NEXT_DATE = item["NEXT_DATE"].ToString(); m.OBJECT_ID = item["OBJECT_ID"].ToString(); m.PREVIOUS_DATE = item["PREVIOUS_DATE"].ToString(); m.ROOM_NUMBER = item["ROOM_NUMBER2"].ToString(); m.ROOM_TYPE = item["ROOM_TYPE"].ToString(); m.ROOM_TYPE_ID = item["ROOM_TYPE_ID2"].ToString(); m.SCORE_ID = item["SCORE_ID"].ToString(); m.TYPE = item["TYPE"].ToString(); m.TYPE_ID = item["TYPE_ID"].ToString(); m.IS_AUTO = item["IS_AUTO"].ToString(); ms.Add(m); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(ms)); }
public string GetStreetsBytext(string txt, string loc) { int prjId = 0; if (loc.Contains("/Fili/LoginF.aspx")) { prjId = 3; } if (loc.Contains("/Symbol/LoginS.aspx")) { prjId = 2; } DataTable dt = Mydb.ExecuteReadertoDataTable("select OBJECT_ID,OBJECT_ADRESS from OBJECT where OBJECT_ADRESS like '%'+@txt+'%' and PROJECT_ID=@prj", new SqlParameter[] { new SqlParameter("@txt", txt), new SqlParameter("prj", prjId) }, CommandType.Text); List <ObjectS> objs = new List <ObjectS>(); foreach (DataRow item in dt.Rows) { ObjectS obj = new ObjectS(); obj.ObjectAdress = item["OBJECT_ADRESS"].ToString(); obj.Object_Id = Convert.ToInt32(item["OBJECT_ID"]); objs.Add(obj); } return(JsonConvert.SerializeObject(objs)); }
public static string GetDisps(int C) { int CNTDisp = (int)Mydb.ExecuteScalar("select COUNT(*) from DISP where CLIENT_ID=@C", new SqlParameter[] { new SqlParameter("@C", C) }, CommandType.Text); if (CNTDisp != 0) { DataTable dt = Mydb.ExecuteReadertoDataTable("select d.DISP_ID,d.DISP_STATUS,d.DISP_NAME,dc.DISP_ICON_IMG from DISP d,DISP_ICON dc where d.DISP_ICON_ID=dc.DISP_ICON_ID and d.CLIENT_ID=@C order by d.DISP_ID desc", new SqlParameter[] { new SqlParameter("@C", C) }, CommandType.Text); List <Dispatcheer> disps = new List <Dispatcheer>(); foreach (DataRow item in dt.Rows) { Dispatcheer d = new Dispatcheer(); d.DISP_ICON_IMG = item["DISP_ICON_IMG"].ToString(); d.DISP_ID = Convert.ToInt32(item["DISP_ID"]); d.DISP_NAME = item["DISP_NAME"].ToString(); d.DISP_STATUS = Convert.ToBoolean(item["DISP_STATUS"]); disps.Add(d); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(disps)); } else { return("{\"result\" : \"2\"}"); } }
public string GetRFP(string sc) { DataTable dt = Mydb.ExecuteReadertoDataTable("select * from RECIEPT_FOR_PAYMENT where SCORE_ID=@sc order by RECIEPT_FOR_PAYMENT_ID desc", new SqlParameter[] { new SqlParameter("@sc", sc) }, CommandType.Text); List <RFP> rfps = new List <RFP>(); int objId = (int)Mydb.ExecuteScalar("select OBJECT_ID from PER_SCORE where SCORE_ID=@sc", new SqlParameter[] { new SqlParameter("@sc", sc) }, CommandType.Text); foreach (DataRow item in dt.Rows) { RFP rfp = new RFP(); rfp.ACCURED_SUMM = item["ACCURED_SUMM"].ToString(); rfp.BACKLOG_START = item["BACKLOG_START"].ToString(); rfp.DATA_MOUNTH_YEAR = item["DATA_MOUNTH_YEAR"].ToString(); rfp.PAYMENT_SUM = item["PAYMENT_SUMM"].ToString(); rfp.RECIEPT_FOR_PAYMENT_ID = (int)item["RECIEPT_FOR_PAYMENT_ID"]; rfp.PAY_DATE = item["PAY_DATE"].ToString(); rfp.MASTER_GUID = item["MASTER_GUID"].ToString(); rfp.PAYED = item["PAYED"].ToString(); rfp.GENERAL_SUM = item["GENERAL_SUM"].ToString(); rfp.RECEIVED = item["RECEIVED"].ToString(); rfp.PAYMENT_SUM = Mydb.ExecuteScalar("TestDB.dbo.sp_QUICK_API_get_shopId", new SqlParameter[] { new SqlParameter("@tokenid", ""), new SqlParameter("@login", ""), new SqlParameter("@obj", objId) }, CommandType.StoredProcedure).ToString(); rfps.Add(rfp); } return(JsonConvert.SerializeObject(rfps)); }
public string GetDailInf(int rfpId, int obj) { //DataTable dt = Mydb.ExecuteReadertoDataTable("select dt.ACCURED_SUMM,dt.PAYED,dt.PAY_GUID,rs.SERVICE_NAME from DETAIL_INF dt inner join RFP_SERVICES rs on rs.RFP_SERVICE_ID=dt.RFP_SERVICE_ID and dt.RECIEPT_FOR_PAYMENT_ID=@rfpId", new SqlParameter[] { new SqlParameter("@rfpId", rfpId) }, CommandType.Text); DataTable dt = Mydb.ExecuteReadertoDataTable("GetDailInf", new SqlParameter[] { new SqlParameter("@rfpId", rfpId) }, CommandType.StoredProcedure); List <Payment_Details> pds = new List <Payment_Details>(); Payment_Details p_d = new Payment_Details(); p_d.PAYMENT_SUM = Mydb.ExecuteScalar("TestDB.dbo.sp_QUICK_API_get_shopId", new SqlParameter[] { new SqlParameter("@tokenid", ""), new SqlParameter("@login", ""), new SqlParameter("@obj", obj) }, CommandType.StoredProcedure).ToString(); pds.Add(p_d); foreach (DataRow item in dt.Rows) { Payment_Details pd = new Payment_Details(); pd.ACCURED_SUMM = item["ACCURED_SUMM"].ToString(); pd.SERVICE_NAME = item["SERVICE_NAME"].ToString(); pd.PAYMENT_SUM = item["PAYED"].ToString(); pd.PAY_GUID = item["PAY_GUID"].ToString(); pd.VOLUME = item["VOLUME"].ToString(); pd.EDIZM = item["EDIZM"].ToString(); pd.TARIF = item["TARIF"].ToString(); pd.PRIVILEGES = item["PRIVILEGES"].ToString(); pd.RECALCULATIONS = item["RECALCULATIONS"].ToString(); pds.Add(pd); } return(JsonConvert.SerializeObject(pds)); }
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 AllSearch2(int dd, string txt, int lg) { DataTable dt = Mydb.ExecuteReadertoDataTable("uspo_AllSearchRequest2", new SqlParameter[] { new SqlParameter("@dd", dd), new SqlParameter("@Stext", txt) }, CommandType.StoredProcedure); List <Request> rs = new List <Utilities.Request>(); foreach (DataRow item in dt.Rows) { Request r = new Utilities.Request(); r.ROOM_TYPE = item["ROOM_TYPE"].ToString(); r.CR_DATE = item["CR_DATE"].ToString(); r.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString(); r.REQUEST_ID = Convert.ToInt32(item["REQUEST_ID"]); r.REQUEST_TEXT = item["REQUEST_TEXT"].ToString(); r.REQUEST_COMMENT = item["REQUEST_COMMENT"].ToString(); r.STATUS = item["STATUS"].ToString(); r.PLAN_END_DATE = item["PLAN_END_DATE"].ToString(); r.STATUS_ID = item["STATUS_ID"].ToString(); r.ATRIBUTE = (Convert.ToInt32(item["LOG_IN_ID"]) == lg) ? "Curr" : "NotC"; r.EMERGENCY_TREATMENT = (bool)item["EMERGENCY_TREATMENT"]; r.COMMENT_FILE = item["PAYMENT"].ToString(); rs.Add(r); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rs)); }
public static string SearchRequest1(int lg, string Stxt) { System.Data.DataTable dt = Mydb.ExecuteReadertoDataTable("SearchRequest1", new SqlParameter[] { new SqlParameter("@Stext", Stxt), new SqlParameter("@logId", lg) }, CommandType.StoredProcedure); List <Request> rs = new List <Utilities.Request>(); if (dt.Rows.Count != 0) { foreach (DataRow item in dt.Rows) { Request r = new Utilities.Request(); r.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString(); r.ROOM_TYPE = item["ROOM_TYPE"].ToString(); r.CR_DATE = item["CR_DATE"].ToString(); r.REQUEST_ID = Convert.ToInt32(item["REQUEST_ID"]); r.REQUEST_TEXT = item["REQUEST_TEXT"].ToString(); // r.SERVICE_NAME = item["SERVICE_NAME"].ToString(); r.STATUS = item["STATUS"].ToString(); r.PLAN_END_DATE = item["PLAN_END_DATE"].ToString(); r.INDIVIDUAL_ID = Convert.ToInt32(item["INDIVIDUAL_ID"]); r.FIRST_NAME = item["FIRST_NAME"].ToString(); r.STATUS_ID = item["STATUS_ID"].ToString(); r.REQUEST_COMMENT = item["PAYMENT"].ToString(); r.EMERGENCY_TREATMENT = (bool)item["EMERGENCY_TREATMENT"]; rs.Add(r); } } else { System.Data.DataTable dt_1 = Mydb.ExecuteReadertoDataTable("SerachForPServices_1", new SqlParameter[] { new SqlParameter("@lg", lg), new SqlParameter("@Stext", Stxt) }, CommandType.StoredProcedure); foreach (DataRow item in dt_1.Rows) { Request r = new Utilities.Request(); r.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString(); r.CR_DATE = item["CR_DATE"].ToString(); r.REQUEST_ID = Convert.ToInt32(item["REQUEST_ID"]); r.REQUEST_TEXT = item["REQUEST_TEXT"].ToString(); // r.SERVICE_NAME = item["SERVICE_NAME"].ToString(); r.STATUS = item["STATUS"].ToString(); r.PLAN_END_DATE = item["PLAN_END_DATE"].ToString(); r.INDIVIDUAL_ID = Convert.ToInt32(item["INDIVIDUAL_ID"]); r.FIRST_NAME = item["FIRST_NAME"].ToString(); r.STATUS_ID = item["STATUS_ID"].ToString(); r.REQUEST_COMMENT = item["PAYMENT"].ToString(); r.EMERGENCY_TREATMENT = (bool)item["EMERGENCY_TREATMENT"]; rs.Add(r); } } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rs)); }
public static string UpdateAcc(List <MR> SMSR, string accName_, string PNumb_, string Email_, string Pass_, string ClId_, string Login_, int LgId) { DataTable dt_Acc_Role = Mydb.ExecuteReadertoDataTable("select * from ACCOUNT_ROLE where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LgId) }, CommandType.Text); List <MR> mrs = new List <MR>(); foreach (DataRow item in dt_Acc_Role.Rows) { int Mr_Id = Convert.ToInt32(item["MR_ID"]); Mydb.ExecuteNoNQuery("delete from MODUL_ROLE where MR_ID=@mr", new SqlParameter[] { new SqlParameter("@mr", Mr_Id) }, CommandType.Text); } Mydb.ExecuteNoNQuery("delete from ACCOUNT_ROLE where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LgId) }, CommandType.Text); foreach (MR mr in SMSR) { int M_Id = Convert.ToInt32(mr.sm); int R_Id = Convert.ToInt32(mr.sr); /*INSERT INTO table_name (column1, column2, column3, ...) * VALUES (value1, value2, value3, ...);*/ Mydb.ExecuteNoNQuery("insert into MODUL_ROLE (MODUL_ID,ROLE_ID) values (@Mid,@Rid)", new SqlParameter[] { new SqlParameter("@Mid", M_Id), new SqlParameter("@Rid", R_Id) }, CommandType.Text); int LastMr = (int)Mydb.ExecuteScalar("select top 1 MR_ID from MODUL_ROLE order by MR_ID desc", new SqlParameter[] { }, CommandType.Text); Mydb.ExecuteNoNQuery("insert into ACCOUNT_ROLE (LOG_IN_ID,MR_ID) values(@l,@mr)", new SqlParameter[] { new SqlParameter("@l", LgId), new SqlParameter("@mr", LastMr) }, CommandType.Text); } //foreach (MR item in SMSR) //{ // int mr_Id = (int)Mydb.ExecuteScalar("select MR_ID from MODUL_ROLE where ROLE_ID=@r and MODUL_ID=@m", new SqlParameter[] // { // new SqlParameter("@r",Convert.ToInt32(item.sr)), // new SqlParameter("@m",Convert.ToInt32(item.sm)) // }, CommandType.Text); // Mydb.ExecuteNoNQuery("insert into ACCOUNT_ROLE (LOG_IN_ID,MR_ID) values(@l,@mr)", new SqlParameter[] { new SqlParameter("@l", LgId), new SqlParameter("@mr", mr_Id) }, CommandType.Text); //} if (Pass_.Length != 0) { Pass_ = GetMd5HashData(Pass_); Mydb.ExecuteNoNQuery("Update ACCOUNT set E_MAIL=@e,PHONE_NUMBER=@p,PASSWORD=@pas,ACCOUNT_NAME=@acc where LOG_IN_ID=@L", new SqlParameter[] { new SqlParameter("@e", Email_), new SqlParameter("@p", PNumb_), new SqlParameter("@acc", accName_), new SqlParameter("@L", LgId), new SqlParameter("@pas", Pass_) }, CommandType.Text); } else { Pass_ = GetMd5HashData(Pass_); Mydb.ExecuteNoNQuery("Update ACCOUNT set E_MAIL=@e,PHONE_NUMBER=@p,ACCOUNT_NAME=@acc where LOG_IN_ID=@L", new SqlParameter[] { new SqlParameter("@e", Email_), new SqlParameter("@p", PNumb_), new SqlParameter("@acc", accName_), new SqlParameter("@L", LgId) }, CommandType.Text); } return("{\"result\" : \"1\"}"); }
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 AFilterin2(List <Kvorum_App.Disp_Admin.Utilities.Filter> flt, int Log) { string REQUEST_ID = ""; string ROOM_NUMBER = ""; string OBJECT_ID = ""; string ROOM_TYPE_ID = ""; string FIRST_NAME = ""; string STATUS_ID = ""; string CR_DATE_from = ""; string CR_DATEE_TO = ""; foreach (Kvorum_App.Disp_Admin.Utilities.Filter item in flt) { REQUEST_ID = (item.REQUEST_ID != 0) ? "REQUEST_ID=" + item.REQUEST_ID.ToString() : ""; ROOM_NUMBER = (item.ROOM_NUMBER != "0") ? "REQUEST_COMMENT like q%wroomwLw" + item.ROOM_NUMBER.ToString() + "w%q" : ""; ROOM_NUMBER = (ROOM_NUMBER != "") ? ROOM_NUMBER.Replace("q", "'").Replace("w", "\"").Replace("L", ":") : ""; OBJECT_ID = (item.OBJECT_ID != 0) ? "REQUEST_COMMENT like q%zObject_Idzw" + item.OBJECT_ID.ToString() + "%q" : ""; OBJECT_ID = (OBJECT_ID != "") ? OBJECT_ID.Replace("q", "'").Replace("z", "\"").Replace("w", ":") : ""; //ROOM_TYPE_ID = (item.ROOM_TYPE_ID != 0) ? "ROOM_TYPE_ID=" + item.ROOM_TYPE_ID.ToString() + "" : ""; FIRST_NAME = (item.FIRST_NAME != "") ? "REQUEST_COMMENT like q%windNamewLw" + item.FIRST_NAME + "w%q" : ""; FIRST_NAME = (FIRST_NAME != "") ? FIRST_NAME.Replace("q", "'").Replace("w", "\"").Replace("L", ":") : ""; STATUS_ID = (item.STATUSE != 0) ? "STATUS_ID=" + item.STATUSE.ToString() : ""; CR_DATE_from = (item.CR_DATE_FROM != "") ? string.Format("CR_DATE >=\"{0}\"", item.CR_DATE_FROM) : ""; CR_DATE_from = (CR_DATE_from != "") ? CR_DATE_from.Replace("\"", "'") : ""; CR_DATEE_TO = (item.CR_DATE_TO != "") ? string.Format("CR_DATE<=\"{0}\"", item.CR_DATE_TO) : ""; CR_DATEE_TO = (CR_DATEE_TO != "") ? CR_DATEE_TO.Replace("\"", "'") : ""; } string Clid = Mydb.ExecuteScalar("select CLIENT_ID from VW_ALL_REQUESTS_2 where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", Log) }, CommandType.Text).ToString(); string query = "select * from VW_ALL_REQUESTS_2 where CLIENT_ID=" + Clid + " " + ((REQUEST_ID != "") ? " and " + REQUEST_ID : " ") + " " + ((STATUS_ID != "") ? " and " + STATUS_ID : " ") + " " + ((CR_DATE_from != "") ? " and " + CR_DATE_from : " ") + " " + ((CR_DATEE_TO != "") ? " and " + CR_DATEE_TO : " ") + " " + ((ROOM_NUMBER != "") ? " and " + ROOM_NUMBER : " ") + " " + ((OBJECT_ID != "") ? " and " + OBJECT_ID : " ") + " " + ((FIRST_NAME != "") ? " and " + FIRST_NAME : " "); System.Data.DataTable dt = Mydb.ExecuteReadertoDataTable(query, new SqlParameter[] { }, CommandType.Text); List <Request> rs = new List <Utilities.Request>(); foreach (DataRow item in dt.Rows) { Request r = new Utilities.Request(); r.CR_DATE = item["CR_DATE"].ToString(); r.REQUEST_ID = Convert.ToInt32(item["REQUEST_ID"]); r.REQUEST_TEXT = item["REQUEST_TEXT"].ToString(); r.REQUEST_COMMENT = item["REQUEST_COMMENT"].ToString(); r.STATUS = item["STATUS"].ToString(); r.PLAN_END_DATE = item["PLAN_END_DATE"].ToString(); r.STATUS_ID = item["STATUS_ID"].ToString(); r.COMMENT_FILE = (Convert.ToInt32(item["LOG_IN_ID"]) == Log) ? "Curr" : "NoC"; rs.Add(r); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rs)); }
public static string GetAllRequest(int Lg, int dd) { //DataTable dt = Mydb.ExecuteReadertoDataTable("select * from VW_ALL_REQUESTS_2 where DISP_ID=@dd", new SqlParameter[] { new SqlParameter("@dd", dd) }, CommandType.Text); List <Request> rs = new List <Utilities.Request>(); //foreach (DataRow item in dt.Rows) //{ // Request r = new Utilities.Request(); // r.ROOM_TYPE = item["ROOM_TYPE"].ToString(); // r.CR_DATE = item["CR_DATE"].ToString(); // r.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString(); // r.REQUEST_ID = Convert.ToInt32(item["REQUEST_ID"]); // r.REQUEST_TEXT = item["REQUEST_TEXT"].ToString(); // r.REQUEST_COMMENT = item["REQUEST_COMMENT"].ToString(); // r.STATUS = item["STATUS"].ToString(); // r.PLAN_END_DATE = item["PLAN_END_DATE"].ToString(); // r.STATUS_ID = item["STATUS_ID"].ToString(); // r.ATRIBUTE=(Convert.ToInt32(item["LOG_IN_ID"]) == Lg) ? "Curr" : "NotC"; // r.DELIVERY_TYPE_ID = 2; // r.COMMENT_FILE = item["PAYMENT"].ToString(); // r.EMERGENCY_TREATMENT = (bool)item["EMERGENCY_TREATMENT"]; // rs.Add(r); //}select * from VW_ALL_REQUESTS where DISP_ID2=@ddSELECT * FROM VW_ALL_REQUESTS_1_2 WHERE DISP_ID2=@dd or DISP_ID=@dd2 order by CR_DATE desc DataTable dt2 = Mydb.ExecuteReadertoDataTable("GetAllRequests", new SqlParameter[] { new SqlParameter("@dd", dd), new SqlParameter("@dd2", dd) }, CommandType.StoredProcedure); foreach (DataRow item in dt2.Rows) { Request r = new Utilities.Request(); r.ACCOUNT_NAME = item["ACCOUNT_NAME"].ToString(); r.ROOM_TYPE = item["ROOM_TYPE"].ToString(); r.CR_DATE = item["CR_DATE"].ToString(); r.ROOM_NUMBER = item["ROOM_NUMBER"].ToString(); r.REQUEST_ID = Convert.ToInt32(item["REQUEST_ID"]); r.REQUEST_TEXT = item["REQUEST_TEXT"].ToString(); // r.SERVICE_NAME = item["SERVICE_NAME"].ToString(); r.STATUS = item["STATUS"].ToString(); r.PLAN_END_DATE = item["PLAN_END_DATE"].ToString(); r.INDIVIDUAL_ID = (item["INDIVIDUAL_ID"]) == DBNull.Value?-1:Convert.ToInt32(item["INDIVIDUAL_ID"]); r.FIRST_NAME = item["FIRST_NAME"].ToString(); r.STATUS_ID = item["STATUS_ID"].ToString(); r.ATRIBUTE = (item["SPECIALIS_ID"].ToString() != Lg.ToString() || item["LOG_IN_ID"].ToString() == null) ? "NotC" : "Curr"; r.DELIVERY_TYPE_ID = 1; r.ADRESS = item["OBJECT_ADRESS"].ToString(); r.COMMENT_FILE = item["PAYMENT"].ToString(); r.EMERGENCY_TREATMENT = (item["ORDER"].ToString() == "1") ? true : false;//(item["EMERGENCY_TREATMENT"].ToString().Length==0)?false: (bool)item["EMERGENCY_TREATMENT"]; r.MOBILE_NUMBER = item["MOBILE_NUMBER"].ToString(); rs.Add(r); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rs)); }
public string GetObjectById2([FromUri] int id, [FromUri] int c) { List <deneme1> ds = new List <deneme1>(); DataTable dt = Mydb.ExecuteReadertoDataTable("Select * from OBJECT where OBJECT_ID=@obj and CLIENT_ID=@c", new SqlParameter[] { new SqlParameter("@obj", id), new SqlParameter("@c", c) }, CommandType.Text); foreach (DataRow item in dt.Rows) { deneme1 d = new deneme1(); d.deger1 = item["OBJECT_ADRESS"].ToString(); ds.Add(d); } return(JsonConvert.SerializeObject(ds)); }
public string searcServices([FromUri] string txt, int o) { DataTable dt = Mydb.ExecuteReadertoDataTable("GiveServiceBySearch", new SqlParameter[] { new SqlParameter("@objId", o), new SqlParameter("@txt", txt) }, CommandType.StoredProcedure); //item["SERVICE_NAME"].ToString(); List <deneme1> ds = new List <deneme1>(); foreach (DataRow item in dt.Rows) { deneme1 d = new deneme1(); d.deger1 = item["SERVICE_NAME"].ToString(); ds.Add(d); } return(JsonConvert.SerializeObject(ds)); }
public string AddCounterValueT(int mid, string values_T, int tarif) { // values_T = "{T1: \"1\",T2:\"2\", T3:\"3\"}"; dynamic T_Values = JsonConvert.DeserializeObject(values_T); var ValueT1 = T_Values.T1.Value; var ValueT2 = (tarif >= 2)?T_Values.T2.Value:null; var ValueT3 = (tarif == 3) ?T_Values.T3.Value:null; Mydb.ExecuteReadertoDataTable("InsertOrUpdateELectricMeter", new SqlParameter[] { new SqlParameter("@VALUE_", ValueT1), new SqlParameter("@VALUE_2", ((ValueT2 == null) ? DBNull.Value : ValueT2)), new SqlParameter("@VALUE_3", (string.IsNullOrEmpty(ValueT3)?DBNull.Value: ValueT3)), new SqlParameter("@METERS_ID", mid) }, CommandType.StoredProcedure); return(Mydb.ExecuteAsJson("GetLastValueAndAVG_of_Meters", new SqlParameter[] { new SqlParameter("@id", mid) }, CommandType.StoredProcedure));; }
public static string getmodulNamebyid(int Lg) { DataTable dt = Mydb.ExecuteReadertoDataTable("select MODUL_NAME from MODUL where MODUL_ID in (select MODUL_ID from MODUL_ROLE where MR_ID in (select MR_ID from ACCOUNT_ROLE where LOG_IN_ID=@log))", new SqlParameter[] { new SqlParameter("@log", Lg) }, CommandType.Text); List <MODUL> ms = new List <MODUL>(); foreach (DataRow item in dt.Rows) { MODUL m = new MODUL(); m.MODUL_NAME = item["MODUL_NAME"].ToString(); ms.Add(m); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(ms)); }
public static string GetRolesNameById(int lg) { DataTable dt = Mydb.ExecuteReadertoDataTable("select ROLE_NAME from ROLE where ROLE_ID in (select ROLE_ID from MODUL_ROLE where MR_ID in (select MR_ID from ACCOUNT_ROLE where LOG_IN_ID=@log))", new SqlParameter[] { new SqlParameter("@log", lg) }, CommandType.Text); List <Roles> rls = new List <Roles>(); foreach (DataRow item in dt.Rows) { Roles rl = new Roles(); rl.ROLE_NAME = item["ROLE_NAME"].ToString(); rls.Add(rl); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rls)); }
public static string DeleteAccount(int LogId) { Mydb.ExecuteNoNQuery("delete from ACCOUNT where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LogId) }, CommandType.Text); DataTable dt_Acc_Role = Mydb.ExecuteReadertoDataTable("select * from ACCOUNT_ROLE where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LogId) }, CommandType.Text); List <MR> mrs = new List <MR>(); foreach (DataRow item in dt_Acc_Role.Rows) { int Mr_Id = Convert.ToInt32(item["MR_ID"]); Mydb.ExecuteNoNQuery("delete from MODUL_ROLE where MR_ID=@mr", new SqlParameter[] { new SqlParameter("@mr", Mr_Id) }, CommandType.Text); } Mydb.ExecuteNoNQuery("delete from ACCOUNT_ROLE where LOG_IN_ID=@lg", new SqlParameter[] { new SqlParameter("@lg", LogId) }, CommandType.Text); return("{\"result\" : \"1\"}"); }