public M_ProductOwner Owner_getCompanyDetails() { try { M_ProductOwner details = new M_ProductOwner(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_getOwnerCompanyResult> lst = datacontext._getOwnerCompany(); foreach (_getOwnerCompanyResult result in lst) { details.Organization = result.OrganizationName; details.PO_BOX = result.PostBox; details.Address1 = result.Address1; details.Address2 = result.Address2; details.Address3 = result.Address3; } } return(details); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public M_ProductOwner Owner_getContactPerson() { try { M_ProductOwner details = new M_ProductOwner(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_getOwnerContactResult> lst = datacontext._getOwnerContact(); foreach (_getOwnerContactResult result in lst) { details.Contact_Person = result.Name; details.Telephone_ = result.TelephoneNo; details.Fax_ = result.FaxNo; details.Email_ = result.Email; details.Web_ = result.WebAddress; } } return(details); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public JsonResult EditOwnerCompany(M_ProductOwner Model) { string result = "Error"; try { if (objSettings.Owner_ModifyCompany(Model)) { result = "Success"; } } catch (Exception Ex) { ErrorLog.LogError(Ex); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public bool Owner_ModifyCompany(M_ProductOwner odo) { try { using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; datacontext.Connection.Open(); datacontext._setUpdateOwnerCompany(odo.Organization, odo.PO_BOX, odo.Address1, odo.Address2, odo.Address3); datacontext.SubmitChanges(); } return(true); } catch (Exception ex) { ErrorLog.LogError(ex); return(false); } }
public bool Owner_ModifyContactPerson(M_ProductOwner odo) { try { using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; datacontext.Connection.Open(); datacontext._setUpdateOwnerContact(odo.Contact_Person, odo.Telephone_, odo.Email_, odo.Web_, odo.Fax_); datacontext.SubmitChanges(); } return(true); } catch (Exception ex) { ErrorLog.LogError(ex); return(false); } }