Exemplo n.º 1
0
 public bool Delete(TRN_STUDENT_SUBJECT item)
 {
     try
     {
         unitOfWork.StudentSubjectRepository.Delete(item);
         unitOfWork.Save();
         return(true);
     }
     catch (Exception ex)
     { return(false); }
 }
Exemplo n.º 2
0
        protected void lkbSave_Click(object sender, EventArgs e)
        {
            try
            {
                //if (Page.IsValid)
                //{
                if (ddlClassName.SelectedIndex == 0)
                {
                    ShowMessage("Kindly select Class Name.", false);
                    return;
                }

                if (ddlSectionName.SelectedIndex == 0)
                {
                    ShowMessage("Kindly select Section Name.", false);
                    return;
                }

                if (string.IsNullOrEmpty(txtStudentname.Text.Trim()))
                {
                    ShowMessage("Kindly Enter Student Name.", false);
                    return;
                }
                if (string.IsNullOrEmpty(txtFathername.Text.Trim()))
                {
                    ShowMessage("Kindly Enter Father Name.", false);
                    return;
                }
                if (string.IsNullOrEmpty(txtMothername.Text.Trim()))
                {
                    ShowMessage("Kindly Enter Mother Name.", false);
                    return;
                }
                if (string.IsNullOrEmpty(txtDob.Text.Trim()))
                {
                    ShowMessage("Kindly Enter Date Of Birth.", false);
                    return;
                }
                MST_STUDENT student  = new MST_STUDENT();
                string      fileName = "";

                //  string ima = HiddenField1.Value;
                if (FileUpload1.HasFile)
                {
                    // Read the file and convert it to Byte Array
                    //string filePath = FileUpload1.PostedFile.FileName;
                    //string filename = Path.GetFileName(filePath);
                    //string ext = Path.GetExtension(filename);
                    //string contenttype = String.Empty;
                    ////Set the contenttype based on File Extension
                    //switch (ext)
                    //{
                    //    case ".jpg":
                    //    case ".JPG":
                    //        contenttype = "image/jpg";
                    //        break;
                    //    case ".png":
                    //    case ".PNG":
                    //        contenttype = "image/png";
                    //        break;
                    //    case ".jpeg":
                    //    case ".JPEG":
                    //        contenttype = "image/jpeg";
                    //        break;
                    //}
                    //if (contenttype != String.Empty)
                    //{
                    //    Stream fs = FileUpload1.PostedFile.InputStream;
                    //    BinaryReader br = new BinaryReader(fs);
                    //    Byte[] bytes = br.ReadBytes((Int32)fs.Length);
                    //    System.Drawing.Image img = System.Drawing.Image.FromStream(FileUpload1.PostedFile.InputStream);
                    //    decimal size = Math.Round(((decimal)FileUpload1.PostedFile.ContentLength / (decimal)1024), 2);
                    //    if (size > 2048)
                    //    {
                    //        ShowMessage("Size of the image to be uploaded cannot exceed two mb.", false);

                    //        return;
                    //    }
                    //    ImgByte = bytes;
                    //}
                    fileName = Guid.NewGuid().ToString() + Path.GetExtension(Path.GetFileName(FileUpload1.PostedFile.FileName));
                    FileUpload1.PostedFile.SaveAs(Server.MapPath("~/Images/") + fileName);
                    student.ImageUrl = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority) + ("/Images/") + fileName;
                }
                student.FormNumber   = Convert.ToInt64(lblform.Text.ToString());
                student.RollNumber   = txtRollNo.Text.Trim();
                student.SerialNumber = txtSerialNumber.Text.Trim();
                student.StudentName  = txtStudentname.Text.Trim();
                student.FatherName   = txtFathername.Text.Trim();
                student.MotherName   = txtMothername.Text.Trim();
                if (!string.IsNullOrEmpty(txtDob.Text.Trim()))
                {
                    student.DOB = DateTime.ParseExact(txtDob.Text.Trim(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
                    //  student.DOB = Convert.ToDateTime(txtDob.Text.Trim());//
                }
                student.Email          = txtEmailId.Text.Trim();
                student.LastSchoolName = txtlastschool.Text.Trim();
                if (ddlOccupation.SelectedIndex > 0)
                {
                    student.Occupation = Convert.ToInt32(ddlOccupation.SelectedItem.Value);//
                }
                student.ResidingSince = txtresiding.Text.Trim();
                student.Gender        = ddlGender.SelectedValue;// rdoMale.Checked;
                student.ReferredBy    = txtReferred.Text.Trim();
                student.AadharNumber  = txtAadharNo.Text.Trim();
                //student.Session = ddlYear.SelectedValue;// Convert.ToByte(EnumConstants.Session.Current);//
                student.ReferredMobileNumber  = txtMobileNo.Text.Trim();
                student.CorrespondenceAddress = txtCorrespondenceAddress.Text.Trim();
                //student.PermanentAddress = txtPermanentAddress.Text.Trim();
                student.Village_Town  = txtVillage.Text.Trim();
                student.ContactNumber = txtContactNo.Text.Trim();
                student.ZipCode       = txtPincode.Text.Trim();
                student.Nationality   = txtNationality.Text.Trim();
                student.WhatsAppNo    = txtWhatsapNo.Text.Trim();
                if (ddlSectionName.SelectedIndex > 0)
                {
                    student.SectionId = Convert.ToInt32(ddlSectionName.SelectedItem.Value);
                }
                if (ddlStateName.SelectedIndex > 0)
                {
                    student.StateId = Convert.ToInt32(ddlStateName.SelectedItem.Value);//
                }
                if (ddlCityName.SelectedIndex > 0)
                {
                    student.CityId = Convert.ToInt32(ddlCityName.SelectedItem.Value);//
                }
                if (ddlCasteType.SelectedIndex > 0)
                {
                    student.CasteType = Convert.ToByte(ddlCasteType.SelectedValue);//
                }
                if (ddlReligionName.SelectedIndex > 0)
                {
                    student.ReligionId = Convert.ToInt32(ddlReligionName.SelectedItem.Value);//
                }
                if (ddlCasteName.SelectedIndex > 0)
                {
                    student.CasteId = Convert.ToInt32(ddlCasteName.SelectedItem.Value);//
                }
                student.CreatedBy   = cls_Common.UserProfile.Id;
                student.CreatedDate = DateTime.Now;

                student.ClassId = Convert.ToInt32(ddlClassName.SelectedValue);
                student.Fin_ID  = Convert.ToInt32(ddlYear.SelectedValue);
                List <TRN_STUDENT_SUBJECT> subjects = new List <TRN_STUDENT_SUBJECT>();
                foreach (ListItem li in cblListSubject.Items)
                {
                    if (li.Selected)
                    {
                        TRN_STUDENT_SUBJECT item = new TRN_STUDENT_SUBJECT
                        {
                            SubjectId = Convert.ToInt32(li.Value)
                        };
                        subjects.Add(item);
                    }
                }
                student.TRN_STUDENT_SUBJECT = subjects;



                string studentid = Convert.ToString(ViewState["Student"]);
                if (studentid == "" || studentid == null)
                {
                    var result = _StudentDTO.Save(student);
                    if (result)
                    {
                        foreach (var item in student.TRN_STUDENT_SUBJECT)
                        {
                            item.StudentId = student.StudentId;
                            _StudentSubjectDTO.Save(item);
                        }
                        ShowMessage("Student Information Saved Successfully..", true);
                        ClearControl();
                        ShowFormNo();
                    }
                    else
                    {
                        ShowMessage("Some error found..", false);
                    }
                }
                else
                {
                    int exitstudentid = Convert.ToInt32(studentid);
                    var newdata       = _StudentDTO.GetDataForEdit(exitstudentid);
                    newdata.ImageUrl     = student.ImageUrl;
                    newdata.RollNumber   = txtRollNo.Text.Trim();
                    newdata.SerialNumber = txtSerialNumber.Text.Trim();
                    newdata.StudentName  = txtStudentname.Text.Trim();
                    newdata.FatherName   = txtFathername.Text.Trim();
                    newdata.MotherName   = txtMothername.Text.Trim();
                    if (newdata.DOB.HasValue)
                    {
                        newdata.DOB = DateTime.ParseExact(txtDob.Text.Trim(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
                    }
                    //newdata.DOB = Convert.ToDateTime(txtDob.Text.Trim());
                    newdata.Email          = txtEmailId.Text.Trim();
                    newdata.LastSchoolName = txtlastschool.Text.Trim();
                    if (ddlOccupation.SelectedIndex > 0)
                    {
                        newdata.Occupation = Convert.ToInt32(ddlOccupation.SelectedItem.Value);
                    }
                    newdata.ResidingSince         = txtresiding.Text.Trim();
                    newdata.Gender                = ddlGender.SelectedValue;// rdoMale.Checked;
                    newdata.ReferredBy            = txtReferred.Text.Trim();
                    newdata.AadharNumber          = txtAadharNo.Text.Trim();
                    newdata.Session               = Convert.ToByte(EnumConstants.Session.Current);
                    newdata.ReferredMobileNumber  = txtMobileNo.Text.Trim();
                    newdata.CorrespondenceAddress = txtCorrespondenceAddress.Text.Trim();
                    newdata.Village_Town          = txtVillage.Text.Trim();
                    newdata.ContactNumber         = txtContactNo.Text.Trim();
                    newdata.ZipCode               = txtPincode.Text.Trim();
                    newdata.Nationality           = txtNationality.Text.Trim();
                    newdata.WhatsAppNo            = txtWhatsapNo.Text.Trim();
                    if (ddlClassName.SelectedIndex > 0)
                    {
                        newdata.ClassId = Convert.ToInt32(ddlClassName.SelectedItem.Value);
                    }
                    if (ddlSectionName.SelectedIndex > 0)
                    {
                        newdata.SectionId = Convert.ToInt32(ddlSectionName.SelectedItem.Value);
                    }
                    if (ddlStateName.SelectedIndex > 0)
                    {
                        newdata.StateId = Convert.ToInt32(ddlStateName.SelectedItem.Value);
                    }
                    if (ddlCityName.SelectedIndex > 0)
                    {
                        newdata.CityId = Convert.ToInt32(ddlCityName.SelectedItem.Value);
                    }
                    if (ddlCasteName.SelectedIndex > 0)
                    {
                        newdata.CasteType = Convert.ToByte(ddlCasteType.SelectedValue);
                    }
                    if (ddlReligionName.SelectedIndex > 0)
                    {
                        newdata.ReligionId = Convert.ToInt32(ddlReligionName.SelectedItem.Value);
                    }
                    if (ddlCasteName.SelectedIndex > 0)
                    {
                        newdata.CasteId = Convert.ToInt32(ddlCasteName.SelectedItem.Value);
                    }
                    newdata.UpdatedBy   = cls_Common.UserProfile.Id;
                    newdata.UpdatedDate = DateTime.Now;

                    List <TRN_STUDENT_SUBJECT> subject = new List <TRN_STUDENT_SUBJECT>();
                    foreach (ListItem li in cblListSubject.Items)
                    {
                        if (li.Selected)
                        {
                            TRN_STUDENT_SUBJECT item = _StudentSubjectDTO.GetSubjectBy_StudentId_SubjectId(exitstudentid, Convert.ToInt32(li.Value));
                            if (item == null)
                            {
                                _StudentSubjectDTO.Save(new TRN_STUDENT_SUBJECT {
                                    StudentId = exitstudentid, SubjectId = Convert.ToInt32(li.Value)
                                });
                            }
                        }
                        else
                        {
                            TRN_STUDENT_SUBJECT item = _StudentSubjectDTO.GetSubjectBy_StudentId_SubjectId(exitstudentid, Convert.ToInt32(li.Value));
                            if (item != null)
                            {
                                _StudentSubjectDTO.Delete(item);
                            }
                        }
                    }

                    var result = _StudentDTO.Update(newdata); // _StudentDTO.Save(newdata);
                    if (result)
                    {
                        ShowMessage("Student Information updated Successfully..", true);
                        //lkbSave.Text = "Add New Student";
                        // lkbSave.CommandName = "AddNew";
                        // ClearControl();
                        // ViewState["Student"] = null;
                        // ShowFormNo();
                    }
                    else
                    {
                        ShowMessage("Some error found in update student info..", false);
                    }
                }

                // uc_sucess.Visible
                //BindStudent();
                //}
            }
            catch (Exception ex)
            {
                ShowMessage(ex.Message, false);
            }
        }