protected void btnsbmit_Click(object sender, EventArgs e)
        {
            try
            {
                usp_NotificationMessagesInsertProcedure_Result notificationRecord = null;
                usp_ComplaintsInsert_Result complaintResult = null;
                using (TransactionScope tx = new TransactionScope())
                {
                    using (Entities1 db = new Entities1())
                    {
                        ObjectResult <usp_ComplaintsInsert_Result> x =
                            db.usp_ComplaintsInsert(
                                Convert.ToInt16(drpapartmentnumber.Value),
                                Convert.ToInt16(drplvl1.Value),
                                Convert.ToInt16(drplvl2.Value),
                                Convert.ToInt16(drplvl3.SelectedItem.Value),
                                Convert.ToDateTime(txtfixdatetime.Text),
                                DateTime.Now,
                                null,
                                (int)ComplaintStatusEnum.Created,
                                null,
                                null,
                                User.Identity.GetUserId(),
                                memonotes.Text,
                                txtsubject.Text
                                , txtSearch.Text
                                , txtphone.Text
                                , txtcustomername.Text
                                , Convert.ToInt16(drpownertype.SelectedItem.Value)
                                , txtother.Text
                                );

                        complaintResult = x.FirstOrDefault();

                        btnprint.CommandArgument          = complaintResult.ID.ToString();
                        btnnew.Visible                    = true;
                        btnprint.Visible                  = true;
                        btnsumnit.Visible                 = false;
                        resultmessage.Attributes["class"] = "alert-success";
                        displayID.Value                   = "true";
                        txtID.Text           = "926/" + complaintResult.ID.ToString("0000000");
                        txtCreationDate.Text = complaintResult.CreateDateTime.ToString();
                        lbltxtresult.Text    = "تم اضافة البلاغ بنجاح";
                        string messageText = string.Format(Utilities.GetDescription(NotificationMessagesEnum.ComplaintCreationSMS), complaintResult.ID.ToString("9260000000"), complaintResult.CreateDateTime.Value.ToString("dd/MM/yyyy"));
                        ObjectResult <usp_NotificationMessagesInsertProcedure_Result> y =
                            db.usp_NotificationMessagesInsertProcedure(
                                "966" + complaintResult.Phone.TrimStart('0'),
                                complaintResult.ID.ToString("9260000000"),
                                messageText,
                                null,
                                1,
                                1,
                                DateTime.Now
                                );
                        notificationRecord = y.FirstOrDefault();
                    }
                    tx.Complete();
                }
                string message = string.Format(Utilities.GetDescription(NotificationMessagesEnum.ComplaintCreationSMS), complaintResult.ID.ToString("9260000000"), complaintResult.CreateDateTime.Value.ToString("dd/MM/yyyy"));
                Utilities.SendSMS(notificationRecord.MobileNumber, message, notificationRecord.ID);
            }
            catch (Exception exception)
            {
                Log.Error(exception.StackTrace);
                throw new Exception("خطاء اثناء تنفيذ العملية !");
            }
        }