SqlCommand FaaliyetSatisEkle = new SqlCommand();
            FaaliyetSatisEkle.Connection = serkan;

            string sqlIns = "INSERT INTO DEFaaliyetSatisBilgileri (DETarih,DEFaaliyet,DEFaaliyetBirim,DEGP,DEGG,DEAP,DEAG,DEYP,DEYG,DEGY,DEAY,DEYY,DETesis,DEUser,DEUserTarih) VALUES (@DETarih,@DEFaaliyet,@DEFaaliyetBirim,@DEGP,@DEGG,@DEAP,@DEAG,@DEYP,@DEYG,@DEGY,@DEAY,@DEYY,@DETesis,@DEUser,@DEUserTarih)";

            serkan.Open();
            try
            {
                SqlCommand cmdIns = new SqlCommand(sqlIns, serkan);

                cmdIns.Parameters.Add("@DETarih", Convert.ToDateTime(datepicker.Text));
                cmdIns.Parameters.Add("@DEFaaliyet", DropDownList1.SelectedValue);
                cmdIns.Parameters.Add("@DEFaaliyetBirim", DropDownList2.SelectedValue);
                cmdIns.Parameters.Add("@DEGP", GunlukPlan);
                cmdIns.Parameters.Add("@DEGG", Convert.ToDecimal(TextBox2.Text));
                cmdIns.Parameters.Add("@DEAP", AylikPlan);
                cmdIns.Parameters.Add("@DEAG", AylikGerceklesen);
                cmdIns.Parameters.Add("@DEYP", YillikPlan);
                cmdIns.Parameters.Add("@DEYG", YillikGerceklesen);

                //Gerçekleşme Yüzdeleri
                //Gunluk
                if (GunlukPlan != 0 && TextBox2.Text != "0")
                {
                    cmdIns.Parameters.Add("@DEGY", (Convert.ToDecimal(TextBox2.Text) / GunlukPlan) * 100);
                }
                else
                {
                    cmdIns.Parameters.Add("@DEGY", Convert.ToDecimal(0));
                }
                //Aylık
                if (AylikPlan != 0 && AylikGerceklesen != 0)
                {
                    cmdIns.Parameters.Add("@DEAY", AylikGerceklesen / AylikPlan * 100);
                }
                else
                {
                    cmdIns.Parameters.Add("@DEAY", Convert.ToDecimal(0));
                }
                //Yıllık
                if (YillikPlan != 0 && YillikGerceklesen != 0)
                {
                    cmdIns.Parameters.Add("@DEYY", YillikGerceklesen / YillikPlan * 100);
                }
                else
                {
                    cmdIns.Parameters.Add("@DEYY", Convert.ToDecimal(0));
                }



                cmdIns.Parameters.Add("@DETesis", Label10.Text);
                cmdIns.Parameters.Add("@DEUser", Label11.Text);
                cmdIns.Parameters.Add("@DEUserTarih", Convert.ToDateTime(Label8.Text));

                cmdIns.ExecuteNonQuery();
                cmdIns.Dispose();
                cmdIns = null;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.ToString(), ex);
            }
            finally
            {
                serkan.Close();
            }