private List <Mobile_User> MapMobile_User(DataTable dt)
{
List <Mobile_User> rs = new List <Mobile_User>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Mobile_User obj = new Mobile_User();
if (dt.Columns.Contains("ID"))
{
obj.ID = new Guid(dt.Rows[i]["ID"].ToString());
}
if (dt.Columns.Contains("IP_Address"))
{
obj.IP_Address = (dt.Rows[i]["IP_Address"].ToString());
}
if (dt.Columns.Contains("MobiName"))
{
obj.MobiName = dt.Rows[i]["MobiName"].ToString();
}
if (dt.Columns.Contains("SeriNumber"))
{
obj.SeriNumber = dt.Rows[i]["SeriNumber"].ToString();
}
if (dt.Columns.Contains("Employee_ID"))
{
obj.Employee_ID = dt.Rows[i]["Employee_ID"].ToString();
}
if (dt.Columns.Contains("OwnerID"))
{
obj.OwnerID = dt.Rows[i]["OwnerID"].ToString();
}
if (dt.Columns.Contains("CreateDate"))
{
obj.CreateDate = DateTime.Parse(dt.Rows[i]["CreateDate"].ToString());
}
if (dt.Columns.Contains("Decription"))
{
obj.Decription = dt.Rows[i]["Decription"].ToString();
}
if (dt.Columns.Contains("Sorted"))
{
obj.Sorted = long.Parse(dt.Rows[i]["Sorted"].ToString());
}
if (dt.Columns.Contains("Active"))
{
obj.Active = bool.Parse(dt.Rows[i]["Active"].ToString());
}
rs.Add(obj);
}
return(rs);
}
public frmChinhSuaThietBi(string ID)
{
InitializeComponent();
gridLookUpEdit1.Properties.DataSource = new EMPLOYEEController().LayDSNhanVien();
gridLookUpEdit1.Properties.DisplayMember = "Employee_Name";
gridLookUpEdit1.Properties.ValueMember = "Employee_ID";
gridLookUpEdit1.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
MobileID = new Guid(ID);
objmobiuser = new Mobile_UserController().Mobile_User_Get(MobileID);
txtIP.Text = objmobiuser.IP_Address;
txtMobileName.Text = objmobiuser.MobiName;
txtSeriNum.Text = objmobiuser.SeriNumber;
dtcreate.DateTime = objmobiuser.CreateDate;
GhiChu.Text = objmobiuser.Decription;
gridLookUpEdit1.EditValue = objmobiuser.Employee_ID;
chkquanli.Checked = objmobiuser.Active;
}
public int Mobile_User_Insert(Mobile_User obj)
{
try
{
return(DataProvider.ExecuteNonquery(DataProvider.ConnectionString, "Mobile_User_Insert",
obj.ID,
obj.IP_Address,
obj.MobiName,
obj.SeriNumber,
obj.Employee_ID,
obj.OwnerID,
obj.CreateDate,
obj.Decription,
obj.Sorted,
obj.Active));
}
catch
{
//throw ex;
return(-1);
}
}
private void simpleButton2_Click(object sender, EventArgs e)
{
int trave = -1;
Mobile_User objmobile = new Mobile_User();
objmobile.ID = Guid.NewGuid();
objmobile.IP_Address = txtIP.Text;
objmobile.MobiName = txtName.Text;
objmobile.Employee_ID = gridLookUpEdit1View.GetRowCellDisplayText(gridLookUpEdit1View.FocusedRowHandle, "Employee_ID");
objmobile.OwnerID = "US000001";
objmobile.Active = true;
objmobile.CreateDate = CreateDate.DateTime;
objmobile.Decription = memoEdit1.Text;
objmobile.SeriNumber = textEdit3.Text;
trave = new Mobile_UserController().Mobile_User_Insert(objmobile);
if (trave > -1)
{
MessageBox.Show("Lưu Thành công", "Thông Báo");
}
else
{
MessageBox.Show("Lưu Thất bại", "Thông Báo");
}
}
