public static List <PenjaminanDataset.m_picRow> selectPICFK(decimal fk)
{
PenjaminanDatasetTableAdapters.m_picTableAdapter ta = new PenjaminanDatasetTableAdapters.m_picTableAdapter();
PenjaminanDataset.m_picDataTable dt = new PenjaminanDataset.m_picDataTable();
List <PenjaminanDataset.m_picRow> picLIst = new List <PenjaminanDataset.m_picRow>();
try
{
ta.FillByFKMitra(dt, fk);
if (dt.Count > 0)
{
for (int i = 0; i < dt.Count; i++)
{
picLIst.Add(dt[i]);
}
}
return(picLIst);
}
catch (Exception ex)
{
throw new ApplicationException("Failed to load Employee data : " + ex.Message);
}
}
public static void Delete(int id)
{
PenjaminanDatasetTableAdapters.m_picTableAdapter ta = new PenjaminanDatasetTableAdapters.m_picTableAdapter();
PenjaminanDataset.m_picDataTable dt = ta.GetDataByFKMitra(Convert.ToDecimal(id));
try
{
ta.softDelete(1, id);
}
catch (Exception ex)
{
throw new ApplicationException("Failed to load Employee data : " + ex.Message);
}
}
public static void insertData(List <Object.Pic> b, int idMitra)
{
PenjaminanDatasetTableAdapters.m_picTableAdapter ta = new PenjaminanDatasetTableAdapters.m_picTableAdapter();
foreach (var data in b)
{
try
{
if (data.id != 0)
{
int newID = data.id;
PenjaminanDatasetTableAdapters.m_picTableAdapter taX = new PenjaminanDatasetTableAdapters.m_picTableAdapter();
PenjaminanDataset.m_picDataTable dt = taX.GetDataPicByID(newID);
try
{
if (dt != null)
{
ta.UpdateQuery(data.name, data.jabatan, 2, DateTime.Now, data.noTelepon, data.id);
idMitra = data.fk_mitra;
}
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message, ex);
}
}
else
{
ta.InsertPIC(idMitra, data.name, data.jabatan, 1, DateTime.Now, 1, DateTime.Now, 0, data.noTelepon, data.email);
}
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message, ex);
}
}
}
