Esempio n. 1
0
        private void MListView_ItemClick(object sender, AdapterView.ItemClickEventArgs e)
        {
            Android.App.AlertDialog.Builder alert = new Android.App.AlertDialog.Builder(this);

            List <KhatawaniTapshilNaveJama> ResultNew;

            try
            {
                var db = new SQLiteConnection(filename);
                GirviNO = Result.ElementAt(e.Position);

                String str  = GirviNO.receipt_no.ToString();
                var    data = db.Query <KhatawaniTapshilNaveJama>("SELECT CM.khatawani_No, GM.GirviRecordNo, GIM.metal_type, GIM.item_type, GIM.Total_Quantity, GIM.gross_wt, GIM.net_wt, GIM.fine_wt, GM.Amount, GM.Date_of_deposit, GM.forwardstatus, GM.Forwarded_to, GM.Date_of_Forward, GM.forwardamount, CM.FullName, CM.Contact_No, CM.Address,GM.Status FROM customer_master AS CM INNER JOIN GirviMaster AS GM ON CM.khatawani_No = GM.khatawani_No INNER JOIN GirviItemMaster AS GIM ON GM.GirviRecordNo = GIM.GirviNo where GM.Status = 'unchange' and GM.receipt_no = '" + str + "'").ToList();

                ResultNew = data;
                item      = ResultNew.ElementAt(0);
            }
            catch { }

            Message = (item.metal_type + " " + item.item_type + " (" + item.Total_Quantity + "nos.) " + "\n" +
                       "ग्रॉस वेट : " + item.gross_wt + " gm " + "\n" +
                       "नेट वेट : " + item.net_wt + " gm " + "\n" +
                       "फाईन वेट : " + item.fine_wt + " gm ") == null ? "" : (item.metal_type + " " + item.item_type + " (" + item.Total_Quantity + "nos.) " + "\n" +
                                                                              "ग्रॉस वेट : " + item.gross_wt + " gm " + "\n" +
                                                                              "नेट वेट : " + item.net_wt + " gm " + "\n" +
                                                                              "फाईन वेट : " + item.fine_wt + " gm ").ToString();

            if (item.forwardstatus == "Forward")
            {
                ForworDetails = ("Forward To : " + item.Forwarded_to + "\n" +
                                 "Forward Date : " + item.Date_of_Forward + "\n" +
                                 "Forward Amount : " + item.forwardamount) == null ? "" : ("Forward To : " + item.Forwarded_to + "\n" +
                                                                                           "Forward Date : " + item.Date_of_Forward + "\n" +
                                                                                           "Forward Amount : " + item.forwardamount).ToString();

                FullMessage = Message + "\n" +
                              "\n" +
                              "\n" +
                              "\n" +
                              "***Girvi Forward Details***" + "\n" +
                              "\n" +
                              ForworDetails;
            }

            else
            {
                FullMessage = Message;
            }
            alert.SetTitle(Html.FromHtml("<font color='#EC407A'>गिरवी डीटेल्स</font>"));
            alert.SetMessage(FullMessage);
            alert.SetPositiveButton("OK", (senderAlert, args) =>
            {
                return;
            });

            Dialog dialog = alert.Create();

            dialog.Show();
        }
        private void MListView_ItemClick(object sender, AdapterView.ItemClickEventArgs e)
        {
            List <KhatawaniTapshilNaveJama> ResultNew;

            try
            {
                var db = new SQLiteConnection(dbPath);
                GirviNO = Result.ElementAt(e.Position);

                string strGirviNO = GirviNO.receipt_no.ToString();
                var    data       = db.Query <KhatawaniTapshilNaveJama>("SELECT CM.khatawani_No, GM.GirviRecordNo, GIM.metal_type, GIM.item_type, GIM.Total_Quantity, GIM.gross_wt, GIM.net_wt, GIM.fine_wt, GM.Amount, GM.Date_of_deposit, CM.FullName, CM.Contact_No, CM.Address,GM.Status FROM customer_master AS CM INNER JOIN GirviMaster AS GM ON CM.khatawani_No = GM.khatawani_No INNER JOIN GirviItemMaster AS GIM ON GM.GirviRecordNo = GIM.GirviNo where GM.receipt_no = '" + strGirviNO.Trim() + "'").ToList();

                ResultNew = data;
                item      = ResultNew.ElementAt(0);

                try
                {
                    Tday = DateTime.Now.ToString("dd/MM/yyyy");
                    if (GirviNO.Date_of_deposit.ToString() != "" && Tday != "")
                    {
                        if (GirviNO.Status.ToString().Trim() == "Release")
                        {
                            EkunDiwas = (((Convert.ToDateTime(GirviNO.withdraw_release_date.ToString()) - Convert.ToDateTime(GirviNO.Date_of_deposit.ToString())).TotalDays) + _ObjSettingMobileAppModel.CalculationDaysDifference).ToString();
                        }
                        else
                        {
                            EkunDiwas = (((Convert.ToDateTime(Tday) - Convert.ToDateTime(GirviNO.Date_of_deposit.ToString())).TotalDays) + _ObjSettingMobileAppModel.CalculationDaysDifference).ToString();
                        }
                    }
                }
                catch { }

                Interset    = InterestAmount(GirviNO.Amount.ToString(), GirviNO.interset_rate.ToString(), EkunDiwas).ToString();
                TotalAmount = (Convert.ToDouble(Interset) + Convert.ToDouble(GirviNO.Amount.ToString())).ToString();


                Message = (item.metal_type + " " + item.item_type + " (" + item.Total_Quantity + "nos.) " + "\n" +
                           "ग्रॉस वेट : " + item.gross_wt + " gm " + "\n" +
                           "नेट वेट : " + item.net_wt + " gm " + "\n" +
                           "फाईन वेट : " + item.fine_wt + " gm ") == null ? "" : (item.metal_type + " " + item.item_type + " (" + item.Total_Quantity + "nos.) " + "\n" +
                                                                                  "ग्रॉस वेट : " + item.gross_wt + " gm " + "\n" +
                                                                                  "नेट वेट : " + item.net_wt + " gm " + "\n" +
                                                                                  "फाईन वेट : " + item.fine_wt + " gm ").ToString();

                Calculation = ("गिरवी रक्कम : " + GirviNO.Amount.ToString() + "\n" +
                               "व्याज टक्के : " + GirviNO.interset_rate.ToString() + "\n" +
                               "एकूण दिवस : " + EkunDiwas + "\n" +
                               "व्याज रक्कम : " + Interset + "\n" +
                               "एकूण भरावयाची रक्कम : " + TotalAmount).ToString();

                MessageFull = Message + "\n" +
                              "\n" +
                              "\n" +
                              "\n" +
                              Calculation;
            }
            catch
            {
            }
            Android.App.AlertDialog.Builder alert = new Android.App.AlertDialog.Builder(this);
            if (GirviNO.Status.ToString().Trim() == "Release")
            {
                alert.SetTitle(Html.FromHtml("<font color='#EC407A'>गिरवी रीलीज डीटेल्स</font>"));
            }
            else
            {
                alert.SetTitle(Html.FromHtml("<font color='#EC407A'>गिरवी डीटेल्स</font>"));
            }
            // alert.SetTitle("Confirm Start Audit");
            alert.SetMessage(MessageFull);
            alert.SetPositiveButton("OK", (senderAlert, args) =>
            {
                return;
            });

            Dialog dialog = alert.Create();

            dialog.Show();
        }