public ActionResult GetlistUser(string PKContactID) { using (var dbConn = Helpers.OrmliteConnection.openConn()) { if (PKContactID != null && PKContactID != "") { var data = dbConn.Select <ERPAPD_Contacts>(s => s.PKContactID == int.Parse(PKContactID)).FirstOrDefault(); return(Json(new { data = data, success = true })); } else { var data = new ERPAPD_Contacts(); return(Json(new { data = data, success = true })); } } }
public ActionResult GetContactByCusID(string Id) { using (var dbConn = ERPAPD.Helpers.OrmliteConnection.openConn()) { if (Id != null && Id != "") { var data = dbConn.Select <ERPAPD_Contacts>("Select PKContactID, Name FROM ERPAPD_Contacts WHERE CustomerID ={0}", Id); return(Json(new { data = data, success = true }, JsonRequestBehavior.AllowGet)); } else { var data = new ERPAPD_Contacts(); return(Json(new { data = data, success = true }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult CRMContactList_Update(ERPAPD_Contacts request) { using (IDbConnection dbConn = ERPAPD.Helpers.OrmliteConnection.openConn()) { try { if (request.PKContactID != 0) { var contacts = dbConn.FirstOrDefault <ERPAPD_Contacts>("PKContactID={0}", request.PKContactID); contacts.FirstName = !string.IsNullOrEmpty(request.FirstName) ? request.FirstName.Trim() : ""; contacts.MiddleName = !string.IsNullOrEmpty(request.MiddleName) ? request.MiddleName.Trim() : ""; contacts.LastName = !string.IsNullOrEmpty(request.LastName) ? request.LastName.Trim() : ""; contacts.Name = contacts.FirstName + " " + contacts.MiddleName + " " + contacts.LastName; contacts.DayOfBirth = request.DayOfBirth != 0 ? request.DayOfBirth : 1; contacts.MonthOfBirth = request.MonthOfBirth != 0 ? request.MonthOfBirth : 1; contacts.YearOfBirth = request.YearOfBirth != 0 ? request.YearOfBirth : 1900; contacts.Birthday = DateTime.Parse(contacts.YearOfBirth + "-" + contacts.MonthOfBirth + "-" + contacts.DayOfBirth); contacts.Category = !string.IsNullOrEmpty(request.Category) ? request.Category : ""; contacts.Mobile = !string.IsNullOrEmpty(request.Mobile) ? request.Mobile.Trim() : ""; contacts.TelephoneHome = !string.IsNullOrEmpty(request.TelephoneHome) ? request.TelephoneHome.Trim() : ""; contacts.TelephoneOffice = !string.IsNullOrEmpty(request.TelephoneOffice) ? request.TelephoneOffice.Trim() : ""; contacts.Email = !string.IsNullOrEmpty(request.Email) ? request.Email.Trim() : ""; contacts.Notes = !string.IsNullOrEmpty(request.Notes) ? request.Notes.Trim() : ""; contacts.Title = !string.IsNullOrEmpty(request.Title) ? request.Title.Trim() : ""; contacts.FKCustomer = request.FKCustomer; contacts.Decided = request.Decided; contacts.Sex = request.Sex; contacts.Decided = request.Decided; contacts.Status = request.Status; contacts.RowUpdatedAt = DateTime.Now; contacts.RowUpdatedUser = currentUser.UserName; contacts.IsNew = 1; dbConn.Update(contacts); } else { ModelState.AddModelError("error", ""); return(Json(new { success = false })); } } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } } return(Json(new { success = true })); }
public ActionResult getSubCategory(string ParentID) { using (var dbConn = Helpers.OrmliteConnection.openConn()) { if (ParentID != null && ParentID != "") { var data = dbConn.Select <ERPAPD_Contacts>(@"SELECT ID,[HierarchyID],Value,ParentID,[Level] FROM CRM_CategoryHierarchy WHERE ParentID='" + int.Parse(ParentID) + "'"); return(Json(new { data = data, success = true })); } else { var data = new ERPAPD_Contacts(); return(Json(new { data = data, success = true })); } } }