private void LoadChapters(string Name = "") { using (basecampprodEntities dbs = new basecampprodEntities()) { ChapterList = (from item in dbs.chapters where item.Name.StartsWith(Name) select item).ToList(); DisplayChapters(ChapterList); } }
private void button2_Click(object sender, EventArgs e) { using (basecampprodEntities dbs = new basecampprodEntities()) { var chapterdetail = (from item in dbs.chapters where item.Name.ToUpper() == txtname.Text.ToUpper() select item).FirstOrDefault(); bool IsNew = chapterdetail == null ? true : false; chapterdetail = chapterdetail == null ? new chapter() : chapterdetail; chapterdetail.Name = txtname.Text.ToUpper(); chapterdetail.Description = txtdesciption.Text.ToUpper(); chapterdetail.Address = txtaddress.Text.ToUpper(); chapterdetail.CreatedDate = DateTime.UtcNow; if (IsNew) { dbs.chapters.Add(chapterdetail); } dbs.SaveChanges(); txtname.Text = ""; txtdesciption.Text = ""; txtaddress.Text = ""; ChapterList.Add(chapterdetail); } }
private dynamic EncodeLawyer(Lawyer Data) { dynamic response = new ExpandoObject(); response.RollNumber = Data.RollNumber; response.Success = false; response.Message = ""; try { using (TransactionScope tx = new TransactionScope()) { var dbs = new basecampprodEntities(); var lawyerinfo = new UserData(); bool IsNew = false; var basicinfo = (from item in dbs.users where item.LoginID.Equals(Data.RollNumber) select item).FirstOrDefault(); response.Type = basicinfo == null ? Type.Insert : Type.Update; response.Message = basicinfo == null ? string.Format("succesfully {0} the record", Type.Insert) : string.Format("succesfully {0} the record", Type.Update); #region User Type IsNew = basicinfo == null ? true : false; basicinfo = basicinfo == null ? new user() : basicinfo; string[] fullname = Data.Name.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); string[] name = fullname[1].Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries); string firstname = ""; for (int ii = 0; ii <= name.Length - 2; ii++) { firstname = firstname + " " + name[ii]; } basicinfo.LastName = fullname[0]; basicinfo.FirstName = firstname; basicinfo.MiddleName = name[name.Length - 1]; basicinfo.LoginID = Data.RollNumber; basicinfo.MembershipType = Data.LifeTimeRoll == "" ? "Annual" : "LifeTime"; basicinfo.IBPNumber = Data.LifeTimeRoll; basicinfo.AddToBar = int.Parse(Data.YearAdmitted); basicinfo.IsLiving = true; basicinfo.isLawyer = true; if (IsNew) { dbs.users.Add(basicinfo); } dbs.SaveChanges(); IsNew = false; #endregion #region UserInfo Type var OtherInfo = (from item in dbs.userinfoes where item.UserID == basicinfo.UserID select item).FirstOrDefault(); IsNew = OtherInfo == null ? true : false; OtherInfo = OtherInfo == null ? new userinfo() : OtherInfo; var ChapterDetail = (from item in dbs.chapters where item.Name.ToUpper() == Data.Chapter.ToUpper() select item).FirstOrDefault(); if (ChapterDetail != null) { OtherInfo.UserID = basicinfo.UserID; OtherInfo.ChapterID = ChapterDetail.ChapterID; OtherInfo.Birthday = Data.BirthDate; OtherInfo.Address = Data.HomePhone; OtherInfo.Sex = Data.Sex.Substring(0, 1); OtherInfo.CivilStatus = Data.Status; OtherInfo.CreatedDate = DateTime.UtcNow; if (IsNew) { dbs.userinfoes.Add(OtherInfo); } dbs.SaveChanges(); IsNew = false; } else { throw new Exception(string.Format("{0} Chapter is not Existing in Database.", Data.Chapter)); } #endregion #region PhoneInfo Type var phones = (from item in dbs.userinfophones where item.UserID == basicinfo.UserID select item).ToList(); foreach (var item in phones) { dbs.userinfophones.Remove(item); } string[] homephones = Data.HomePhone.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string[] offphones = Data.WorkPhone.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); foreach (string phone in homephones) { var HomePhone = new userinfophone(); HomePhone.UserID = basicinfo.UserID; HomePhone.Type = "Home"; HomePhone.SecurityType = "Private"; HomePhone.Number = string.Format("{0}/{1}Home", phone, basicinfo.UserID); dbs.userinfophones.Add(HomePhone); } foreach (string phone in offphones) { var EmployePhone = new userinfophone(); EmployePhone.UserID = basicinfo.UserID; EmployePhone.Type = "Office"; EmployePhone.SecurityType = "Private"; EmployePhone.Number = string.Format("{0}/{1}Office", phone, basicinfo.UserID); dbs.userinfophones.Add(EmployePhone); } dbs.SaveChanges(); #endregion #region EmailInfo Type if (Data.Email != "") { var emails = (from item in dbs.userinfoemails where item.UserID == basicinfo.UserID select item).ToList(); foreach (var item in emails) { dbs.userinfoemails.Remove(item); } var email = new userinfoemail(); email.UserID = basicinfo.UserID; email.Type = "personal"; email.IsPrimary = false; email.EmailAddress = Data.Email; email.SecurityType = "Private"; dbs.userinfoemails.Add(email); dbs.SaveChanges(); } #endregion #region College Type var CollegeSchool = (from item in dbs.colleges where item.Name.ToUpper() == Data.LawSchool.ToUpper() select item).FirstOrDefault(); IsNew = CollegeSchool == null ? true : false; CollegeSchool = CollegeSchool == null ? new college() : CollegeSchool; CollegeSchool.Name = Data.LawSchool; if (IsNew) { dbs.colleges.Add(CollegeSchool); } dbs.SaveChanges(); var CollegeSchools = (from item in dbs.userinfocolleges where item.UserID == basicinfo.UserID select item).ToList(); foreach (var item in CollegeSchools) { dbs.userinfocolleges.Remove(item); } var collegeInfo = new userinfocollege(); collegeInfo.UserID = basicinfo.UserID; collegeInfo.ID = CollegeSchool.ID; collegeInfo.Year = new DateTime(); dbs.userinfocolleges.Add(collegeInfo); dbs.SaveChanges(); #endregion #region Employer Type var EmployerInfo = new employer(); EmployerInfo.Address = Data.WorkAddress; EmployerInfo.Name = ""; EmployerInfo.Description = Data.Occupation; dbs.employers.Add(EmployerInfo); dbs.SaveChanges(); var empInfo = new userinfoemployer(); empInfo.UserID = basicinfo.UserID; empInfo.ID = EmployerInfo.ID; empInfo.StartYear = new DateTime(); empInfo.StillEmployed = true; dbs.userinfoemployers.Add(empInfo); dbs.SaveChanges(); #endregion #region Specialization if (Data.Specialization != "") { var specialization = (from item in dbs.professions where item.Name.ToUpper() == Data.Specialization.ToUpper() select item).FirstOrDefault(); IsNew = specialization == null ? true : false; specialization = specialization == null ? new profession() : specialization; specialization.Name = Data.Specialization; if (IsNew) { dbs.professions.Add(specialization); } basicinfo.professions.Add(specialization); dbs.SaveChanges(); } #endregion response.Success = true; tx.Complete(); return response; } } catch (Exception e) { response.Type = Type.Unknown; string message = ""; if (e.InnerException != null) { if (e.InnerException.InnerException != null) { message = e.InnerException.InnerException.Message; } else { message = e.InnerException.Message; } } else { message = e.Message; } response.Message = message; return response; } }
private void button6_Click(object sender, EventArgs e) { Excel.Workbook MyBook = null; Excel.Application MyApp = null; Excel.Worksheet MySheet = null; MyApp = new Excel.Application(); MyApp.Visible = false; MyBook = MyApp.Workbooks.Open(@"C:\Users\Francis\Desktop\IBPExcelApp\IBPExcelApplication\bin\Debug\IBP LIFETIME MEMBERS 06182014.xlsx"); MySheet = (Excel.Worksheet)MyBook.Sheets[1]; var list = new List<Lawyer>(); int init = int.Parse(txtstartTab2.Text); int end = int.Parse(txtendtab2.Text); new Thread(() => { using (basecampprodEntities dbs = new basecampprodEntities()) { for (int i = init; i <= end; i++) { System.Array MyValues = (System.Array)MySheet.get_Range("A" + i.ToString(), "D" + i.ToString()).Cells.Value; ListViewItem lvitem = new ListViewItem(i.ToString()); lvitem.SubItems.Add(MyValues.GetValue(1, 1).ToString()); lvitem.SubItems.Add("Update"); try { string roll = MyValues.GetValue(1, 1).ToString(); var UserDetail = (from item in dbs.users where item.LoginID == roll select item).FirstOrDefault(); UserDetail.MembershipType = "LifeTime"; UserDetail.IBPNumber = MyValues.GetValue(1, 4).ToString(); dbs.SaveChanges(); lvitem.SubItems.Add("Success in updating the lifetime membership"); lvitem.BackColor = Color.LimeGreen; } catch (Exception err) { string message = ""; if (err.InnerException != null) { if (err.InnerException.InnerException != null) { message = err.InnerException.InnerException.Message; } else { message = err.InnerException.Message; } } else { message = err.Message; } lvitem.SubItems.Add(message); lvitem.BackColor = Color.DarkRed; lvitem.ForeColor = Color.White; } listView2.Invoke((Action)(() => { listView2.Items.Add(lvitem); })); } } }).Start(); }