示例#1
0
        /// <summary>
        /// this is function to make Description List from database
        /// </summary>
        /// <returns>list of DescriptionDetail</returns>
        public List <DescriptionDetail> makeDescriptionList()
        {
            List <DescriptionDetail> descList = new List <DescriptionDetail>();
            int     retVal = 0;
            DataSet ds     = Sqlite.ExecuteSQLStatement(Query.getDescData(), ref retVal);

            for (int i = 0; i < retVal; i++)
            {
                DescriptionDetail descTemp = new DescriptionDetail();
                //Description ID
                if (int.TryParse(ds.Tables[0].Rows[i].ItemArray[0].ToString(), out int id))
                {
                    descTemp.DescId = id;
                }
                //description name
                descTemp.name = ds.Tables[0].Rows[i].ItemArray[1].ToString();

                //source id
                if (int.TryParse(ds.Tables[0].Rows[i].ItemArray[2].ToString(), out int sourceId))
                {
                    descTemp.sourceId = sourceId;
                }
                //description
                descTemp.description = ds.Tables[0].Rows[i].ItemArray[3].ToString();
                //create date
                descTemp.sDate = ds.Tables[0].Rows[i].ItemArray[4].ToString();
                //add to list
                descList.Add(descTemp);
            }

            return(descList);
        }
示例#2
0
        public string insertDesc(DescriptionDetail descDetail)
        {
            //string dt = DateTime.Parse(descDetail.date).ToString("yyyy-MM-dd");
            //descDetail.date = descDetail.date.ToString("yyyy-MM-dd");
            return("INSERT INTO Assignment (Name,Source_id, Description,CreationDate) " +
                   "VALUES ('" + descDetail.name + "', " + descDetail.sourceId + ", '" + descDetail.description + "', '" + descDetail.sDate + "');");

            //INSERT INTO "main"."Assignment"("Name", "Source_id", "Description", "CreationDate") VALUES('asdfsadf', 2, 'asdfsadfsdf', '2017-8-1')
        }
示例#3
0
        private void btnSave_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (tbDesc.Text != "" && DescDate != null)
                {
                    DescriptionDetail desc = new DescriptionDetail();
                    desc.date = DescDate.SelectedDate.Value;
                    if (desc.date.Month < 10)
                    {
                        desc.sDate = desc.date.Year.ToString() + "-0" + desc.date.Month.ToString();
                    }
                    else
                    {
                        desc.sDate = desc.date.Year.ToString() + "-" + desc.date.Month.ToString();
                    }
                    if (desc.date.Day < 10)
                    {
                        desc.sDate += "-0" + desc.date.Day.ToString();
                    }
                    else
                    {
                        desc.sDate += "-" + desc.date.Day.ToString();
                    }

                    desc.description = tbDesc.Text;

                    desc.name = tbName.Text;

                    if (Int32.TryParse(tbSourceId.Text, out int sourId))
                    {
                        desc.sourceId = sourId;
                    }

                    Sqlite.ExecuteNonQuery(Query.insertDesc(desc));
                    descDetail = desc;


                    this.Hide();
                }
            }
            catch (Exception ex)
            {
                //handle error method
                HandleError(MethodInfo.GetCurrentMethod().DeclaringType.Name,
                            MethodInfo.GetCurrentMethod().Name, ex.Message);
            }
        }
示例#4
0
 public void addDescList(DescriptionDetail desc)
 {
     descList.Add(desc);
 }
示例#5
0
 public string updateDesc(DescriptionDetail detail)
 {
     return("UPDATE Assignment SET Name = '" + detail.name + "', Source_id = " + detail.sourceId + ", Description = '" + detail.description + "',CreationDate= '" + detail.sDate + "' WHERE(_id =" + detail.DescId + ");");
 }