コード例 #1
0
 public string deleteOutcome(SettingsViewModel newSetting)
 {
     try
     {
         if (newSetting.companyId > 0 && newSetting.userId > 0 && newSetting.data != null)
         {
             int count = db.company_outcome.Where(item => item.company_id == newSetting.companyId && item.status_id == 2).Count();
             if (count <= 1)
             {
                 return("false");
             }
             int             idSetting     = Int32.Parse(newSetting.data);
             company_outcome deleteOutcome = db.company_outcome.Where(item => item.id == idSetting).FirstOrDefault();
             if (deleteOutcome != null)
             {
                 deleteOutcome.status_id      = 1;
                 deleteOutcome.last_update_dt = DateTime.Now;
                 db.SaveChanges();
             }
         }
         return("true");
     }
     catch (Exception e)
     {
         return("false");
     }
 }
コード例 #2
0
        public string addOutcome(SettingsViewModel newSetting)
        {
            string id = null;

            try
            {
                if (newSetting.companyId > 0 && newSetting.userId > 0 && newSetting.data != null)
                {
                    company_outcome oldOutcome = db.company_outcome.Where(item => item.outcome_en.Trim().ToLower() == newSetting.data.Trim().ToLower()).FirstOrDefault();
                    if (oldOutcome == null)
                    {
                        oldOutcome = new company_outcome();
                    }
                    oldOutcome.status_id      = 2;
                    oldOutcome.company_id     = newSetting.companyId;
                    oldOutcome.outcome_en     = newSetting.data.Trim();
                    oldOutcome.outcome_fr     = newSetting.data.Trim();
                    oldOutcome.outcome_es     = newSetting.data.Trim();
                    oldOutcome.outcome_ru     = newSetting.data.Trim();
                    oldOutcome.outcome_ar     = newSetting.data.Trim();
                    oldOutcome.outcome_jp     = newSetting.data.Trim();
                    oldOutcome.last_update_dt = DateTime.Now;
                    db.company_outcome.Add(oldOutcome);
                    db.SaveChanges();
                    id = oldOutcome.id.ToString();
                }
            } catch (Exception e)
            {
                return("false");
            }
            return(id);
        }