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;
}
}
