public static List<ExpertDataModel> Filter(ExpertDataModel model) { List<ExpertDataModel> items = new List<ExpertDataModel>(); MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[Plenum.Data.Constants.AppSetting]); string FilterSelect = "" + " SELECT ID, Name, LastName, Mobile, Bio " + " FROM expert " + " WHERE Mobile LIKE '%" + model.Mobile.Replace("'","").Replace("-","") + "%'"; MySqlDataAdapter adapter = new MySqlDataAdapter(FilterSelect, connection); adapter.SelectCommand.CommandType = CommandType.Text; DataTable results = new DataTable(); adapter.Fill(results); foreach (DataRow row in results.Rows) { ExpertDataModel item = MapItem(row); items.Add(item); } return items; }
public static int Create(ExpertDataModel item) { MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[Plenum.Data.Constants.AppSetting]); MySqlDataAdapter adapter = new MySqlDataAdapter("Core_CreateExpert", connection); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; MySqlParameter paramID = new MySqlParameter("pID", item.ID); paramID.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramID); MySqlParameter paramName = new MySqlParameter("pName", item.Name); paramName.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramName); MySqlParameter paramLastName = new MySqlParameter("pLastName", item.LastName); paramLastName.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramLastName); MySqlParameter paramMobile = new MySqlParameter("pMobile", item.Mobile); paramMobile.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramMobile); MySqlParameter paramBio = new MySqlParameter("pBio", item.Bio); paramBio.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramBio); DataTable results = new DataTable(); adapter.Fill(results); if(results.Rows.Count > 0) { return Convert.ToInt32(results.Rows[0]["ID"]); }else{ throw new Exception("Error creating Expert"); } }
public virtual int CreateOrUpdate(ExpertDataModel item) { if (item.ID > 0) { ExpertDAL.Update(item); } else { item.ID = ExpertDAL.Create(item); } return Convert.ToInt32(item.ID); }
public ActionResult Edit(ExpertDataModel item) { ExpertBO.GetInstance().CreateOrUpdate(item); if (Session["ExpertParentID"] != null) { return RedirectToAction("Index", new { id = Convert.ToInt32(Session["ExpertParentID"]) }); } else { return RedirectToAction("Index"); } }
public override int CreateOrUpdate(ExpertDataModel item) { item.ID = base.CreateOrUpdate(item); //Skills sent? if(item.Skills != null && item.Skills.Count > 0){ //Delete Previous Skills ExpertDAL.DeleteExpertAllSkills(Convert.ToInt32(item.ID)); foreach (var skillItem in item.Skills) { AddSkill(Convert.ToInt32(skillItem.ID), Convert.ToInt32(item.ID), Convert.ToInt32(item.ID)); } } return Convert.ToInt32(item.ID); }
// // GET: /ManageRole/ public ActionResult Index(ExpertDataModel model) { List<ExpertDataModel> list; if (model != null && !String.IsNullOrEmpty(model.Mobile)) { list = ExpertBO.GetInstance().Filter(model); } else { if (model.ID != null && model.ID > 0) { list = ExpertBO.GetInstance().GetAll(Convert.ToInt32(model.ID)); } else { list = ExpertBO.GetInstance().GetAll(); } } return View(list); }
public JsonResult GetByMobile(ExpertDataModel expert, int fromExpertID) { return Json(ExpertBO.GetInstance().GetByMobile(expert, fromExpertID, true), JsonRequestBehavior.AllowGet); }
public JsonResult Update(ExpertDataModel expert) { ExpertBO.GetInstance().CreateOrUpdate(expert); return Json(new { success = true }, JsonRequestBehavior.AllowGet); }
public void SetExpertContacts(ExpertDataModel expert, List<ExpertDataModel> contacts) { ExpertDAL.DeleteContacts(Convert.ToInt32(expert.ID)); foreach (var item in contacts) { try { //Remove + and " " chars item.Mobile = FormatMobileNumber(item.Mobile); //Create if it does not exist ExpertDataModel model = ExpertDAL.GetByMobile(item.Mobile); if (model == null) { model = item; model.ID = CreateOrUpdate(item); } ExpertDAL.AddContact(Convert.ToInt32(expert.ID), Convert.ToInt32(model.ID)); } catch (Exception ex) { System.IO.File.AppendAllText(@"C:\Plenum\Laboru\WebServices\Logs\Errors.txt", "\r\n" + DateTime.Now.ToString() + item.Name + " " + item.Mobile + " " + ex.Message); } } }
public ExpertDataModel Register(ExpertDataModel item) { //Remove + and " " chars item.Mobile = FormatMobileNumber(item.Mobile); ExpertDataModel model = ExpertDAL.GetByMobile(item.Mobile); if (model != null) { //Set ID so info is updated (Name) item.ID = model.ID; item.DateCreated = DateTime.Now; } item.ID = CreateOrUpdate(item); return item; }
public ExpertDataModel GetByMobile(ExpertDataModel item,int fromExpertID, bool useCache = false) { item.Mobile = FormatMobileNumber(item.Mobile); //Create if it does not exist ExpertDataModel model = ExpertDAL.GetByMobile(item.Mobile); if (model == null) { model = item; model.ID = CreateOrUpdate(item); ExpertDAL.AddContact(fromExpertID, Convert.ToInt32(model.ID)); } else { //Add Contact as Friend if not done yet IList<ExpertSearchResultDataModel> contact = ExpertDAL.GetExpertContact(Convert.ToInt32(model.ID), fromExpertID); if (contact == null || contact.Count == 0) { ExpertDAL.AddContact(fromExpertID, Convert.ToInt32(model.ID)); } } model.Skills = ExpertDAL.GetSkills(Convert.ToInt32(model.ID), fromExpertID); return model; }
public virtual List<ExpertDataModel> Filter(ExpertDataModel model) { return ExpertDAL.Filter(model); }
public static void Update(ExpertDataModel item) { MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[Plenum.Data.Constants.AppSetting]); MySqlDataAdapter adapter = new MySqlDataAdapter("Core_UpdateExpert", connection); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; MySqlParameter paramID = new MySqlParameter("pID", item.ID); paramID.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramID); MySqlParameter paramName = new MySqlParameter("pName", item.Name); paramName.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramName); MySqlParameter paramLastName = new MySqlParameter("pLastName", item.LastName); paramLastName.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramLastName); MySqlParameter paramMobile = new MySqlParameter("pMobile", item.Mobile); paramMobile.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramMobile); MySqlParameter paramBio = new MySqlParameter("pBio", item.Bio); paramBio.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramBio); DataTable results = new DataTable(); adapter.Fill(results); }
public static ExpertDataModel MapItem(DataRow row) { ExpertDataModel item = null; item = new ExpertDataModel(); if (row["ID"].GetType() != typeof(DBNull)) { item.ID = Convert.ToInt32(row["ID"]); } if (row["Name"].GetType() != typeof(DBNull)) { item.Name = Convert.ToString(row["Name"]); } if (row["LastName"].GetType() != typeof(DBNull)) { item.LastName = Convert.ToString(row["LastName"]); } if (row["Mobile"].GetType() != typeof(DBNull)) { item.Mobile = Convert.ToString(row["Mobile"]); } if (row["Bio"].GetType() != typeof(DBNull)) { item.Bio = Convert.ToString(row["Bio"]); } if (row.Table.Columns.Contains("DateCreated") && row["DateCreated"].GetType() != typeof(DBNull)) { item.DateCreated = Convert.ToDateTime(row["DateCreated"]); } return item; }