public int Update(ContactInfoEntity t, string[] properties = null) { using (BrightourDbContext db = new BrightourDbContext()) { return(db.Update(t, properties)); } }
/// <summary> /// 获取差旅客户对应信息 /// </summary> /// <param name="cid"></param> /// <returns></returns> public ContactInfoModel GetCorpContactByCid(int cid) { ContactInfoEntity contactInfoEntity = _contactDal.Query <ContactInfoEntity>(n => n.PCid == cid && n.IsPassenger == "T").FirstOrDefault(); return(Mapper.Map <ContactInfoEntity, ContactInfoModel>(contactInfoEntity)); }
public AddResultBaseModel <int> Add(AddContactModel model) { string cName = model.Cname; string eName = string.Empty; if (model.Cname.Contains("/")) { eName = model.Cname; cName = string.Empty; } List <ContactInfoEntity> contactInfoEntities = _contactDal.Query <ContactInfoEntity>( n => n.Cid == model.Cid && n.IsDel == "F" && (n.Cname == model.Cname || n.Ename == model.Cname), true) .ToList(); if (contactInfoEntities != null && contactInfoEntities.Count > 0) { List <int> contactId = new List <int>(); contactInfoEntities.ForEach(n => contactId.Add(n.Contactid)); int count = _contactIdentificationDal.Query <ContactIdentificationInfoEntity>( n => contactId.Contains(n.Contactid) && n.CardNo == model.CardNo, true).Count(); if (count > 0) { throw new Exception("当前已经存在该信息"); } } ContactInfoEntity contactInfo = new ContactInfoEntity() { Cname = cName, Ename = eName, Mobile = model.Mobile, Cid = model.Cid, LastUpdateTime = DateTime.Now, IsDel = "F", IsPassenger = model.IsPassenger, UpdateOid = "sys", DelTime = DateTime.Now, Email = model.Email, IsOnline = (model.OrderSource == "O" ? 0 : 1) }; contactInfo = _contactDal.Insert <ContactInfoEntity>(contactInfo); _contactIdentificationDal.Insert <ContactIdentificationInfoEntity>(new ContactIdentificationInfoEntity() { Contactid = contactInfo.Contactid, CardNo = model.CardNo, Iid = model.Iid, LastUpdateTime = DateTime.Now }); return(new AddResultBaseModel <int>() { IsSuccessed = true, Id = contactInfo.Contactid }); }
public int Insert(ContactInfoEntity t) { using (BrightourDbContext db = new BrightourDbContext()) { var log = db.ContactInfo.Add(t); db.SaveChanges(); return(log.Contactid); } }
private CandidateContact ConvertToContactEntity(ContactInfoEntity contactInfoEntity, int candidateId) { return(new CandidateContact() { CandidateId = candidateId, EmailAddress = contactInfoEntity.EmailAddress, MobileNumber = contactInfoEntity.MobileNumber, EmergencyContactNumber = contactInfoEntity.EmergencyContact, LandlineContactNumber = contactInfoEntity.LandlineContact }); }
public AddResultBaseModel <int> Edit(EditContactModel model) { ContactInfoEntity contactInfoEntity = _contactDal.Find <ContactInfoEntity>(model.ContactId); if (model.Cname.Contains("/")) { contactInfoEntity.Ename = model.Cname; contactInfoEntity.Cname = string.Empty; } else { contactInfoEntity.Cname = model.Cname; contactInfoEntity.Ename = string.Empty; } contactInfoEntity.Mobile = model.Mobile; contactInfoEntity.LastUpdateTime = DateTime.Now; contactInfoEntity.UpdateOid = "sys"; contactInfoEntity.DelTime = DateTime.Now; contactInfoEntity.Email = model.Email; if (!string.IsNullOrEmpty(model.IsDel)) { contactInfoEntity.IsDel = model.IsDel; } _contactDal.Update(contactInfoEntity); ContactIdentificationInfoEntity contactIdentificationInfoEntity = _contactIdentificationDal.Query <ContactIdentificationInfoEntity>( n => n.Contactid == model.ContactId && n.Iid == model.Iid, true).FirstOrDefault(); if (contactIdentificationInfoEntity != null) { contactIdentificationInfoEntity.Iid = model.Iid; contactIdentificationInfoEntity.CardNo = model.CardNo; contactIdentificationInfoEntity.LastUpdateTime = DateTime.Now; _contactIdentificationDal.Update(contactIdentificationInfoEntity); } else { _contactIdentificationDal.Insert <ContactIdentificationInfoEntity>(new ContactIdentificationInfoEntity() { Contactid = model.ContactId, CardNo = model.CardNo, Iid = model.Iid, LastUpdateTime = DateTime.Now }); } return(new AddResultBaseModel <int>() { IsSuccessed = true, Id = model.ContactId }); }
public void Save(UnitEntity unit, ContactInfoEntity contactInfo) { var db = DatabaseFactory.CreateDatabase(); using (var conn = db.CreateConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { if (string.IsNullOrEmpty(contactInfo.Id)) { contactInfo.Id = Guid.NewGuid().ToString(); ContactInfoRepository.Add(contactInfo, db, trans); } else { ContactInfoRepository.Update(contactInfo, db, trans); } unit.ContactId = contactInfo.Id; if (string.IsNullOrEmpty(unit.Id)) { unit.Id = Guid.NewGuid().ToString(); if (unit.Type == UnitType.Hospital || unit.Type == UnitType.Vendor) { unit.RootId = Constant.DEFAULT_UNIT_ROOT_ID; unit.ParentId = unit.Id; } UnitRepository.Add(unit, db, trans); } else { UnitRepository.Update(unit, db, trans); ClearCache(unit.Id); } trans.Commit(); } catch { trans.Rollback(); throw; } } } }
public ActionResult Create(ContactInfoEntity contactInfoEntity) { try { if (!ModelState.IsValid) { return(View()); } var candidateId = Session["candidateId"]; var result = CandidateService.InsertContactDetails(contactInfoEntity, Convert.ToInt32(candidateId)); return(RedirectToAction("Create", "EducationDetails")); } catch (Exception exception) { return(View()); } }
public static ContactInfoEntity Get(string id) { var sql = string.Format("SELECT {0} FROM contact_info WHERE id=@p_id", COLUMN_SQL); var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_id", DbType.String, id); using (IDataReader reader = db.ExecuteReader(dc)) { if (reader.Read()) { var entity = new ContactInfoEntity(); entity.Init(reader); return(entity); } else { return(null); } } }
public static IList <ContactInfoEntity> GetByVesteeId(string vesteeId) { var sql = string.Format("SELECT {0} FROM contact_info WHERE vestee_id=@p_vestee_id", COLUMN_SQL); var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_vestee_id", DbType.String, vesteeId); var list = new List <ContactInfoEntity>(); using (IDataReader reader = db.ExecuteReader(dc)) { while (reader.Read()) { var entity = new ContactInfoEntity(); entity.Init(reader); list.Add(entity); } } return(list); }
public static void Add(ContactInfoEntity contactInfo, Database db, DbTransaction trans) { var sql = string.Format(@"INSERT INTO contact_info({0}) VALUES(@p_id, @p_vestee_id, @p_contact_person, @p_address, @p_contact_way_1, @p_contact_way_2, @p_contact_way_3, @p_contact_way_4, @p_created_id, @p_created_time, @p_updated_id, @p_updated_time)", COLUMN_SQL); DbCommand dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_id", DbType.String, contactInfo.Id); db.AddInParameter(dc, "p_vestee_id", DbType.String, contactInfo.VesteeId); db.AddInParameter(dc, "p_contact_person", DbType.String, contactInfo.ContactPerson); db.AddInParameter(dc, "p_address", DbType.String, contactInfo.Address); db.AddInParameter(dc, "p_contact_way_1", DbType.String, contactInfo.ContactWay1); db.AddInParameter(dc, "p_contact_way_2", DbType.String, contactInfo.ContactWay2); db.AddInParameter(dc, "p_contact_way_3", DbType.String, contactInfo.ContactWay3); db.AddInParameter(dc, "p_contact_way_4", DbType.String, contactInfo.ContactWay4); db.AddInParameter(dc, "p_created_id", DbType.String, contactInfo.CreatedId); db.AddInParameter(dc, "p_created_time", DbType.DateTime, contactInfo.CreatedTime); db.AddInParameter(dc, "p_updated_id", DbType.String, contactInfo.UpdatedId); db.AddInParameter(dc, "p_updated_time", DbType.DateTime, contactInfo.UpdatedTime); db.ExecuteNonQuery(dc, trans); }
public static void Update(ContactInfoEntity contactInfo, Database db, DbTransaction trans) { var sql = @"UPDATE contact_info SET contact_person = @p_contact_person, address = @p_address, vestee_id = @p_vestee_id, contact_way_1 = @p_contact_way_1, contact_way_2 = @p_contact_way_2, contact_way_3 = @p_contact_way_3, contact_way_4 = @p_contact_way_4, updated_id = @p_updated_id, updated_time = @p_updated_time WHERE id=@p_id"; DbCommand dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_contact_person", DbType.String, contactInfo.ContactPerson); db.AddInParameter(dc, "p_address", DbType.String, contactInfo.Address); db.AddInParameter(dc, "p_vestee_id", DbType.String, contactInfo.VesteeId); db.AddInParameter(dc, "p_contact_way_1", DbType.String, contactInfo.ContactWay1); db.AddInParameter(dc, "p_contact_way_2", DbType.String, contactInfo.ContactWay2); db.AddInParameter(dc, "p_contact_way_3", DbType.String, contactInfo.ContactWay3); db.AddInParameter(dc, "p_contact_way_4", DbType.String, contactInfo.ContactWay4); db.AddInParameter(dc, "p_updated_id", DbType.String, contactInfo.UpdatedId); db.AddInParameter(dc, "p_updated_time", DbType.DateTime, contactInfo.UpdatedTime); db.AddInParameter(dc, "p_id", DbType.String, contactInfo.Id); db.ExecuteNonQuery(dc, trans); }
private void InsertContact(ContactInfoEntity contactInfoEntity, int candidateId) { CandidateRepository.InsertContact(ConvertToContactEntity(contactInfoEntity, candidateId)); }
private void InsertAddress(ContactInfoEntity contactInfoEntity, int candidateId) { CandidateRepository.InsertAddress(ConvertToAddressEntity(candidateId, contactInfoEntity.CurrentAddress, Enums.AddressTypes.Current.ToString())); CandidateRepository.InsertAddress(ConvertToAddressEntity(candidateId, contactInfoEntity.PermanentAddress, Enums.AddressTypes.Permanent.ToString())); }
public ContactInfoEntity InsertContactDetails(ContactInfoEntity contactInfoEntity, int candidateId) { InsertContact(contactInfoEntity, candidateId); InsertAddress(contactInfoEntity, candidateId); return(contactInfoEntity); }
public int AddContact(ContactInfoModel t) { ContactInfoEntity contactInfo = Mapper.Map <ContactInfoModel, ContactInfoEntity>(t); return(_dal.Insert(contactInfo)); }
public ContactInfoSaveCommand(IDataSourceConfig dataSource, ContactInfoEntity contactInfo) { _rowMapper = new ContactInfoRowMapper(); _dataSource = dataSource; _contactInfo = contactInfo; }
public ContactInfoModel GetPassengerContactInfo(int cid) { ContactInfoEntity contactInfo = _dal.GetContactInfoByExpression(n => n.PCid == cid); return(Mapper.Map <ContactInfoEntity, ContactInfoModel>(contactInfo)); }
public int Delete(ContactInfoEntity t) { throw new NotImplementedException(); }
public int UpdateContact(ContactInfoModel t, string[] paramStrings = null) { ContactInfoEntity contactInfo = Mapper.Map <ContactInfoModel, ContactInfoEntity>(t); return(_dal.Update(contactInfo, paramStrings)); }
public bool UpdateCustomerInfo(UpdateCustomerInfoModel up) { CustomerInfoEntity customerInfoEntity = _customerDal.Find <CustomerInfoEntity>(up.Cid); if (customerInfoEntity == null) { throw new Exception("当前客户信息异常"); } ContactInfoEntity contactInfoEntity = null; if (!string.IsNullOrEmpty(customerInfoEntity.CorpID)) { contactInfoEntity = _contactDal.Query <ContactInfoEntity>(n => n.PCid == customerInfoEntity.Cid).FirstOrDefault(); if (contactInfoEntity == null) { throw new Exception("当前客户信息异常,不能修改"); } } List <string> upArgsList = new List <string>(); List <string> upArgsList2 = new List <string>(); if (!string.IsNullOrEmpty(up.Email)) { int emailCount = _customerDal.Query <CustomerInfoEntity>( n => n.Email == up.Email && n.Cid != up.Cid && n.CorpID == customerInfoEntity.CorpID, true) .Count(); if (emailCount > 0) { throw new Exception("当前邮箱已经存在,不能修改"); } customerInfoEntity.Email = up.Email; upArgsList.Add("Email"); if (contactInfoEntity != null) { contactInfoEntity.Email = up.Email; upArgsList2.Add("Email"); } } if (!string.IsNullOrEmpty(up.Gender)) { List <string> genderList = new List <string>() { "M", "F" }; if (!genderList.Contains(up.Gender)) { throw new Exception("性别参数异常,请使用M/F"); } customerInfoEntity.Gender = up.Gender; upArgsList.Add("Gender"); if (contactInfoEntity != null) { contactInfoEntity.Gender = up.Gender; upArgsList2.Add("Gender"); } } if (!string.IsNullOrEmpty(up.RealName)) { customerInfoEntity.RealName = up.RealName; upArgsList.Add("RealName"); if (contactInfoEntity != null) { if (up.RealName.Contains("/")) { contactInfoEntity.Ename = up.RealName; upArgsList2.Add("Ename"); } else { contactInfoEntity.Cname = up.RealName; upArgsList2.Add("Cname"); } } } if (!string.IsNullOrEmpty(up.Mobile)) { //这里要判断手机号,userid是否唯一 int mobileCount = _customerDal.Query <CustomerInfoEntity>( n => n.Mobile == up.Mobile && n.Cid != up.Cid && n.CorpID == customerInfoEntity.CorpID, true) .Count(); if (mobileCount > 0) { throw new Exception("当前手机号存在,不能修改"); } int userIdCount = _customerDal.Query <CustomerInfoEntity>( n => n.UserID == up.Mobile && n.Cid != up.Cid && n.CorpID == customerInfoEntity.CorpID, true) .Count(); if (userIdCount > 0) { throw new Exception("当前UserId存在,不能修改"); } customerInfoEntity.Mobile = up.Mobile; customerInfoEntity.UserID = up.Mobile; upArgsList.Add("Mobile"); upArgsList.Add("UserID"); upArgsList2.Add("Mobile"); if (contactInfoEntity != null) { contactInfoEntity.Mobile = up.Mobile; upArgsList2.Add("Mobile"); } } _customerDal.Update(customerInfoEntity, upArgsList.ToArray()); if (contactInfoEntity != null) { _contactDal.Update(contactInfoEntity, upArgsList2.ToArray()); } return(true); }