public static string Insert(clsContact data, out Int32 newID) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); newID = -1; try { tblContact oNewRow = new tblContact() { idContactType = data.idContactType, idRequest = data.idRequest, Name = data.Name, Title = data.Title, Phone = data.Phone, Email = data.Email, CreatedBy = data.CreatedBy, CreatedOn = data.CreatedOn }; puroTouchContext.GetTable <tblContact>().InsertOnSubmit(oNewRow); puroTouchContext.SubmitChanges(); newID = oNewRow.idContact; data.idRequest = newID; } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public static string Update(clsContact data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { var contact = puroTouchContext.GetTable <tblContact>().Where(f => f.idContact == data.idContact).FirstOrDefault(); if (contact != null) { contact.Name = data.Name; contact.Title = data.Title; contact.Phone = data.Phone; contact.Email = data.Email; contact.UpdatedBy = data.UpdatedBy; contact.UpdatedOn = data.UpdatedOn; } puroTouchContext.SubmitChanges(); } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
//update contact by contact ID, stored procedure :sp_update_contact_U public static bool DBUpdateContact(clsContact Contact) { bool result = true; SqlCommand objCommand = new SqlCommand("sp_update_contact_U"); objCommand.CommandType = CommandType.StoredProcedure; SqlParameter prmContactID = new SqlParameter("@ContactID", SqlDbType.BigInt); prmContactID.Value = Contact.ContactId; objCommand.Parameters.Add(prmContactID); SqlParameter prmFirstName = new SqlParameter("@FirstName", SqlDbType.VarChar); prmFirstName.Value = Contact.FirstName; objCommand.Parameters.Add(prmFirstName); SqlParameter prmLastName = new SqlParameter("@LastName", SqlDbType.VarChar); prmLastName.Value = Contact.LastName; objCommand.Parameters.Add(prmLastName); SqlParameter prmEmailID = new SqlParameter("@EmailID", SqlDbType.VarChar); prmEmailID.Value = Contact.EmailID; objCommand.Parameters.Add(prmEmailID); SqlParameter prmMobileNumber = new SqlParameter("@MobileNumber", SqlDbType.VarChar); prmMobileNumber.Value = Contact.MobileNumber; objCommand.Parameters.Add(prmMobileNumber); SqlParameter prmStatus = new SqlParameter("@Status", SqlDbType.Bit); prmStatus.Value = Contact.Status; objCommand.Parameters.Add(prmStatus); if (DBInteraction.ExecuteSQL(ref objCommand)) { result = true; } else { result = false; } if (objCommand != null) { objCommand.Dispose(); } return(result); }
public bool addContacts([FromBody] dynamic contects) { clsContact objContact = JsonConvert.DeserializeObject(contects, typeof(clsContact)); return(DBContact.DBAddContact(objContact)); }
public bool updateContacts([FromBody] dynamic stringContent) { clsContact objContact = JsonConvert.DeserializeObject(stringContent, typeof(clsContact)); return(DBContact.DBUpdateContact(objContact)); }