public int Insert()
 {
     int nResult = 0;
     cProductAndFile objInfor = new cProductAndFile();
     try
     {
         objInfor.AddNew();
         this.MappingData(objInfor);
         objInfor.Save();
         nResult = objInfor.ProductFileUploadID ;
     }
     catch
     {
         nResult = 0;
     }
     return nResult;
 }
 public int DeleteById(int ID)
 {
     int nResult = 0;
     cProductAndFile objDAL = new cProductAndFile();
     try
     {
         objDAL.LoadByPrimaryKey(ID);
         objDAL.MarkAsDeleted();
         objDAL.Save();
         nResult = ID;
     }
     catch
     {
         nResult = 0;
     }
     return nResult;
 }
 public int Update(int ID)
 {
     int nResult = 0;
     cProductAndFile objInfor = new cProductAndFile();
     try
     {
         objInfor.LoadByPrimaryKey(ID);
         this.MappingData(objInfor);
         objInfor.Save();
         nResult = ID;
     }
     catch
     {
         nResult = 0;
     }
     return nResult;
 }
 public DataTable SearchProductFile(int ProductID)
 {
     DataTable tbResult = new DataTable();
     cProductAndFile objDAL = new cProductAndFile();
     tbResult = objDAL.SearchProductFile(ProductID);
     return tbResult;
 }
 public void LoadById(int ID)
 {
     cProductAndFile objDAL = new cProductAndFile();
     objDAL.LoadByPrimaryKey(ID);
     ConvertData(objDAL);
 }
 private void MappingData(cProductAndFile objInfor)
 {
     try { objInfor.ProductFileID = Data.ProductFileID; }
     catch { objInfor.ProductFileID = 0; }
     try { objInfor.ProductID = Data.ProductID; }
     catch { objInfor.ProductID = 0; }
 }
 private void ConvertData(cProductAndFile objInfor)
 {
     try { Data.ProductFileID = objInfor.ProductFileID; }
     catch { Data.ProductFileID = 0; }
     try { Data.ProductID = objInfor.ProductID; }
     catch { Data.ProductID = 0; }
 }