public Result Create(Itemgroup ObjItemgroup)
{
try
{
if (service == null)
{
LogError.log.Error("Service is null");
throw new Exception("Service is null");
}
//lay ve Entity TYPE
QueryExpression query = new QueryExpression("ivg_itemtype");
query.Criteria.AddCondition("ivg_id", ConditionOperator.Equal, ObjItemgroup.Ivg_itemtypeid);
query.ColumnSet = new ColumnSet(true);
EntityCollection entityes= service.RetrieveMultiple(query);
Entity type = entityes.Entities[0];
Entity objEntity = new Entity("ivg_itemgroup");
objEntity.Attributes["ivg_itemtypeid"] = new EntityReference("ivg_itemtype", type.Id);
objEntity.Attributes["ivg_groupid"] = ObjItemgroup.Ivg_groupid;
objEntity.Attributes["ivg_name"] = ObjItemgroup.Ivg_name;
OutIDcheck = new StringBuilder();
if (CheckDuplicateGroupID(service, "ivg_itemgroup", "ivg_groupid", ObjItemgroup.Ivg_groupid, "ivg_groupid"))
{
//update cac truong lien quan neu trung
ColumnSet attributes = new ColumnSet(new string[] { "ivg_groupid", "ivg_itemtypeid", "ivg_itemtypeid", "ivg_name" });
GuidTemp=Guid.Parse(OutIDcheck.ToString());
objEntity = service.Retrieve(objEntity.LogicalName, GuidTemp, attributes);
objEntity.Attributes["ivg_name"] = ObjItemgroup.Ivg_name;
service.Update(objEntity);
OutIDcheck.Clear();
//End Update
return new Result("", true, ObjItemgroup.Ivg_groupid);
}
else
{
Guid EntityID = service.Create(objEntity);
return new Result("", false, EntityID);
}
}
catch (Exception ex)
{
LogError.log.Error(ex.StackTrace);
return new Result(ex.StackTrace, true);
}
}
private void btnRead_Click(object sender, EventArgs e)
{
try
{
if (grDataFile.Rows.Count > 0)
{
errBuilder = new StringBuilder();
foreach (DataGridViewRow row in grDataFile.Rows)
{
if (!row.IsNewRow)
{
Itemgroup ObjItemgroup = new Itemgroup();
ObjItemgroup.Ivg_itemtypeid = row.Cells[0].Value.ToString();
ObjItemgroup.Ivg_item_type = row.Cells[1].Value.ToString();
ObjItemgroup.Ivg_groupid = row.Cells[2].Value.ToString();
ObjItemgroup.Ivg_name = row.Cells[3].Value.ToString();
DAOProcessItemGroup process = new DAOProcessItemGroup();
Result result = process.Create(ObjItemgroup);
if (result.isError)
{
flag = false;
LogError.log.Error(result.BusinessObject.ToString());
errBuilder.Append(result.BusinessObject.ToString());
}
else grDataFile.Rows.Remove(row);
}
}
if (flag == false)
MessageBox.Show("Có lỗi xảy ra trùng ID:\r\n" + errBuilder.ToString() + "\r\nVui lòng kiểm tra lại", "IVG", MessageBoxButtons.OK, MessageBoxIcon.Error);
else
{
MessageBox.Show("Import File thành công", "IVG", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Không thể Import File vui lòng kiểm tra lại", "IVG", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
LogError.log.Error("Error : " + ex.StackTrace);
MessageBox.Show("Có lỗi xảy ra:" + ex.StackTrace, "IVG", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
