예제 #1
0
        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);
            }
        }
예제 #2
0
        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);
            }
        }
예제 #3
0
        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));
        }
예제 #4
0
 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);
     }
 }
예제 #5
0
 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);
     }
 }