public LoginDataUser GetConnectString(LoginDataUser LoginClient) { //string Tendata = "ACMAN_DOANHNGHIEP"; //string Username = "******"; //string Matkhau = "1"; string x1 = ""; try { var bussinessItem = mdb.SERVER_ONLINE.FirstOrDefault(x => x.TEN_DATA.Equals(LoginClient.TenData)); if (bussinessItem == null) { return(null); } var entityConnectionStringBuilder = new EntityConnectionStringBuilder(); entityConnectionStringBuilder.Provider = "System.Data.SqlClient"; entityConnectionStringBuilder.ProviderConnectionString = @"Data Source=" + bussinessItem.SERVER + "; Initial Catalog=" + bussinessItem.TEN_DATA + ";Integrated Security=False;User Id=" + bussinessItem.USER_NAME + ";Password="******";MultipleActiveResultSets=True;;App=EntityFramework""; //entityConnectionStringBuilder.Metadata = "res://*"; entityConnectionStringBuilder.Metadata = "res://*";// /Models.DoanhNghiepModel.csdl|res://*/Models.DoanhNghiepModel.ssdl|res://*/Models.DoanhNghiepModel.msl"; var bussinessInfo = new ConnectStringInfo { connectionString = entityConnectionStringBuilder.ToString(), DNID = bussinessItem.ID }; var DNdb = new DoanhNghiepDbcontext(bussinessInfo.connectionString); var DnItem = DNdb.USER_LIST.FirstOrDefault(x => x.USER_NAME.Equals(LoginClient.Username) && x.PASSWORD.Equals(LoginClient.Password)); if (DnItem == null) { return(null); } var Login1 = new LoginDoanhNghiepModel { So_User = (int)bussinessItem.SOLUONG_USER, FullName = DnItem.HO_TEN, UserName = DnItem.USER_NAME }; return(LoginClient); } catch (Exception ex) { x1 = ex.ToString(); return(null); } }
protected override void OnActionExecuting(ActionExecutingContext filterContext) { bussinessInfo = SecurityExtention.GetPackageService(Session["ConnectStringInfo"].ToString()); dbUser = new DoanhNghiepDbcontext(bussinessInfo.connectionString); }
public static string GetPackageServiceJson(ConnectStringInfo obj) { return(new JavaScriptSerializer().Serialize(obj)); }