public bool DeactivateContact(ContactPersonObject ConPerson) { SqlParameter[] params_ = new SqlParameter[] { new SqlParameter("@Id", ConPerson.Id), new SqlParameter("@Code", ConPerson.Code), new SqlParameter("@IsActive", ConPerson.IsActive), new SqlParameter("@table", "tblContactPerson"), new SqlParameter("@AddedBy", ConPerson.AddedBy), new SqlParameter("@IP", Helpers.CustomHelper.GetLocalIPAddress()), new SqlParameter("@MAC", Helpers.CustomHelper.GetMACAddress()), new SqlParameter("@DateAdded", ConPerson.DateAdded), new SqlParameter("@Module", "CONTACT PERSON"), }; return(Library.ConnectionString.returnCon.executeQuery("spDeactivateItem", params_, CommandType.StoredProcedure)); }
public bool SaveNewContactPerson(ContactPersonObject ConPerson) { SqlParameter[] params_ = new SqlParameter[] { new SqlParameter("@SupplierKey", ConPerson.SupplierKey), new SqlParameter("@FirstName", ConPerson.FirstName), new SqlParameter("@MiddleName", ConPerson.MiddleName), new SqlParameter("@LastName", ConPerson.LastName), new SqlParameter("@Email", ConPerson.Email), new SqlParameter("@ContactNumber", ConPerson.ContactNumber), new SqlParameter("@Department", ConPerson.Department), new SqlParameter("@IsActive", ConPerson.IsActive), new SqlParameter("@AddedBy", ConPerson.AddedBy), new SqlParameter("@DateAdded", ConPerson.DateAdded), new SqlParameter("@IP", Helpers.CustomHelper.GetLocalIPAddress()), new SqlParameter("@MAC", Helpers.CustomHelper.GetMACAddress()), }; return(Library.ConnectionString.returnCon.executeQuery("spAddContactPerson", params_, CommandType.StoredProcedure)); }