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);
}
