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