protected void FvAssignOfficer_ItemCommand(object sender, FormViewCommandEventArgs e)
 {
     if (e.CommandName == "AssignOfficer")
     {
         Complain cmp = new Complain();
         DropDownList ddlOffice = (DropDownList)FvAssignOfficer.FindControl("ddlOfficeName");
         DropDownList ddlDesig = (DropDownList)FvAssignOfficer.FindControl("ddlDesigination");
         string[] officer = WorkflowSupport.GetUserAtOfficeRole(new Guid(ddlOffice.SelectedValue), new Guid(ddlDesig.SelectedValue));
         cmp.AssignEnquiryOfficer(officer[0], new Guid(fldComplainId.Value));
         Response.Redirect("~/");
     }
 }
        public IHttpActionResult DeleteComplain(int id)
        {
            Complain complain = db.Complains.Find(id);

            if (complain == null)
            {
                return(NotFound());
            }

            db.Complains.Remove(complain);
            db.SaveChanges();

            return(Ok(complain));
        }
Esempio n. 3
0
        private void LoadBtn_Click(object sender, EventArgs e)
        {
            string   s = this.cidTB.Text;
            Complain c = cr.Getcomplain(s);

            if (c == null)
            {
                MessageBox.Show("Invalid ID");
            }
            else
            {
                cbodyTB.Text = c.Cbody;
            }
        }
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Complain complain = db.Complains.Find(id);

            if (complain == null)
            {
                return(HttpNotFound());
            }
            return(View(complain));
        }
        protected void complainGridView_RowUpdating1(object sender, GridViewUpdateEventArgs e)
        {
            int      r  = e.RowIndex;
            Complain bd = new Complain();

            Label t1 = (Label)complainGridView.Rows[r].FindControl("Label1");

            bd = aManager.DropGri(t1.Text);
            int          t3 = bd.HostelNo;
            string       t5 = bd.Category, t8 = bd.Priority;
            TextBox      t2  = (TextBox)complainGridView.Rows[r].FindControl("pNameTextBox");
            DropDownList ch1 = (DropDownList)complainGridView.Rows[r].FindControl("hostelDropDownList");

            if (ch1.SelectedIndex > 0)
            {
                t3 = Convert.ToInt32(ch1.SelectedItem.ToString());
            }
            TextBox      t4   = (TextBox)complainGridView.Rows[r].FindControl("roomTextBox");
            DropDownList cha1 = (DropDownList)complainGridView.Rows[r].FindControl("cateDropDownList");

            if (cha1.SelectedIndex > 0)
            {
                t5 = cha1.SelectedItem.ToString();
            }

            TextBox      t6 = (TextBox)complainGridView.Rows[r].FindControl("subjectTextBox");
            TextBox      t7 = (TextBox)complainGridView.Rows[r].FindControl("summaryTextBox");
            DropDownList c1 = (DropDownList)complainGridView.Rows[r].FindControl("PrioDrop");

            if (c1.SelectedIndex > 0)
            {
                t8 = c1.SelectedItem.ToString();
            }
            TextBox t9   = (TextBox)complainGridView.Rows[r].FindControl("contactTextBox");
            bool    flag = aManager.Update(t1.Text, t2.Text, t3, int.Parse(t4.Text), t5, t6.Text, t7.Text, t8, t9.Text);

            if (flag == true)

            {
                msgLabel.Text = "Update Successfully";
                complainGridView.DataSource = aManager.ShowAllComplain();
                complainGridView.EditIndex  = -1;
                complainGridView.DataBind();
            }
            else
            {
                msgLabel.Text = "Not Updated, Sorry!!!!!";
            }
        }
Esempio n. 6
0
        private DataTable GetGridData(int ProvID)
        {
            DataTable dt = new DataTable();

            try
            {
                Complain _objList = new Complain();
                string   userRight;
                userRight = Session["Role"].ToString();
                if (userRight == "Administrator")
                {
                    if (ProvID == 35 || ProvID == 0)
                    {
                        dt = _objList.getComplainList();
                    }

                    else
                    {
                        dt = _objList.getComplainListByProv(ProvID);
                    }
                }
                else
                {
                    if (ProvID == 35 || ProvID == 0)
                    {
                        dt = _objList.getComplainListbyUser(UserId);
                    }

                    else
                    {
                        dt = _objList.getComplainListByUser_rov(ProvID, UserId);
                    }
                }
                if (dt.Rows.Count == 0)
                {
                    lblNoDataMsg.Text = ECCCommon.objCached.NoRecordExists;
                }
                else
                {
                    lblNoDataMsg.Text = "";
                }
                _gvList.DataSource = dt;
                _gvList.DataBind();
            }
            finally
            {
            }
            return(dt);
        }
        public Dictionary <string, string> LoadDictionary(string filepath)
        {
            ValidateLoad(filepath);
            var readDict = new Dictionary <string, string>();
            var allLines = File.ReadAllText(filepath).Split("\r\n");

            for (int i = 0; i < allLines.Length; i++)
            {
                var lineValues = allLines[i].Split('\t');
                Complain.If(lineValues.Count() != 2, Complaints.MUST_BE_TWO_VALUES_PER_LINE + allLines[i]);
                readDict.Add(lineValues[0], lineValues[1]);
            }
            _dictionary = readDict;
            return(_dictionary);
        }
        public ActionResult Create(Complain complain)
        {
            if (ModelState.IsValid)
            {
                db.Complains.Add(complain);
                db.SaveChanges();
                return(RedirectToAction("ThankYou"));
            }
            //ViewBag.ComplainedBy = new SelectList(db.AspNetUsers, "Id", "Email");

            //ViewBag.ComplainedAbout = new SelectList(db.AspNetUsers, "Id", "Email", complain.ComplainedAbout);
            //ViewBag.ActionId = new SelectList(db.ComplainActions, "Id", "Action", complain.ActionId);

            return(View(complain));
        }
        public ActionResult Solve(Complain complain)
        {
            ComplainRegistrationModel cm = new ComplainRegistrationModel();
            Complain temp = new Complain();

            temp = db.ComplainDetails.Find(complain.ID);


            cm                 = db.Complains.Find(temp.ComplainRegistratationID);
            cm.Status          = "Solved";
            db.Entry(cm).State = EntityState.Modified;
            db.SaveChanges();

            return(RedirectToAction("Index", "ComplainRegistrationModels"));
        }
        public ActionResult Edit(Complain c)
        {
            if (Session["citizenID"] != null)
            {
                var old = db.Complains.Find(c.Id);
                old.GovernementId     = c.GovernementId;
                old.CitizenId         = (int)Session["citizenID"];
                old.ComplainText      = c.ComplainText;
                old.CitizenNationalId = c.CitizenNationalId;
                db.SaveChanges();

                return(RedirectToAction("IndexUser"));
            }
            return(RedirectToAction("errorPage", "home"));
        }
Esempio n. 11
0
        public ActionResult Create_Post()
        {
            Complain complain = new Complain();

            TryUpdateModel(complain);

            if (ModelState.IsValid)
            {
                BL_Complains bL_Complains = new BL_Complains();
                bL_Complains.InsertComplain(complain);

                RedirectToAction("AllComplains");
            }
            return(View());
        }
Esempio n. 12
0
        // GET: Complains/Create
        public IActionResult Create()
        {
            Complain complainModel = new Complain();
            //ViewData["UserId"] = new SelectList(_context.userAccounts, "UserId", "UserId");

            int paId = 0;

            int.TryParse(HttpContext.Session.GetInt32("UserId").ToString(), out paId);

            ViewData["UserId"] = complainModel.UserId = paId;
            string status = "Pending";

            complainModel.Status = status;

            return(View(complainModel));
        }
Esempio n. 13
0
        protected void imgDelete_Command(object sender, CommandEventArgs e)
        {
            ECCMS _objDb = new ECCMS();

            try
            {
                Complain _objRow = new Complain();
                _objRow._Complain_DeleteLogically(e.CommandArgument.ToString());

                showData();
            }
            finally
            {
                _objDb.Dispose();
            }
        }
Esempio n. 14
0
        public bool Insertcomplain(Complain c)
        {
            string query = "INSERT into Complains VALUES ('" + c.CId + "', '" + c.Csub + "', '" + c.Cbody + "','" + c.CuserId + "')";

            try
            {
                dcc.ConnectWithDB();
                int n = dcc.ExecuteSQL(query);
                dcc.CloseConnection();
                return(true);
            }
            catch (Exception exp)
            {
                return(false);
            }
        }
        // GET: ComplainsTest/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Complain complain = db.Complains.Find(id);

            if (complain == null)
            {
                return(HttpNotFound());
            }
            ViewBag.ComplainedAbout = new SelectList(db.AspNetUsers, "Id", "Email", complain.ComplainedAbout);
            ViewBag.ActionId        = new SelectList(db.ComplainActions, "Id", "Action", complain.ActionId);
            return(View(complain));
        }
Esempio n. 16
0
        public async Task <String> registerComplain([FromBody] Complain Complain)

        {
            var ComplainData = await context.retrieveByComplainId(Complain.complaintId);


            ComplainData = JsonConvert.SerializeObject(ComplainData);
            if (ComplainData.ToString() == "[]")
            {
                await context.insert(Complain);

                return("true");
            }

            return(ComplainData.ToString());
        }
        public void AllocateWithClick()
        {
            int r = complainGridView1.Rows.Count;

            string[] cid  = new string[r];
            int      j    = 0;
            bool     flag = false;

            for (int i = 0; i < r; i++)
            {
                CheckBox ch = (CheckBox)complainGridView1.Rows[i].FindControl("CheckBox1");
                Label    l  = (Label)complainGridView1.Rows[i].FindControl("Label2");

                if (ch.Checked == true)
                {
                    cid[j++] = l.Text;
                    flag     = true;
                }
            }
            if (flag == true && searchAssisDropDownList0.SelectedIndex > 0 && summaryTextBox.Text != null)
            {
                List <Complain> aAllocate = new List <Complain>();
                Complain        allocate  = new Complain();
                string          aName     = searchAssisDropDownList0.SelectedItem.ToString();
                int             bIn       = aName.IndexOf("(");
                allocate.AssistantName = aName.Substring(0, bIn - 1);
                if (Session["UserName"] != null)
                {
                    allocate.Remarks = DateTime.Now.ToShortDateString() + ":" + "(" + Session["UserName"] + ")" + summaryTextBox.Text;
                }
                else
                {
                    allocate.Remarks = DateTime.Now.ToShortDateString() + ":" + "(  )" + summaryTextBox.Text;
                }

                allocate.Status = "Pending";
                aAllocate.Add(allocate);
                Session["name11"] = allocate.AssistantName;
                string msg = aManagerBal.AllocateFinal(aAllocate, cid);
                Please_Select_Label7.Text = j + " Row IS " + msg;
            }

            else
            {
                Please_Select_Label7.Text = "Please Check The Box,Fill the textbox and select dropdownlist";
            }
        }
        public IActionResult RegisterComplainX(string unionCode, string sndCode, decimal?latitude, decimal?longitude)
        {
            Complain newComplain = new Complain
            {
                UnionGeoCode = unionCode, SnDCode = sndCode, Latitude = latitude, Longitude = longitude
            };

            ViewData["ComplainTypeList"] = new SelectList(_context.ComplainTypes, "ComplainTypeId", "ComplainType");
            //ViewData["ComplainStatusList"] = new SelectList(_context.ComplainStatus, "ComplainStatusId", "ComplainStatus");

            ViewData["UnionList"] = new SelectList(_context.LookUpAdminBndUnion.Where(un => un.UnionGeoCode.Equals(unionCode)), "UnionGeoCode", "UnionName", unionCode);
            ViewData["SnDList"]   = new SelectList(_context.LookUpSnDInfo.Where(snd => snd.SnDCode.Equals(sndCode)), "SnDCode", "SnDName", sndCode);

            //if (!string.IsNullOrEmpty(unionCode))
            //{
            //    var divCode = _context.LookUpAdminBndUnion.FirstOrDefault(un => un.UnionGeoCode.Equals(unionCode))?
            //        .District.DivisionGeoCode;
            //    var distCode = _context.LookUpAdminBndUnion.FirstOrDefault(un => un.UnionGeoCode.Equals(unionCode))?
            //        .DistrictGeoCode;
            //    var upazCode = _context.LookUpAdminBndUnion.FirstOrDefault(un => un.UnionGeoCode.Equals(unionCode))?
            //        .UpazilaGeoCode;

            //    ViewData["DivList"] = new SelectList(_context.LookUpAdminBndDivision, "DivisionGeoCode", "DivisionName",
            //        divCode);

            //    ViewData["DistList"] =
            //        new SelectList(_context.LookUpAdminBndDistrict.Where(un => un.DivisionGeoCode.Equals(divCode)),
            //            "DistrictGeoCode", "DistrictName", distCode);
            //    ViewData["UpazList"] =
            //        new SelectList(_context.LookUpAdminBndUpazila.Where(up => up.DistrictGeoCode.Equals(distCode)),
            //            "UpazilaGeoCode", "UpazilaName", upazCode);
            //    ViewData["UnionList"] =
            //        new SelectList(_context.LookUpAdminBndUnion.Where(un => un.UpazilaGeoCode.Equals(upazCode)),
            //            "UnionGeoCode", "UnionName", unionCode);
            //}
            //else
            //{
            //    ViewData["DivList"] = new SelectList(_context.LookUpAdminBndDivision, "DivisionGeoCode", "DivisionName");
            //}


            //ViewData["ResolvingOfficerList"] = new SelectList(_context.Set<TblUserProfileDetail>(), "UserId", "Id");
            //ViewData["ResponsibleOfficerList"] = new SelectList(_context.Set<TblUserProfileDetail>(), "UserId", "Id");

            return(View(newComplain));
        }
        private DataTable GetGridData()
        {
            DataTable dt = new DataTable();

            try
            {
                Complain _objList = new Complain();
                dt = _objList.getTotalComplain();

                _gvList.DataSource = dt;
                _gvList.DataBind();
            }
            finally
            {
            }
            return(dt);
        }
Esempio n. 20
0
 public ActionResult Delete(int id)
 {
     try
     {
         using (InfraDbEntities db = new InfraDbEntities())
         {
             Complain emp = db.Complains.Where(x => x.Id == id).FirstOrDefault <Complain>();
             db.Complains.Remove(emp);
             db.SaveChanges();
         }
         return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllComplain()), message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
     }
     catch (Exception ex)
     {
         return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
     }
 }
        // GET: Complains/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Complain complain = db.ComplainDetails.Find(id);

            if (complain == null)
            {
                return(HttpNotFound());
            }
            ViewBag.ComplainRegistratationID = new SelectList(db.Complains, "ID", "UserName", complain.ComplainRegistratationID);
            ViewBag.DepartmentID             = new SelectList(db.Departments, "ID", "Name", complain.DepartmentID);
            ViewBag.OfficerID = new SelectList(db.Officers, "ID", "Name", complain.OfficerID);
            return(View(complain));
        }
Esempio n. 22
0
 public bool saveMessage(string message)
 {
     trans = session.BeginTransaction();
     try
     {
         Complain m = new Complain();
         m.Message = message;
         m.Dtime=DateTime.Now;
         session.Save(m);
         trans.Commit();
         return true;
     }
     catch (Exception)
     {
         return false;
     }
 }
 public DataRespond InsertComplain(Complain complain)
  {
      DataRespond data = new DataRespond();
      try
      {
          complain.createday = DateTime.Now;
          complain.status = 0;
          m_complainResponsitory.InsertComplain(complain);
          data.success = true;
      }
      catch(Exception e)
      {
          data.success = false;
          data.error = e;
      }
      return data;
  }
Esempio n. 24
0
 protected void EgvComplain_RowDataBound(object sender, GridViewRowEventArgs e)
 {
     if (e.Row.RowType == DataControlRowType.DataRow)
     {
         ComplainItemInfo dataItem = e.Row.DataItem as ComplainItemInfo;
         e.Row.Cells[2].Text = Complain.GetFiledNameById("ComplainType", dataItem.ComplainType);
         e.Row.Cells[4].Text = Complain.GetFiledNameById("MagnitudeOfExigence", dataItem.MagnitudeOfExigence);
         e.Row.Cells[5].Text = Complain.GetStatus(dataItem.Status);
         if (this.ShowOptions == 1)
         {
             HyperLink link = (HyperLink)e.Row.FindControl("LnkClientShow2");
             link.NavigateUrl = string.Empty;
             HyperLink link2 = (HyperLink)e.Row.FindControl("LnkComplainTitle");
             link2.NavigateUrl = string.Empty;
         }
     }
 }
Esempio n. 25
0
        //cmpln
        public int insertCmpln(Complain c)
        {
            SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Bishal\Documents\Complain_table.mdf;Integrated Security=True;Connect Timeout=30");

            con.Open();
            SqlCommand cmd = new SqlCommand("insert into cmpln(Id,Complain,Others)values('" + c.id + "','" + c.complain + "','" + c.other + "')", con);

            try
            {
                return(cmd.ExecuteNonQuery());
            }
            catch
            {
                con.Close();
                throw;
            }
        }
        public Complain DropInGrid(string cid)
        {
            Complain      dAll       = new Complain();
            SqlConnection connection = new SqlConnection(connectionString);
            SqlCommand    cmd        = new SqlCommand("select hostelNo,Category,Priority from complain where complainId='" + cid + "'", connection);

            connection.Open();
            SqlDataReader dr2 = cmd.ExecuteReader();

            if (dr2.Read())
            {
                dAll.HostelNo = int.Parse(Convert.ToString(dr2.GetValue(0)));
                dAll.Category = dr2["Category"].ToString();
                dAll.Priority = dr2["Priority"].ToString();
            }
            connection.Close();
            return(dAll);
        }
        public string GetComplain(string cId, string NId, string GovId, string ComText, string Ar)
        {
            Complain complain = new Complain();

            complain.CitizenId         = int.Parse(cId);
            complain.CitizenNationalId = NId;
            complain.ComplainText      = ComText;
            complain.GovernementId     = int.Parse(GovId);
            complain.Date = DateTime.Now;

            db.Complains.Add(complain);
            db.SaveChanges();
            if (Boolean.Parse(Ar) == true)
            {
                return("تم ارسال الشكوي بنجاح");
            }
            return("Complaint has been sent successfully");
        }
Esempio n. 28
0
 public string Save(Complain aComplain)
 {
     if (aGateway.IsComplainIdExists(aComplain))
     {
         return(" Complain ID is already Exists!");
     }
     else
     {
         if (aGateway.Save(aComplain) > 0)
         {
             return("Successfully Inserted !!");
         }
         else
         {
             return("Save Failed!");
         }
     }
 }
Esempio n. 29
0
        public List <Complain> ViewInGridView()
        {
            List <Complain> aGridView  = new List <Complain>();
            SqlConnection   connection = new SqlConnection(connectionString);
            SqlCommand      cmd        = new SqlCommand("Select * From Complain", connection);

            connection.Open();
            cmd.ExecuteNonQuery();
            dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                Complain aComplain = new Complain();
                aComplain.ComplainId     = dr.GetValue(0).ToString();
                aComplain.PersonName     = dr.GetValue(1).ToString();
                aComplain.HostelNo       = int.Parse(dr.GetValue(2).ToString());
                aComplain.RoomNo         = int.Parse(dr.GetValue(3).ToString());
                aComplain.Category       = dr.GetValue(4).ToString();
                aComplain.Subject        = dr.GetValue(5).ToString();
                aComplain.Summary        = dr.GetValue(6).ToString();
                aComplain.Priority       = dr.GetValue(7).ToString();
                aComplain.DateOfComplain = DateTime.Parse(dr.GetValue(8).ToString());
                aComplain.Status         = dr.GetValue(9).ToString();
                aComplain.ContactNo      = dr.GetValue(10).ToString();
                aComplain.AssistantName  = dr.GetValue(11).ToString();
                string rem  = dr.GetValue(12).ToString();
                string rema = "";
                if (rem.Length > 10)
                {
                    rema = rem.Substring(0, 10);
                }
                else
                {
                    rema = rem;
                }
                aComplain.Remarks          = rema;
                aComplain.AssistantContact = dr.GetValue(13).ToString();
                aComplain.full             = rem;
                aGridView.Add(aComplain);
            }

            dr.Close();
            connection.Close();
            return(aGridView);
        }
Esempio n. 30
0
        public ActionResult Create(AddComplainViewModel addComplainViewModel)
        {
            string userEmail = Session["Email"] != null ? Session["Email"].ToString() : string.Empty;

            logger.Debug(string.Format("AddComplain [Title={0}, Description={1}, Complainer={2}]", addComplainViewModel.Title, addComplainViewModel.Description, userEmail));

            if (ModelState.IsValid)
            {
                try
                {
                    var config = new MapperConfiguration(cfg => cfg.CreateMap <AddComplainViewModel, Complain>());
                    var mapper = new Mapper(config);

                    addComplainViewModel.Status = STATUS.PENDING.ToString();
                    Complain complain = mapper.Map <Complain>(addComplainViewModel);
                    if (Session["LoginId"] != null)
                    {
                        complain.ComplainerId = Convert.ToInt32(Session["LoginId"]);
                    }

                    int isAdded = complainService.AddComplain(complain);

                    if (isAdded > 0)
                    {
                        return(RedirectToAction("Index"));
                    }
                    else
                    {
                        ViewBag.Message = "Unable to perform this operation";
                        return(View());
                    }
                }
                catch (Exception ex)
                {
                    logger.Error(ex);
                    ViewBag.Message = "Something went wrong Please check your internet connection";
                    return(View());
                }
            }
            else
            {
                return(View());
            }
        }
Esempio n. 31
0
        public ActionResult AcceptEditProvide(Guid id)
        {
            if (!base.HasPermission("Complain", PermissionOperate.track))
            {
                return(JsonMessage(false, "你没有处理情况登记的权限"));
            }

            Complain complain = _complainService.GetById(id);

            if (complain.ProcessStatus != 0)
            {
                return(JsonMessage(false, "该投诉已被受理,不能继续操作!"));
            }

            UpdateModel <Complain>(complain);
            _complainService.Update(complain);
            base.AddLog(string.Format("受理投诉业务[{0}]", complain.Name), AdminLoggerModuleEnum.Complain);
            return(JsonMessage(true, "处理成功"));
        }
Esempio n. 32
0
        public IHttpActionResult GetLastComplainNo()
        {
            try
            {
                Complain complain = new Complain();
                complain = _complain.GetLastComplain();
                DateTime date = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById(ConfigurationManager.AppSettings["LocalTimeZone"]));

                string today = date.ToShortDateString().Replace("/", String.Empty);
                string nextComplainNo = String.Empty;

                if (complain != null)
                {
                    string complainNo = complain.ComplainNo;

                    string complaindate = complainNo.Split('-')[0];
                    int no = int.Parse(complainNo.Split('-')[1]);

                    if (complaindate == today)
                    {
                        nextComplainNo = complaindate + "-" + (no + 1);
                    }
                    else
                    {
                        nextComplainNo = today + "-" + "1";
                    }
                }else
                {
                    nextComplainNo = today + "-" + "1";
                }

                var messageData = new { code = Constant.SuccessMessageCode, message = Constant.MessageSuccess };
                var returnObject = new { complainNo = nextComplainNo, messageCode = messageData };
                return Ok(returnObject);
            }
            catch (Exception ex)
            {
                string errorLogId = _eventLog.WriteLogs(User.Identity.Name, ex, MethodBase.GetCurrentMethod().Name);
                var messageData = new { code = Constant.ErrorMessageCode, message = String.Format(Constant.MessageTaskmateError, errorLogId) };
                var returnObject = new { messageCode = messageData };
                return Ok(returnObject);
            }
        }
Esempio n. 33
0
 public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
     global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
     global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
     Complain ds = new Complain();
     global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
     any1.Namespace = "http://www.w3.org/2001/XMLSchema";
     any1.MinOccurs = new decimal(0);
     any1.MaxOccurs = decimal.MaxValue;
     any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
     sequence.Items.Add(any1);
     global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
     any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
     any2.MinOccurs = new decimal(1);
     any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
     sequence.Items.Add(any2);
     global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
     attribute1.Name = "namespace";
     attribute1.FixedValue = ds.Namespace;
     type.Attributes.Add(attribute1);
     global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
     attribute2.Name = "tableTypeName";
     attribute2.FixedValue = "ComplainDetailsDataTable";
     type.Attributes.Add(attribute2);
     type.Particle = sequence;
     global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
     if (xs.Contains(dsSchema.TargetNamespace)) {
         global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
         global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
         try {
             global::System.Xml.Schema.XmlSchema schema = null;
             dsSchema.Write(s1);
             for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
                 schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
                 s2.SetLength(0);
                 schema.Write(s2);
                 if ((s1.Length == s2.Length)) {
                     s1.Position = 0;
                     s2.Position = 0;
                     for (; ((s1.Position != s1.Length) 
                                 && (s1.ReadByte() == s2.ReadByte())); ) {
                         ;
                     }
                     if ((s1.Position == s1.Length)) {
                         return type;
                     }
                 }
             }
         }
         finally {
             if ((s1 != null)) {
                 s1.Close();
             }
             if ((s2 != null)) {
                 s2.Close();
             }
         }
     }
     xs.Add(dsSchema);
     return type;
 }
Esempio n. 34
0
 public virtual int Update(Complain dataSet) {
     return this.Adapter.Update(dataSet, "Investigation");
 }
Esempio n. 35
0
 public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
     Complain ds = new Complain();
     global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
     global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
     global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
     any.Namespace = ds.Namespace;
     sequence.Items.Add(any);
     type.Particle = sequence;
     global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
     if (xs.Contains(dsSchema.TargetNamespace)) {
         global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
         global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
         try {
             global::System.Xml.Schema.XmlSchema schema = null;
             dsSchema.Write(s1);
             for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
                 schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
                 s2.SetLength(0);
                 schema.Write(s2);
                 if ((s1.Length == s2.Length)) {
                     s1.Position = 0;
                     s2.Position = 0;
                     for (; ((s1.Position != s1.Length) 
                                 && (s1.ReadByte() == s2.ReadByte())); ) {
                         ;
                     }
                     if ((s1.Position == s1.Length)) {
                         return type;
                     }
                 }
             }
         }
         finally {
             if ((s1 != null)) {
                 s1.Close();
             }
             if ((s2 != null)) {
                 s2.Close();
             }
         }
     }
     xs.Add(dsSchema);
     return type;
 }
Esempio n. 36
0
 public virtual int Update(Complain.InvestigationDataTable dataTable) {
     return this.Adapter.Update(dataTable);
 }
Esempio n. 37
0
 public virtual int Update(Complain.ComplainDetailsDataTable dataTable) {
     return this.Adapter.Update(dataTable);
 }
Esempio n. 38
0
 public virtual int Update(Complain dataSet) {
     return this.Adapter.Update(dataSet, "ComplainDetails");
 }