public static int Insert(tblGroup group) { var db = new dbTrainEntities(ConnectionController.GetConnection()); group.CreatedDate = CommonFactory.GetCurrentDate(); group.ModifiedDate = CommonFactory.GetCurrentDate(); db.AddTotblGroups(group); int re = db.SaveChanges(); db.Connection.Close(); return(re); }
public string ListQuyen(int id) { string str = ""; var list = dt.tblUserGroups.Where(v => v.iUser == id).ToList(); foreach (var d in list) { tblGroup g = dt.tblGroups.Single(v => v.iD.Equals((int)d.iGroup)); str += g.cName + "<br/>"; } return(str); }
private void btnAdd_Click(object sender, EventArgs e) { if (!valName.Validate()) { return; } var nameGroup = txtGroup.Text; if (txtMax.Text == "") { txtMax.Text = "0"; } var maxNumber = Convert.ToInt32(txtMax.Text); var idClass = Convert.ToInt32(cmbClass.EditValue); if (isExist(nameGroup)) { XtraMessageBox.Show("توجد مجموعة بهذا الإسم", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (dt.Rows.Count == 0) { XtraMessageBox.Show("يجب علي الأقل إختيار معاد واحد", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } tblGroup g = new tblGroup() { nameGroup = nameGroup, maxNumber = maxNumber, idClass = idClass }; db.tblGroups.Add(g); foreach (DataRow dr in dt.Rows) { string day = dr["اليوم"].ToString(); string hour = dr["الساعة"].ToString(); tblRelation r = new tblRelation() { idGroup = g.idGroup, Day = day, Time = hour, }; db.tblRelations.Add(r); } db.SaveChanges(); XtraMessageBox.Show("تمت إضافة المجموعة بنجاح", "إضافة", MessageBoxButtons.OK, MessageBoxIcon.Information); ClrBoxs(); }
private void btnView_Click(object sender, RoutedEventArgs e) { try { object rowDep = lupeditDep.SelectedItem; tblDepartment iDep = (tblDepartment)rowDep; object rowSec = lupeditSec.SelectedItem; tblSection iSec = (tblSection)rowSec; object rowGro = lupeditGroup.SelectedItem; tblGroup iGro = (tblGroup)rowGro; if (colFromDate.DateTime != null && colToDate.DateTime != null) { int depID = -1; if (iDep != null) { depID = iDep.DepartmentID; } int secID = -1; if (iSec != null) { secID = iSec.SectionID; } int groID = -1; if (iGro != null) { groID = iGro.GroupID; } string empID = "-1"; if (txtEmpId.GetID().EmployeeID != null) { empID = txtEmpId.GetID().EmployeeID; } websv.CheckTimeListAsync(colFromDate.DateTime, colToDate.DateTime, depID, secID, groID, empID, ckbNormal.IsChecked.Value, ckbNoTimeInHasTimeOut.IsChecked.Value, ckbHasTimeInNoTimeOut.IsChecked.Value, ckbNoTimeInNoTimeOut.IsChecked.Value, ckbWorkOnHoliday.IsChecked.Value, ckbLeave.IsChecked.Value, ckbHoliday.IsChecked.Value, 3); //panelThietLap.Closed = true; gridCheckTimeList.View.ShowTotalSummary = true; gridCheckTimeList.View.ShowFixedTotalSummary = true; tblView.SelectAll(); //lblTest.Content = gridCheckTimeList.VisibleRowCount.ToString(); //hide panel Layout1.DockController.Hide(panelThietLap); gridCheckTimeList.Focus(); } } catch (Exception) { throw new Exception(); } }
public void DeleteTest() { using (MusicEntities dc = new MusicEntities()) { tblGroup group = dc.tblGroups.FirstOrDefault(a => a.Name == "Updated Test Group"); dc.tblGroups.Remove(group); dc.SaveChanges(); tblGroup retrievedGroup = dc.tblGroups.FirstOrDefault(a => a.Name == "Updated Test Group"); Assert.IsNull(retrievedGroup); } }
public static bool Them(tblGroup group) { try { string sTruyVan = string.Format("Insert into tblGroup(IDGroup,TaiKhoan,Name,ImgLink,Status,Description) values('{0}',N'{1}',N'{2}',N'{3}',N'{4}',N'{5}')", group.IDGroup, group.TaiKhoan, group.Name, group.ImgLink, group.Status, group.Description); con = DataProvider.KetNoi(); DataProvider.ThucThiTruyVanNonQuery(sTruyVan, con); DataProvider.DongKetNoi(con); return(true); } catch { return(false); } }
public static bool Sua(tblGroup group) { try { con = DataProvider.KetNoi(); string sTruyVan = string.Format("Update tblGroup set Status='{0}' where IDGroup = '{1}'", group.Status, group.IDGroup); DataProvider.ThucThiTruyVanNonQuery(sTruyVan, con); DataProvider.DongKetNoi(con); return(true); } catch { return(false); } }
public static Guid AddTblGroup(tblGroup aGroup) { using (var db = new Odiss_OPG_BaseEntities()) { if (aGroup.GUID == Guid.Empty) { aGroup.GUID = Guid.NewGuid(); } db.Entry(aGroup).State = EntityState.Added; db.SaveChanges(); return(aGroup.GUID); } }
public ActionResult Group(tblGroup ob) { if (ob.GROUP_ID != null) { db.tblGroups.Add(ob); db.SaveChanges(); ViewBag.Suc = "success"; ModelState.Clear(); } else { ModelState.AddModelError(" ", "Enter value"); } return(View()); }
public static int Update(tblGroup group) { var db = new dbTrainEntities(ConnectionController.GetConnection()); var groupOrgin = db.tblGroups.Where(g => g.GroupID == group.GroupID).FirstOrDefault(); if (groupOrgin == null) { return(-1); } db.Attach(groupOrgin); db.ApplyPropertyChanges("tblGroups", group); int re = db.SaveChanges(); db.Connection.Close(); return(re); }
private void btnUpdatePermission_Click(object sender, EventArgs e) { //check is group exist tblGroup group = GroupFactory.getGroupByID(_groupID); if (group == null) { MessageBox.Show("Nhóm người dùng này không còn tại tại trong hệ thống nữa, xin kiểm tra lại"); return; } //delete all old permissions UserGroupPermissionFactory.DeleteUserGroupPermissionByGroupID(_groupID); //add new permissions try { List <tblUserGroupPermission> listUserGroupPermission = new List <tblUserGroupPermission>(); foreach (DataGridViewRow dr in grvPermission.Rows) { if (dr.Cells[0].Value + "" == "True") { int permissionID = (int)dr.Cells[1].Value; tblUserGroupPermission userGroupPermission = new tblUserGroupPermission(); userGroupPermission.GroupID = _groupID; userGroupPermission.PermissionID = permissionID; userGroupPermission.PermissionType = UserGroupPermissionFactory.PERMISSION_TYPE_GROUP; userGroupPermission.CreatedBy = _userInfo.UserID; userGroupPermission.ModifiedBy = _userInfo.UserID; userGroupPermission.CreatedDate = CommonFactory.GetCurrentDate(); userGroupPermission.ModifiedDate = CommonFactory.GetCurrentDate(); //add to listUserGroupPermission listUserGroupPermission.Add(userGroupPermission); } } //save listUserGroupPermission to database UserGroupPermissionFactory.Insert(listUserGroupPermission); } catch (Exception) { MessageBox.Show(ConstantInfo.MESSAGE_ADD_USER_IN_GROUP_FAIL); return; } MessageBox.Show(ConstantInfo.MESSAGE_ADD_USER_IN_GROUP_SUCESSFULLY); }
public bool DeleteById(short id) { using (var db = new ModelDbContext()) { if (!db.tblGroups.Any(p => p.Id == id)) { return(false); } var item = new tblGroup() { Id = id }; db.tblGroups.Attach(item); db.tblGroups.Remove(item); return(db.SaveChanges() > 0); } }
public void TestAddTblGroup() { //Arrange tblGroup aGroup = new tblGroup(); aGroup.InvoiceNo = "invoiceNo"; aGroup.OriginalFilename = "original file anme"; aGroup.ScanDate = DateTime.Now.AddDays(-10); aGroup.TotalAmount = 10000.11M; aGroup.Filename = "filename"; aGroup.DirectoryID = "20181126"; //Act var guid = TblGroupHelper.AddTblGroup(aGroup); //Assert Assert.AreNotEqual(null, guid); }
public static int ParseOctacomExceptionXmlFile(string xmlFullPathName, out string batchType, out string exceptionCode, out tblGroup aGroup, out List <tblGroupLine> lines) { aGroup = new tblGroup(); lines = new List <tblGroupLine>(); XElement xml = XElement.Load(xmlFullPathName); IEnumerable <XElement> codes = from node1 in xml.Descendants("ExceptionCode") select node1; exceptionCode = (string)codes.First(); codes = from node1 in xml.Descendants("BatchType") select node1; batchType = (string)codes.First(); codes = from node1 in xml.Descendants("Document") select node1; codes = from node1 in xml.Descendants("ScanDate") select node1; DateTime scandate; if (DateTime.TryParse((string)codes.First(), out scandate)) { OdissLogger.Error($"Invalid scan date: {(string)codes.First()}"); } aGroup.ScanDate = scandate; IEnumerable <XElement> fields = from nodes in xml.Descendants("Field") select nodes; string invoiceNumber = (string)fields.Where(x => (string)x.Attribute("Type") == "invoicenumber").First(); string ponumber = (string)fields.Where(x => (string)x.Attribute("Type") == "invoiceordernumber").First(); string utility = (string)fields.Where(x => (string)x.Attribute("Type") == "utility").First(); string strTotalAmount = (string)fields.Where(x => (string)x.Attribute("Type") == "invoicetotalvatincludedamount").First(); aGroup.InvoiceNo = invoiceNumber; aGroup.ExceptionCode = exceptionCode; aGroup.PONumber = ponumber; aGroup.Utility = utility; aGroup.TotalAmount = decimal.Parse(strTotalAmount); return(1); }
public void Update() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblGroup group = (from g in oDC.tblGroups where g.Id == Id select g).FirstOrDefault(); group.Id = Id; group.Name = Name; group.Description = Description; group.GroupType = GroupType; group.OwnerGroupId = OwnerGroupId; group.CanPostDefault = CanPostDefault; group.CanInviteDefault = CanInviteDefault; group.CanDeleteDefault = CanDeleteDefault; group.GroupImgId = GroupImgId; oDC.SubmitChanges(); } }
public void InsertTest() { using (MusicEntities dc = new MusicEntities()) { tblGroup group = new tblGroup(); group.Id = Guid.NewGuid(); group.Name = "Test Group"; group.Description = "Test Description"; group.FoundedDate = DateTime.Now; dc.tblGroups.Add(group); dc.SaveChanges(); tblGroup retrievedGroup = dc.tblGroups.FirstOrDefault(a => a.Name == "Test Group"); Assert.AreEqual(group.Id, retrievedGroup.Id); } }
public static int MoveResubmitDocPDF(tblGroup doc) { string pdfStorageRoot = ConfigurationManager.AppSettings["PDFRootFolder"]; if (pdfStorageRoot.LastIndexOf("\\") != pdfStorageRoot.Length - 1) { pdfStorageRoot += "\\"; // add last back slash } string resubmitPDFRootFolder = GetResubmitPDFRootFolder(); string directoryId = doc.DirectoryID; string year = directoryId.Substring(0, 4); string fileName = doc.Filename; string sourceFile = $"{pdfStorageRoot}{year}\\{directoryId}\\{fileName}"; string destFolder = $"{resubmitPDFRootFolder}{year}\\{directoryId}"; if (!Directory.Exists(destFolder)) { Directory.CreateDirectory(destFolder); } string destFile = $"{destFolder}\\{fileName}"; try { File.Copy(sourceFile, destFile); //File.Delete(sourceFile); // dont delete for now, since tblGroup table record still there } catch (Exception ex) { string details = ex.ToString(); if (details.IndexOf("already exist") > -1) { return(0); } OdissLogger.Error($"MoveResubmitDocPDF error: {details}"); return(-1); } return(1); }
//đánh giá trang, nhóm private void DanhGia(int kt) { foreach (ListViewItem item in lsKetQuaSearch.SelectedItems) { // thêm vào pages if (DrbtnLoaiTim.selectedIndex == 0) { tblPage pg = new tblPage(); pg.IDPage = lsIDPage[item.Index]; pg.Name = lsNamePage[item.Index]; pg.ImgLink = lsLinkImgPage[item.Index]; pg.Status = kt; pg.TaiKhoan = taikhoan; DAO.Pages.Them(pg); } //thêm vào groups if (DrbtnLoaiTim.selectedIndex == 1) { tblGroup newgroup = new tblGroup(); newgroup.IDGroup = lsIDPage[item.Index]; newgroup.Name = lsNamePage[item.Index]; newgroup.ImgLink = lsLinkImgPage[item.Index]; newgroup.Status = kt; newgroup.TaiKhoan = taikhoan; DAO.Group.Them(newgroup); DataTable dt = AccountFB.LoadDuLieuByNhanVien(taikhoan); for (int i = 0; i < dt.Rows.Count; i++) { ThuVienLamViecFacebook.DangXuat(); ThuVienLamViecFacebook.DNKhongLayTT(dt.Rows[i]["NumberIDAccount"].ToString()); ThuVienLamViecFacebook.JoinGroup(lsIDPage[item.Index]); } } //xóa cái vừa đánh giá khỏi danh sách lsIDPage.RemoveAt(item.Index); lsNamePage.RemoveAt(item.Index); lsLinkImgPage.RemoveAt(item.Index); lsKetQuaSearch.Items.RemoveAt(item.Index); } MessageBox.Show("Đã thêm vào danh sách"); }
public bool UpdateStatus(short id, short status) { using (var db = new ModelDbContext()) { var item = new tblGroup() { Id = id }; if (db.tblGroups.Any(p => p.Id == id)) { db.tblGroups.Attach(item); item.Status = status; } else { return(false); } return(db.SaveChanges() > 0); } }
public int Delete() { try { using (MusicEntities dc = new MusicEntities()) { //Retrieve it from the DB tblGroup group = dc.tblGroups.FirstOrDefault(p => p.Id == this.Id); //Remove the group dc.tblGroups.Remove(group); //Save the changes return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public sp_Group_DM InsertGroupContext(ref sp_Group_DM _cGroup) { using (VolTeerEntities context = new VolTeerEntities()) { var cGroup = new tblGroup { GroupID = _cGroup.GroupID, GroupName = _cGroup.GroupName, ParticipationLevelID = _cGroup.ParticipationLevelID, ActiveFlg = _cGroup.ActiveFlg, ShortDesc = _cGroup.ShortDesc, LongDesc = _cGroup.LongDesc }; context.tblGroups.Add(cGroup); context.SaveChanges(); // pass VolID back to BLL _cGroup.GroupID = cGroup.GroupID; return _cGroup; } }
//Retrieve the group from the database with this Id public void LoadById() { try { using (MusicEntities dc = new MusicEntities()) { //Retrieve from the db tblGroup group = dc.tblGroups.FirstOrDefault(p => p.Id == this.Id); //Set this group's properties this.Name = group.Name; this.Description = group.Description; if (group.FoundedDate.HasValue) { this.FoundedDate = group.FoundedDate.Value; } } } catch (Exception ex) { throw ex; } }
public int Update() { try { using (MusicEntities dc = new MusicEntities()) { //Retrieve the record from the DB tblGroup group = dc.tblGroups.FirstOrDefault(c => c.Id == this.Id); //Update the properties group.Name = this.Name; group.Description = this.Description; group.FoundedDate = this.FoundedDate; //Save the changes return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public IHttpActionResult Upsert([FromBody] tblGroup document) { try { using (var ctx = new Odiss_OPG_BaseEntities()) { var existing = ctx.tblGroups.SingleOrDefault(x => x.GUID == document.GUID); document.tblGroupLines = document.lineItems; foreach (var item in document.tblGroupLines) { if (item.Guid == Guid.Empty) { item.Guid = Guid.NewGuid(); } } if (existing != null) { ctx.Entry(existing).State = System.Data.Entity.EntityState.Detached; ctx.UpdateGraph(document, map => map.OwnedCollection(x => x.tblGroupLines)); } else { ctx.tblGroups.Add(document); } ctx.SaveChanges(); } return(Ok(new { status = 1, obj = document })); } catch (Exception ex) { return(Ok(new { status = -1, obj = ex })); } }
public void Insert(CGroup group) { try { WorkWithMeDataContext oDC = new WorkWithMeDataContext(); tblGroup g = new tblGroup(); // g.Id = Id; g.Description = Description; g.GroupType = GroupType; g.OwnerGroupId = OwnerGroupId; // g.CanPostDefault = CanPostDefault; // g.CanInviteDefault = CanInviteDefault; // g.CanDeleteDefault = CanDeleteDefault; oDC.tblGroups.InsertOnSubmit(g); oDC.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public bool InsertAndUpdate(tblGroup group) { using (var db = new ModelDbContext()) { var item = new tblGroup() { Id = group.Id }; if (db.tblGroups.Any(p => p.Id == group.Id)) { db.tblGroups.Attach(item); item.Title = group.Title; item.Describe = group.Describe; item.Icon = group.Icon; item.ModifyDate = DateTime.Now; item.ParentId = group.ParentId; } else { db.tblGroups.Add(group); } return(db.SaveChanges() > 0); } }
public static int ParseAribaPrimaryXMLFile(string sourceFullFolder, string primaryFileName, DateTime finalizationTime, out tblGroup group, out List <tblGroupLine> groupLines, out string processMessage) { group = new tblGroup(); groupLines = new List <tblGroupLine>(); processMessage = ""; if (!File.Exists($"{sourceFullFolder}{primaryFileName}")) { processMessage = $"Primary XML file: { sourceFullFolder}{ primaryFileName} does not exist."; OdissLogger.Error(processMessage); return(-1); } XmlDocument doc = new XmlDocument(); doc.Load($"{sourceFullFolder}{primaryFileName}"); XmlNode invoiceDetailRequest = doc.SelectSingleNode("/cXML/Request/InvoiceDetailRequest"); XmlNode requestHeader = invoiceDetailRequest.SelectSingleNode("InvoiceDetailRequestHeader"); string invoiceID = requestHeader.Attributes["invoiceID"].Value; group.InvoiceNo = invoiceID; XmlNode nodeGrossAmount = invoiceDetailRequest.SelectSingleNode("InvoiceDetailSummary/GrossAmount"); string strGrossAmount = nodeGrossAmount.SelectSingleNode("Money").InnerText; decimal grossAmount; if (!decimal.TryParse(strGrossAmount, out grossAmount)) { processMessage = $"File:{sourceFullFolder}{primaryFileName} has invalid GrossAmount:{strGrossAmount}"; OdissLogger.Error(processMessage); return(-2); } group.TotalAmount = grossAmount; group.GUID = Guid.NewGuid(); group.I_CaptureDate = DateTime.Now; XmlNodeList invoiceDetailOrders = invoiceDetailRequest.SelectSingleNode("InvoiceDetailOrder").SelectNodes("InvoiceDetailItem"); XmlNode nodeInvoiceDetailOrderInfo = invoiceDetailRequest.SelectSingleNode("InvoiceDetailOrder/InvoiceDetailOrderInfo/MasterAgreementIDInfo"); string PONumber = nodeInvoiceDetailOrderInfo.Attributes["agreementID"].Value; group.PONumber = PONumber; foreach (XmlNode item in invoiceDetailOrders) { string uom = item.SelectSingleNode("UnitOfMeasure").InnerText; string unitPrice = item.SelectSingleNode("UnitPrice/Money").InnerText; string quantity = item.Attributes["quantity"].Value; string strLineNumber = item.Attributes["invoiceLineNumber"].Value; tblGroupLine aline = new tblGroupLine(); aline.UOM = uom; aline.Qty = int.Parse(quantity); aline.UnitPrice = decimal.Parse(unitPrice); aline.Guid = Guid.NewGuid(); aline.ReferenceId = group.GUID; aline.InvoiceLineNumber = int.Parse(strLineNumber); groupLines.Add(aline); } return(1); }
public static tblGroup CreatetblGroup(int groupID, string groupName, string branchId) { tblGroup tblGroup = new tblGroup(); tblGroup.GroupID = groupID; tblGroup.GroupName = groupName; tblGroup.BranchId = branchId; return tblGroup; }
public static int ParseOctacomExceptionXmlFile(string xmlFullPathName, out string batchType, out string exceptionCode, out string pureSourceImage, out tblGroup aGroup, out List <tblGroupLine> lines) { // \\datacap-srv\opg_ap\IMAGES\SCAN\0007_OP_201811200045_001.TIF pureSourceImage:OP_201811200045 aGroup = new tblGroup(); lines = new List <tblGroupLine>(); XElement xml = XElement.Load(xmlFullPathName); IEnumerable <XElement> codes = from node1 in xml.Descendants("ExceptionCode") select node1; exceptionCode = (string)codes.First(); codes = from node1 in xml.Descendants("BatchType") select node1; batchType = (string)codes.First(); codes = from node1 in xml.Descendants("SourceImage") select node1; pureSourceImage = (string)codes.First(); int ind = pureSourceImage.LastIndexOf("\\"); if (ind > 0) { pureSourceImage = pureSourceImage.Substring(ind + 1); pureSourceImage = pureSourceImage.Substring(5, 15); } codes = from node1 in xml.Descendants("Document") select node1; codes = from node1 in xml.Descendants("ScanDate") select node1; string scanDateStr = (string)codes.First(); DateTime scandate = new DateTime(1970, 1, 1); //12/20/2018 try { int year = int.Parse(scanDateStr.Substring(6)); int month = int.Parse(scanDateStr.Substring(0, 2)); int day = int.Parse(scanDateStr.Substring(3, 2)); scandate = new DateTime(year, month, day); } catch (Exception ex) { OdissLogger.Error($"Invalid scan date: {(string)codes.First()}"); } aGroup.ScanDate = scandate; IEnumerable <XElement> fields = from nodes in xml.Descendants("Field") select nodes; string invoiceNumber = (string)fields.Where(x => (string)x.Attribute("Type") == "invoicenumber").First(); string ponumber = (string)fields.Where(x => (string)x.Attribute("Type") == "invoiceordernumber").First(); string utility = (string)fields.Where(x => (string)x.Attribute("Type") == "utility").First(); string strTotalAmount = (string)fields.Where(x => (string)x.Attribute("Type") == "invoicetotalvatincludedamount").First(); aGroup.InvoiceNo = invoiceNumber; aGroup.ExceptionCode = exceptionCode; aGroup.PONumber = ponumber; aGroup.Utility = utility; aGroup.TotalAmount = decimal.Parse(strTotalAmount); return(1); }
private void btnSave_Click(object sender, EventArgs e) { var dr = MessageBox.Show("Bạn có muốn lưu", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr != DialogResult.Yes) { return; } try { // Validate if (!Validate()) { return; } if (_mode.Equals(Mode.Create)) // New mode { // Only insert the new group if the group name is not exsiting if (!GroupFactory.IsExistingName(txtName.Text.Trim())) { var group = new tblGroup(); group.GroupName = txtName.Text.Trim(); group.CreatedBy = _userInfo.UserID; group.ModifedBy = _userInfo.UserID; var result = GroupFactory.Insert(group); if (result < 1) { MessageBox.Show(ConstantInfo.MESSAGE_INSERT_NOT_SUCESSFULLY); return; } //getGroup after save tblGroup groupResuilt = new tblGroup(); groupResuilt = GroupFactory.getGroupByName(txtName.Text.Trim()); _groupID = groupResuilt.GroupID; // Bind the lastest to the parrent if (_parent != null) { _parent.InitData(); } //Form[] listForm = this.Owner.OwnedForms; //foreach (Form form in listForm) //{ // if (form.Name == "FrmListGroup") // { // ((frmListGroup)form).InitData(); // } //} MessageBox.Show(ConstantInfo.MESSAGE_INSERT_SUCESSFULLY); //this.Close(); btnSave.Enabled = false; tabControlGroup.TabPages.Add(_tabUser); tabControlGroup.TabPages.Add(_tabRight); LoadAllPermissionData(); CheckAllPermissonOfGroup(); //EnableTab(tabControlGroup.TabPages[0],false); } else { MessageBox.Show(ConstantInfo.MESSAGE_GROUP_NAME_EXISTING); } } else // Edit mode { // Update Group tblGroup group = GroupFactory.getGroupByID(_groupID); if (group == null) { MessageBox.Show(ConstantInfo.MESSAGE_GROUP_NOT_EXIST); return; } tblGroup groupCheck = GroupFactory.getGroupByName(txtName.Text.Trim()); if (groupCheck != null && (groupCheck.GroupID != _groupID && groupCheck.GroupName == txtName.Text.Trim())) { MessageBox.Show(ConstantInfo.MESSAGE_GROUP_NAME_EXISTING); return; } //update group group.GroupName = txtName.Text.Trim(); GroupFactory.Update(group); if (_parent != null) { _parent.InitData(); } // Bind the lastest to the parrent //Form[] listForm = this.Owner.OwnedForms; //foreach (Form form in listForm) //{ // if (form.Name == "FrmListGroup") // { // ((frmListGroup)form).InitData(); // } //} MessageBox.Show(ConstantInfo.MESSAGE_UPDATE_SUCESSFULLY); } } catch (Exception ex) { logger.Error(ex.ToString()); if (GlobalInfo.IsDebug) { MessageBox.Show(ex.ToString()); } } }
public void AddTotblGroups(tblGroup tblGroup) { AddObject("tblGroups", tblGroup); }
public static tblGroup CreatetblGroup(int groupID, string name, string description) { tblGroup tblGroup = new tblGroup(); tblGroup.GroupID = groupID; tblGroup.Name = name; tblGroup.Description = description; return tblGroup; }
public void DeleteGroup(tblGroup groupToDelete) { _context.tblGroups.Attach(groupToDelete); _context.Entry(groupToDelete).State = EntityState.Deleted; }
public void AddGroup(tblGroup group) { _context.tblGroups.Add(group); }
internal bool CreateGroup(GroupModel objReq) { try { using (var db = new WizzDataContext()) { tblGroup groupObj = new tblGroup(); groupObj = db.tblGroups.FirstOrDefault(x => x.groupId == objReq.groupId); //if (groupData != null) //{ // db.tblGroups.DeleteOnSubmit(groupData); //} if (groupObj == null) { groupObj = new tblGroup(); groupObj.groupName = objReq.groupName; groupObj.fkAdminId = objReq.userId; groupObj.createdDate = DateTime.UtcNow; groupObj.updatedDate = DateTime.UtcNow; groupObj.isActive = true; groupObj.timeSlot = objReq.timeSlot; groupObj.subjectName = objReq.subjectName; groupObj.groupId = objReq.groupId; groupObj.groupPic = objReq.groupPic; db.tblGroups.InsertOnSubmit(groupObj); db.SubmitChanges(); } else { groupObj.groupName = objReq.groupName; groupObj.fkAdminId = objReq.userId; groupObj.createdDate = DateTime.UtcNow; groupObj.updatedDate = DateTime.UtcNow; groupObj.isActive = true; groupObj.timeSlot = objReq.timeSlot; groupObj.subjectName = objReq.subjectName; groupObj.groupId = objReq.groupId; groupObj.groupPic = objReq.groupPic; } List<string> groupMems = new List<string>(); List<tblGroupMember> memObjList = new List<tblGroupMember>(); int groupId = Convert.ToInt32(groupObj.pkId); foreach (string n in objReq.groupMembers) { tblGroupMember memObj = new tblGroupMember(); memObj.fkGroupId = groupId; memObj.fkUserId = Convert.ToInt32(n); memObj.createdDate = DateTime.UtcNow; memObj.updatedDate = DateTime.UtcNow; memObj.isDelete = false; memObjList.Add(memObj); } db.tblGroupMembers.InsertAllOnSubmit(memObjList); db.SubmitChanges(); return true; } } catch (Exception ex) { return false; } }