private void BindUser() { string conn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString; using (SqlConnection con = new SqlConnection(conn)) { con.Open(); if (con.State == ConnectionState.Open) { SqlCommand cmd = new SqlCommand("select * from [User] WHERE UserID=" + Convert.ToInt32(Session["Target"]) + "", con); //SqlParameter param = new SqlParameter(); //param.ParameterName = "@UserID"; //param.Value = user2; //cmd.Parameters.Add(param); //cmd.Parameters.Add(new SqlParameter("@UserID", user2)); //SqlCommand cmd = new SqlCommand("select * from [User] WHERE UserID = @ID", con);//where userid=3 veya session falan filan //cmd.Parameters.Add("@ID", SqlDbType.Int); //cmd.Parameters["@ID"].Value = user2; using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { DataTable dt = new DataTable(); sda.Fill(dt); RepUser.DataSource = dt; RepUser.DataBind(); //sessionla user bigisi al } } } }
public void EditProfile(ContactViewModel contactModel) { //int RepId = Convert.ToInt32(UserViewModel.RepresentativeInfoObj.UserID); //int repUserId = UserVM.CRMModelProperties.RepID; RepUser userProfile = _Context.RepUser.GetSingle(e => e.RepID == UserVM.CRMModelProperties.RepID); if (userProfile != null) { userProfile.Biodata = contactModel.AboutRep; userProfile.PhoneCustomerService = contactModel.PhoneCustomerService; // userProfile.UserId = repUserId; _Context.RepUser.SaveChanges(); } }
public ContactViewModel getPenworthyContactDetails(int userID) { ContactViewModel contactVM = new ContactViewModel(); QuoteViewService qvs = new QuoteViewService(); RepUser userProfile = new RepUser(); User repuser = new User(); string dir = ConfigurationManager.AppSettings["ContactusImageDirectory"]; User crtuserdetails = _Context.User.GetSingle(e => e.UserId == userID); if (UserVM != null) { if (UserVM.CRMModelProperties != null && !UserVM.CRMModelProperties.IsRepLoggedIN) { // repuser = _Context.User.GetSingle(e => e.CustAutoID == crtuserdetails.CustAutoID); repuser = crtuserdetails.Customer.CustomerRep.RepUser.User; } else { repuser = _Context.User.GetSingle(e => e.UserId == userID); } } else { repuser = _Context.User.GetSingle(e => e.UserId == userID); } //int repID = repuser.RepID == null ? repuser.Customer.CustomerRep.RepID :(int) repuser.RepID; //int repUserId = _Context.User.GetSingle(e => e.RepID == repID).UserId; //userProfile = _Context.RepUser.GetSingle(e => e.RepID == UserVM.CRMModelProperties.RepID); if (repuser != null) { contactVM.RepName = repuser.FirstName + " " + repuser.LastName; contactVM.RepEmail = repuser.Email; contactVM.PhoneCustomerService = repuser.RepUsers.FirstOrDefault().PhoneCustomerService; contactVM.PhoneDirect = repuser.RepUsers.FirstOrDefault().PhoneDirect; contactVM.AboutRep = repuser.RepUsers.FirstOrDefault().Biodata; contactVM.RepImage = dir + repuser.RepUsers.FirstOrDefault().RepID + ".jpg"; contactVM.Title = repuser.RepUsers.FirstOrDefault().Title; } contactVM.UserVM = UserVM; qvs.UserVM = UserVM; contactVM.UserVM.CurrentQuoteID = qvs.getCustomerSCQuoteID(); return(contactVM); }
FillCRMProperties(UserViewModel usrModelProp, User usr) { if (usr.webpages_Roles.FirstOrDefault().RoleId == (int)UserRolesEnum.Repo || usr.webpages_Roles.FirstOrDefault().RoleId == (int)UserRolesEnum.AdminRep) { User custUser = null; if (usrModelProp.CRMModelProperties != null) { custUser = InsertUpdateUser(usrModelProp); } usrModelProp.CRMModelProperties.CustFirstName = custUser.FirstName; usrModelProp.CRMModelProperties.CustLastName = custUser.LastName; usrModelProp.CRMModelProperties.CustEmail = custUser.Email; usrModelProp.CRMModelProperties.CustAutoID = Convert.ToInt32(custUser.CustAutoID); usrModelProp.CRMModelProperties.custName = custUser.Customer == null ? string.Empty : custUser.Customer.CustomerName; usrModelProp.CRMModelProperties.CustNO = custUser.Customer.CustomerNO; usrModelProp.CRMModelProperties.CustParentName = custUser.Customer.CustomerName; usrModelProp.CRMModelProperties.LoggedINCustomerUserID = custUser.UserId; usrModelProp.CRMModelProperties.CRMPersonID = Convert.ToInt32(custUser.PersonID); // usrModelProp.CRMModelProperties.Persphone = usrModelProp.CustomerAccountInfoObj.PhoneNuber; usrModelProp.CRMModelProperties.RepEmail = usr.Email; usrModelProp.CRMModelProperties.RepID = usrModelProp.CRMModelProperties.RepID; //(int)usr.RepUsers.FirstOrDefault().RepID; usrModelProp.CRMModelProperties.RepName = usr.UserName; usrModelProp.CRMModelProperties.RepPhoneDirect = usr.RepUsers.FirstOrDefault().PhoneDirect; usrModelProp.CRMModelProperties.RepPhoneCustSrvc = usr.RepUsers.FirstOrDefault().PhoneCustomerService; usrModelProp.CRMModelProperties.IsUserActive = (bool)custUser.ISActive; usrModelProp.CRMModelProperties.DivNO = usrModelProp != null && usrModelProp.CRMModelProperties != null ? usrModelProp.CRMModelProperties.DivNO : (int)custUser.Customer.DivisionNo; usrModelProp.CRMModelProperties.LoggedINUserID = usr.UserId; usrModelProp.CRMModelProperties.IsRepLoggedIN = true; usrModelProp.CRMModelProperties.IsReqPropFilled = true; usrModelProp.CustomerAddressBaseModel = GetCustomerShipToAddress(usrModelProp.CRMModelProperties.CustAutoID); } else { RepUser repUser = null; if (usr.Customer.CustomerRep == null) { repUser = _context.RepUser.GetSingle(e => e.RepUserID == 25);//Defualt repuerid - 25 - Julie.Plantz } else { repUser = _context.RepUser.GetSingle(e => e.RepUserID == usr.Customer.CustomerRep.RepUserID); } usrModelProp.CRMModelProperties = new CRMModel(); usrModelProp.CRMModelProperties.CustFirstName = usr.FirstName; usrModelProp.CRMModelProperties.CustLastName = usr.LastName; usrModelProp.CRMModelProperties.CustEmail = usr.Email; usrModelProp.CRMModelProperties.CustAutoID = Convert.ToInt32(usr.CustAutoID); usrModelProp.CRMModelProperties.CustParentName = usr.Customer.CustomerName; usrModelProp.CRMModelProperties.LoggedINCustomerUserID = usr.UserId; usrModelProp.CRMModelProperties.CRMPersonID = Convert.ToInt32(usr.PersonID); usrModelProp.CRMModelProperties.CustNO = usr.Customer.CustomerNO; usrModelProp.CRMModelProperties.custName = usr.Customer == null ? string.Empty : usr.Customer.CustomerName; // usrModelProp.CRMModelProperties.Persphone = usrModelProp.CustomerAccountInfoObj.PhoneNuber; usrModelProp.CRMModelProperties.RepEmail = repUser.User.Email; usrModelProp.CRMModelProperties.RepID = (int)repUser.RepID; usrModelProp.CRMModelProperties.RepName = repUser.User.UserName; usrModelProp.CRMModelProperties.RepPhoneDirect = repUser.PhoneDirect; usrModelProp.CRMModelProperties.RepPhoneCustSrvc = repUser.PhoneCustomerService; usrModelProp.CRMModelProperties.IsUserActive = (bool)usr.ISActive; usrModelProp.CRMModelProperties.DivNO = usrModelProp != null && usrModelProp.CRMModelProperties != null ? usrModelProp.CRMModelProperties.DivNO : (int)usr.Customer.DivisionNo; usrModelProp.SCCount = GetSCCountByCustID(Convert.ToInt32(usr.UserId)); usrModelProp.SCPrice = GetSCPriceByCustID(Convert.ToInt32(usr.UserId)); usrModelProp.CRMModelProperties.LoggedINUserID = usr.UserId; usrModelProp.CRMModelProperties.IsRepLoggedIN = false; usrModelProp.CRMModelProperties.IsReqPropFilled = true; usrModelProp.CustomerAddressBaseModel = GetCustomerShipToAddress(usrModelProp.CRMModelProperties.CustAutoID); } }
public LoginController(RepUser repUser) { _repUser = repUser; }
public CartDWPdfModel GetQuotePdfDetails(int quoteid) { CartDWPdfModel quotePdfVM = new CartDWPdfModel(); Quote quote = _Context.Quote.GetSingle(e => e.QuoteID == quoteid); if (quote != null) { quotePdfVM.QuoteID = quoteid; quotePdfVM.IncludeCatalogStatus = quote.IncludeCatalogStatus != null ? (bool)quote.IncludeCatalogStatus : false; List <Item> lstItem = quote.QuoteDetails.Select(e => e.Item).ToList(); string taxschuduleID = quote.User.Customer != null ? quote.User.Customer.TaxScheduleID : null; if (string.IsNullOrEmpty(taxschuduleID) || taxschuduleID == "NONTAX") { quotePdfVM.SalesTax = 0; } else { quotePdfVM.SalesTax = Convert.ToDecimal(_Context.TaxSchedule.GetSingle(e => e.TaxScheduleID == taxschuduleID).TaxRate); } string statusenumB = Convert.ToString((char)ItemStatusEnum.OnListButNotPreViewable); string statusenumD = Convert.ToString((char)ItemStatusEnum.OnListAndPreViewable); quotePdfVM.CartListView = quote.QuoteDetails.Where(e => e.Item.Status == statusenumB || e.Item.Status == statusenumD).Select(c => new CartViewModel { Title = c.Item.Title, Author = c.Item.Author == null ? "" : c.Item.Author.AuthorName, ISBN = c.Item.ISBN, AR = c.Item.ARLevel, Lexile = c.Item.Lexile, ItemPrice = (double)c.Item.Price, ItemId = c.Item.ItemID, DwstatusID = c.DWSelectionID.ToString(), Quantity = c.Quantity, Series = c.Item.SeriesAndCharacter1 == null ? "" : c.Item.SeriesAndCharacter1.SCText, QuoteDetailID = c.QuoteDetailID, AcRcLevelText = (c.Item.ARLevel != null && Convert.ToDouble(c.Item.ARLevel) > 0 ? "AR" : "") + (c.Item.ARLevel != null && c.Item.RCLevel != null && Convert.ToDouble(c.Item.ARLevel) > 0 && Convert.ToDouble(c.Item.RCLevel) > 0 ? "," : "") + (c.Item.RCLevel != null && Convert.ToDouble(c.Item.RCLevel) > 0 ? "RC" : ""), Type = string.Empty }).OrderBy(e => e.Title).ToList(); if ((bool)quotePdfVM.IncludeCatalogStatus == true) { List <FlatFileDetailModel> lstCatalogInfo = GetCatalogInfoData(UserVM.CRMModelProperties.CustAutoID, quoteid, "Cart"); quotePdfVM.CartListView.AddRange(lstCatalogInfo.Select(c => new CartViewModel { Title = c.ItemNumber, Author = string.Empty, ISBN = string.Empty, AR = null, Lexile = string.Empty, ItemId = c.ItemCode, Quantity = c.Quantity, ItemPrice = c.ItemPrice, Price = c.Price, IncludeCatalog = c.ItemNumber == "Special Bulk Charge" ? false : true, Type = "Catalog", }).ToList()); } quotePdfVM.QuoteTypeID = Convert.ToInt32(quote.QuoteTypeID); quotePdfVM.RepoAddress = new CRMModel(); quotePdfVM.CustomerAddress = new AddressBaseModel(); quotePdfVM.QuoteID = quoteid; RepUser repoAddress = null; if (quote.User.Customer.CustomerRep != null) { repoAddress = quote.User.Customer.CustomerRep.RepUser != null ? quote.User.Customer.CustomerRep.RepUser : null; } else { repoAddress = _Context.RepUser.GetSingle(e => e.RepID == 302); //Default Rep } quotePdfVM.RepoAddress.RepName = repoAddress.User != null ? repoAddress.User.FirstName + " " + repoAddress.User.LastName : string.Empty; quotePdfVM.RepoAddress.RepEmail = repoAddress.User != null ? repoAddress.User.Email : string.Empty; quotePdfVM.RepoAddress.Persphone = repoAddress != null ? repoAddress.PhoneCustomerService : string.Empty; quotePdfVM.PONo = quote.QuoteSubmitSaveInfo != null ? quote.QuoteSubmitSaveInfo.PoNo : quote.POText; quotePdfVM.Comments = quote.QuoteSubmitSaveInfo != null ? quote.QuoteSubmitSaveInfo.QuoteSubmitComments : quote.Comments; CustomerAddress customeraddress = quote.User.Customer.CustomerAddress != null ? quote.User.Customer.CustomerAddress : null; quotePdfVM.CustomerAddress.CustomerName = quote.User != null ? quote.User.Customer != null ? quote.User.Customer.CustomerName : string.Empty : string.Empty;; quotePdfVM.CustomerAddress.CustomerNo = customeraddress.Customer.CustomerNO != null ? customeraddress.Customer.CustomerNO : string.Empty; if (customeraddress != null) { quotePdfVM.CustomerAddress.AddressLine1 = customeraddress.AddressLine1 != null ? customeraddress.AddressLine1 : string.Empty; quotePdfVM.CustomerAddress.AddressLine2 = customeraddress.AddressLine2 != null ? customeraddress.AddressLine2 : string.Empty; quotePdfVM.CustomerAddress.AddressLine3 = customeraddress.AddressLine3 != null ? customeraddress.AddressLine3 : string.Empty; quotePdfVM.CustomerAddress.City = customeraddress.City != null ? customeraddress.City : string.Empty; quotePdfVM.CustomerAddress.CountryCode = customeraddress.CountryCode != null ? customeraddress.CountryCode : string.Empty; quotePdfVM.CustomerAddress.State = customeraddress.State != null ? customeraddress.State : string.Empty; quotePdfVM.CustomerAddress.TelephoneNo = customeraddress.TelephoneNo != null ? customeraddress.TelephoneNo : string.Empty; quotePdfVM.CustomerAddress.ZipCode = customeraddress.ZipCode != null ? customeraddress.ZipCode : string.Empty; quotePdfVM.CustomerAddress.CustomerName = customeraddress.Customer.CustomerName != null ? customeraddress.Customer.CustomerName : string.Empty; quotePdfVM.CustomerAddress.CustomerNo = customeraddress.Customer.CustomerNO != null ? customeraddress.Customer.CustomerNO : string.Empty; } } quotePdfVM.UserVM = UserVM; quotePdfVM.UserVM.CRMModelProperties.LoggedINCustomerUserID = quote.UserID; // quotePdfVM.UserVM.SCCount = quote.QuoteDetails.Sum(e => e.Quantity); return(quotePdfVM); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) { global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); RepUser ds = new RepUser(); global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "logsDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { RepUser ds = new RepUser(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; }
public virtual int Update(RepUser dataSet) { return this.Adapter.Update(dataSet, "logs"); }
public virtual int Update(RepUser.logsDataTable dataTable) { return this.Adapter.Update(dataTable); }
public virtual int Fill(RepUser.logsDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }