public ActionResult GetEditItemById(int id, int idTable)
{
var db = new TableDal();
var result = db.GetEmpById(1, idTable, id);
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
//public ActionResult _EditEmp(int id,string name, string DOB, string Gender, string Email, string Mobile, string Address)
//{
// var db = new TableDal();
// Employee emp = new Employee();
// emp.name = name;
// emp.DOB = DateTime.Parse(DOB);
// emp.Gender = Gender;
// emp.Address = Address;
// emp.Email = Email;
// emp.Mobile = Mobile;
// var result = db.UpdateEmpById(1,1,id, emp);
// return Content(JsonConvert.SerializeObject(new
// {
// result
// }));
//}
//public ActionResult _AddEmp(string name, string DOB,string Gender,string Email,string Mobile,string Address)
//{
// var db = new TableDal();
// Employee emp = new Employee();
// emp.name = name;
// emp.DOB = DateTime.Parse(DOB);
// emp.Gender = Gender;
// emp.Address = Address;
// emp.Email = Email;
// emp.Mobile = Mobile;
// emp.JoiningDate = DateTime.Now.ToString("yyyy/MM/dd");
// emp.DepartmentID = 1;
// emp.DesignationID = 1;
// var result = db.AddEmp(1, 1, emp);
// return Content(JsonConvert.SerializeObject(new
// {
// result
// }));
//}
public ActionResult DeleteEmp(int id, int idTable)
{
var db = new TableDal();
var result = db.DeleteEmp(1, idTable, id);
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public void GetTables()
{
//Arrange
var mockHelper = MockRepository.GenerateMock <IDalHelper>();
mockHelper.Stub(x => x.RetrieveList(
Arg <DalHelperModel <TableModel> > .Is.Anything
)).Return(new List <TableModel>
{
new TableModel()
});
var mapperStub = MockRepository.GenerateStub <ITableMapper>();
var tableDal = new TableDal(mapperStub, mockHelper);
//Act
var dalResponse = tableDal.GetTables(_connectionString);
//Assert
Assert.IsFalse(dalResponse.HasError);
Assert.IsNotNull(dalResponse.Result);
}
/// <summary>
/// 获取数据库表的信息
/// </summary>
/// <param name="connectionString"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public static DataTable GetDBTableInfo(string connectionString, string tableName)
{
return(TableDal.GetDBTableInfo(connectionString, tableName));
}
/// <summary>
/// 获取数据库表的名称集合
/// </summary>
/// <param name="connectionString"></param>
/// <returns></returns>
public static List <string> GetDBTableNameList(string connectionString)
{
return(TableDal.GetDBTableNameList(connectionString));
}
