private void GetClass()
{
using (SampleDataContext db = new SampleDataContext())
{
detail = db.DetailClasses.Where(dc => dc.StudentId == student.StudentId).FirstOrDefault();
}
}
public static DetailClass[] Getdivisi()
{
List <DetailClass> Detail = new List <DetailClass>();
string SelectString = "Select kd_bagian,Nama_Bagian from T_Msdivisi";
con.Open();
SqlCommand cmd = new SqlCommand(SelectString, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dtGetData = new DataTable();
da.Fill(dtGetData);
foreach (DataRow dtRow in dtGetData.Rows)
{
DetailClass DataObj = new DetailClass();
DataObj.kode = dtRow["kd_bagian"].ToString();
DataObj.desc = dtRow["Nama_Bagian"].ToString();
Detail.Add(DataObj);
}
con.Close();
da.Dispose();
dtGetData.Dispose();
//JavaScriptSerializer js = new JavaScriptSerializer();
//string a = js.Serialize(Detail);
return(Detail.ToArray());
}
private void BtnInclude_Click(object sender, EventArgs e)
{
using (SampleDataContext db = new SampleDataContext())
{
if (DGVStudent.SelectedRows.Count > 0)
{
DetailClass detail = db.DetailClasses.Where(dc => dc.StudentId == selectedstudent.StudentId)
.FirstOrDefault();
if (detail == null)
{
db.DetailClasses.InsertOnSubmit(new DetailClass {
ClassName = CbxClass.SelectedItem.ToString(), StudentId = selectedstudent.StudentId
});
db.SubmitChanges();
RefreshDGVStudent();
RefreshDGVParticipate();
}
else if (detail != null)
{
db.DetailClasses.DeleteOnSubmit(detail);
db.DetailClasses.InsertOnSubmit(new DetailClass {
ClassName = CbxClass.SelectedItem.ToString(), StudentId = selectedstudent.StudentId
});
db.SubmitChanges();
RefreshDGVStudent();
RefreshDGVParticipate();
}
}
}
}
public static string GetClass()
{
List <DetailClass> Detail = new List <DetailClass>();
string SelectString = "select Class,Description from T_MsClass";
con.Open();
SqlCommand cmd = new SqlCommand(SelectString, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dtGetData = new DataTable();
da.Fill(dtGetData);
foreach (DataRow dtRow in dtGetData.Rows)
{
DetailClass DataObj = new DetailClass();
DataObj.kode = dtRow["Class"].ToString();
DataObj.desc = dtRow["Description"].ToString();
Detail.Add(DataObj);
}
con.Close();
da.Dispose();
dtGetData.Dispose();
JavaScriptSerializer js = new JavaScriptSerializer();
string a = js.Serialize(Detail);
return(a);
}
public static DetailClass[] GetPartNo(string filter)
{
List <DetailClass> Detail = new List <DetailClass>();
string SelectString = "select distinct PartNo,description from T_InventoryPart where description like '%" + filter + "%'";
con.Open();
SqlCommand cmd = new SqlCommand(SelectString, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dtGetData = new DataTable();
da.Fill(dtGetData);
foreach (DataRow dtRow in dtGetData.Rows)
{
DetailClass DataObj = new DetailClass();
DataObj.kode = dtRow["PartNo"].ToString();
DataObj.desc = dtRow["description"].ToString();
Detail.Add(DataObj);
}
con.Close();
da.Dispose();
dtGetData.Dispose();
//JavaScriptSerializer js = new JavaScriptSerializer();
//string a = js.Serialize(Detail);
return(Detail.ToArray());
}
public static DetailClass[] GetPurchaseGroup(string filter)
{
List <DetailClass> Detail = new List <DetailClass>();
string SelectString = "select PurchaseGroupId,PurchaseGroupDesc from T_MsPurchaseGroup";
con.Open();
SqlCommand cmd = new SqlCommand(SelectString, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dtGetData = new DataTable();
da.Fill(dtGetData);
foreach (DataRow dtRow in dtGetData.Rows)
{
DetailClass DataObj = new DetailClass();
DataObj.kode = dtRow["PurchaseGroupId"].ToString();
DataObj.desc = dtRow["PurchaseGroupDesc"].ToString();
Detail.Add(DataObj);
}
con.Close();
da.Dispose();
dtGetData.Dispose();
//JavaScriptSerializer js = new JavaScriptSerializer();
//string a = js.Serialize(Detail);
return(Detail.ToArray());
}
public void AddObjectDetailArrayAlreadyContainsObjectWithThatKeyExceptionTest()
{
var exception = Xunit.Record.Exception(() =>
{
var arrayOfDetailClass = new DetailArrayOfDetailClass(new MasterClass());
var detail = new DetailClass();
arrayOfDetailClass.Add(detail);
arrayOfDetailClass.Add(detail);
});
Assert.IsType(typeof(DetailArrayAlreadyContainsObjectWithThatKeyException), exception);
}
private bool CheckStudent(Student student)
{
using (SampleDataContext db = new SampleDataContext())
{
DetailClass detailclass = db.DetailClasses.Where(dc => dc.StudentId == student.StudentId)
.FirstOrDefault();
if (detailclass != null)
{
return(true);
}
return(false);
}
}
public void FullClearDataCopyTest()
{
// Входные параметры: объекты данных классов MasterClass и DetailClass.
var obj = new MasterClass();
var detailobj = new DetailClass();
obj.StringMasterProperty = "StringMasterProperty";
obj.DetailClass.Add(detailobj);
obj.IntMasterProperty = 666;
detailobj.Detailproperty = "DetailProperty";
obj.FullClearDataCopy();
// Ожидаемый результат: после очистки, всех данные равны null.
Assert.Null(obj.GetDataCopy());
Assert.Null(detailobj.GetDataCopy());
}
private void BtnExclude_Click(object sender, EventArgs e)
{
using (SampleDataContext db = new SampleDataContext())
{
if (DGVParticipate.SelectedRows.Count > 0)
{
DetailClass detail = db.DetailClasses.Where(dc => dc.StudentId == selectedparticipate.StudentId)
.FirstOrDefault();
db.DetailClasses.DeleteOnSubmit(detail);
db.SubmitChanges();
RefreshDGVParticipate();
RefreshDGVStudent();
}
}
}
public void InsertArgumentOutOfRangeExceptionTest()
{
var exception = Xunit.Record.Exception(() =>
{
var obj = new MasterClass();
// Массив детейловых объектов.
var dArr = new DetailArrayOfDetailClass(obj);
// Детейловый объект.
var дObj1 = new DetailClass()
{
Detailproperty = "первый"
};
dArr.Insert(-1, дObj1);
});
Assert.IsType(typeof(ArgumentOutOfRangeException), exception);
}
public void InsertTest()
{
// Строки, содержащие значения свойств Detailproperty детейловых объектов из массива детейловых объектов до и после вставки.
var expected = string.Empty;
var actual = string.Empty;
// Входной параметр: новый объект класса MasterClass.
var obj = new MasterClass();
// Массив детейловых объектов.
var dArr = new DetailArrayOfDetailClass(obj);
// Детейловые объекты.
var дObj1 = new DetailClass()
{
Detailproperty = "первый"
};
var дObj2 = new DetailClass()
{
Detailproperty = "второй"
};
var objectForInsert = new DetailClass {
Detailproperty = "влез без очереди"
};
dArr.Insert(0, дObj1);
dArr.Insert(1, дObj2);
for (var i = 0; i < 2; i++)
{
expected += dArr[i].Detailproperty;
}
dArr.Insert(1, objectForInsert);
for (var i = 0; i < 2; i++)
{
actual += dArr[i].Detailproperty;
}
// Ожидаемый результат: строки со значениями Детейлproperty различны.
Assert.NotEqual(expected, actual);
}
public static DetailClass[] GetOwner() //GetData function
{
List <DetailClass> Detail = new List <DetailClass>();
string SelectString = "Select UserId from T_MsUser";
con.Open();
SqlCommand cmd = new SqlCommand(SelectString, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dtGetData = new DataTable();
da.Fill(dtGetData);
foreach (DataRow dtRow in dtGetData.Rows)
{
DetailClass DataObj = new DetailClass();
DataObj.kode = dtRow["UserId"].ToString();
DataObj.desc = "";
Detail.Add(DataObj);
}
con.Close();
return(Detail.ToArray());
}
public void InheritanceTest()
{
var masterRoot = new MasterRoot {
MasterAttr = 234
};
var master = new MasterClass {
MasterAttr2 = true, MasterAttr1 = DateTime.Now, MasterRoot = masterRoot
};
var clazz = new MyClass {
MasterClass = master, Attr1 = "abc", Attr2 = 1
};
var derived = new Класс {
MasterClass = master, Attr1 = "123", Attr2 = 55, Атрибут3 = true
};
var detail1 = new DetailClass {
MyClass = clazz, DetailAttr = "def1"
};
var detail2 = new DetailClass {
MyClass = clazz, DetailAttr = "def2"
};
var detailChild = new DetailClass2 {
DetailClass = detail2, DetailAttr2 = "cbd"
};
var objsToUpdate = new DataObject[] { master, clazz, detail1, detail2, derived, masterRoot, detailChild };
DataService.UpdateObjects(ref objsToUpdate, new DataObjectCache(), true);
try
{
DataService.LoadObject(new MasterRoot {
__PrimaryKey = masterRoot.__PrimaryKey
});
}
catch (CantFindDataObjectException)
{
Assert.True(false, "Object not saved.");
}
try
{
DataService.LoadObject(new MasterClass {
__PrimaryKey = master.__PrimaryKey
});
}
catch (CantFindDataObjectException)
{
Assert.True(false, "Object not saved.");
}
try
{
DataService.LoadObject(new MyClass {
__PrimaryKey = clazz.__PrimaryKey
});
}
catch (CantFindDataObjectException)
{
Assert.True(false, "Object not saved.");
}
try
{
DataService.LoadObject(new Класс {
__PrimaryKey = derived.__PrimaryKey
});
}
catch (CantFindDataObjectException)
{
Assert.True(false, "Object not saved.");
}
try
{
DataService.LoadObject(new DetailClass {
__PrimaryKey = detail1.__PrimaryKey
});
}
catch (CantFindDataObjectException)
{
Assert.True(false, "Object not saved.");
}
try
{
DataService.LoadObject(new DetailClass {
__PrimaryKey = detail2.__PrimaryKey
});
}
catch (CantFindDataObjectException)
{
Assert.True(false, "Object not saved.");
}
try
{
DataService.LoadObject(new DetailClass2 {
__PrimaryKey = detailChild.__PrimaryKey
});
}
catch (CantFindDataObjectException)
{
Assert.True(false, "Object not saved.");
}
}
