public bool Action(string HID, string ReportCode, string ReportName, string Condition1, string Condition2,
string Condition3, string Condition4, string ImportFolder, string BackUpFolder, string LogFolder,
string OutputFolder, bool rowState, string UserLogin, PAction action)
{
dt = SourceFile_MappingHeaderDto.Data();
dr = dt.NewRow();
dr["HID"] = HID;
dr["ReportCode"] = ReportCode;
dr["ReportName"] = ReportName;
dr["Condition1"] = Condition1;
dr["Condition2"] = Condition2;
dr["Condition3"] = Condition3;
dr["Condition4"] = Condition4;
dr["ImportFolder"] = ImportFolder;
dr["BackUpFolder"] = BackUpFolder;
dr["LogFolder"] = LogFolder;
dr["OutputFolder"] = OutputFolder;
dr["ROW_STATE"] = rowState ? "1" : "0";
dr["CREATE_BY"] = UserLogin;
dr["UPDATE_BY"] = UserLogin;
dt.Rows.Add(dr);
switch (action)
{
case PAction.Add: isCan = Add(); break;
case PAction.Update: isCan = Update(); break;
case PAction.Delete: isCan = Delete(); break;
}
return(isCan);
}
public override DataTable FindByColumn(object dto)
{
dt = SourceFile_MappingHeaderDto.Data();
dr = dt.NewRow();
dr["Name"] = "";
return(dao.FindByColumn(dt));
}
public DataSet FindHeaderAndDetailPK(object dto)
{
dt = SourceFile_MappingHeaderDto.Data();
dr = dt.NewRow();
dr["HID"] = "1";
dt.Rows.Add(dr);
return(dao.FindHeaderAndDetailPK(dt));
}
/// <summary>
/// active =1 /0 if active is empty then show all
/// </summary>
/// <param name="name"></param>
/// <param name="active"></param>
/// <returns></returns>
public DataTable FindByColumn(string name, string active)
{
dt = SourceFile_MappingHeaderDto.Data();
dr = dt.NewRow();
dr["ReportName"] = name;
dr["ROW_STATE"] = active;
dt.Rows.Add(dr);
return(dao.FindByColumn(dt));
}
public DataSet FindHeaderAndDetailPK(string HID, string userName)
{
dt = SourceFile_MappingHeaderDto.Data();
dr = dt.NewRow();
dr["HID"] = HID;
dr["UPDATE_BY"] = userName;
dt.Rows.Add(dr);
return(dao.FindHeaderAndDetailPK(dt));
}
public override DataTable FindByAll()
{
isCan = false;
DataTable dtObj = null;
try
{
DataTable dt = SourceFile_MappingHeaderDto.Data();
DataRow dr = dt.NewRow();
dr["ROW_STATE"] = "1";
dt.Rows.Add(dr);
OpenConection();
dtObj = ExcecuteToDataTable("sp_SourceFile_MappingHeader_FindAll", dt);
}
catch (Exception ex)
{ throw ex; }
finally
{ CloseConnection(); }
return(dtObj);
}