コード例 #1
0
ファイル: Program.cs プロジェクト: jajossy/payslip-sender
 public static void updateDB(string ippis, string message)
 {
     using (var context2 = new NominalDataEntities())
     {
         //var result = context2.StaffDatas.SingleOrDefault(b => b.IppisNo == ippis);
         var result = context2.StaffDatas.FirstOrDefault(b => b.IppisNo == ippis);
         if (result != null)
         {
             result.Comment = message;
             context2.SaveChanges();
         }
     }
 }
コード例 #2
0
ファイル: Program.cs プロジェクト: jajossy/payslip-sender
        private static string dbaseAccess(string ippis, string token)
        //public static void dbaseAccess()
        {
            //IEnumerable<StaffData> query = DBAccess.StaffDatas.Select();
            string finalValue;

            using (var context = new NominalDataEntities())
            {
                var stdQuery = (from d in context.StaffDatas
                                select new
                {
                    Id = d.Id,
                    PinNo = d.PinNo,
                    IppisNo = d.IppisNo,
                    Fullname = d.Fullname,
                    EmailAddress = d.EmailAddress,
                    Department = d.Department,
                    Comment = d.Comment
                }).Where(x => x.IppisNo == ippis).FirstOrDefault();

                /*foreach (var q in stdQuery)
                 * {
                 *  Console.WriteLine("PinNo : " + q.PinNo + ", IppisNo : " + q.IppisNo + ", Department : " + q.Department);
                 * }*/


                //Console.ReadLine();

                if (stdQuery != null && token == "email")
                {
                    finalValue = stdQuery.EmailAddress;
                }
                else if (stdQuery != null && token == "name")
                {
                    finalValue = stdQuery.Fullname;
                }
                else
                {
                    finalValue = null;
                }
            }

            return(finalValue);
        }