static bool Update(Project_Equipment j)
{
return UpdateByID(j);
}
static bool Delete(Project_Equipment p)
{
pmanAPI.App_Data.pmanDBTableAdapters.Project_EquipmentTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_EquipmentTableAdapter();
return ta.DeleteByID(p.project_id) == 0?false:true;
}
static Project_Equipment LoadFromModel(pmanAPI.App_Data.pmanDB.Project_EquipmentRow row)
{
Project_Equipment d = new Project_Equipment();
LoadProject_Equipment(row, d);
return d;
}
public void Copy(Project_Equipment o)
{
this.project_id = o.project_id;
this.camera_x2 = o.camera_x2;
this.camera_50D = o.camera_50D;
this.lights_650WArri = o.lights_650WArri;
this.lights_300WArri = o.lights_300WArri;
this.lights_softbox = o.lights_softbox;
this.mic_shotgun = o.mic_shotgun;
this.mic_wireliess_lav = o.mic_wireliess_lav;
this.mic_ktec_booms = o.mic_ktec_booms;
this.monitor = o.monitor;
this.tripod_miller = o.tripod_miller;
this.tripod_sachtler = o.tripod_sachtler;
this.cables_coax = o.cables_coax;
this.c_stands = o.c_stands;
this.tape = o.tape;
this.backdrops = o.backdrops;
this.teleprompter = o.teleprompter;
this.steadicam = o.steadicam;
this.switcher = o.switcher;
this.audio_marantz = o.audio_marantz;
this.audio_other = o.audio_other;
this.firestore = o.firestore;
this.battery_dionic = o.battery_dionic;
this.battery_charger = o.battery_charger;
this.battery_aa = o.battery_aa;
this.battery_aaa = o.battery_aaa;
this.battery_9volt = o.battery_9volt;
this.createdate = o.createdate;
this.modifydate = o.modifydate;
}
public bool Equals(Project_Equipment o)
{
if(this.project_id != o.project_id)return false;
if(this.camera_x2 != o.camera_x2)return false;
if(this.camera_50D != o.camera_50D)return false;
if(this.lights_650WArri != o.lights_650WArri)return false;
if(this.lights_300WArri != o.lights_300WArri)return false;
if(this.lights_softbox != o.lights_softbox)return false;
if(this.mic_shotgun != o.mic_shotgun)return false;
if(this.mic_wireliess_lav != o.mic_wireliess_lav)return false;
if(this.mic_ktec_booms != o.mic_ktec_booms)return false;
if(this.monitor != o.monitor)return false;
if(this.tripod_miller != o.tripod_miller)return false;
if(this.tripod_sachtler != o.tripod_sachtler)return false;
if(this.cables_coax != o.cables_coax)return false;
if(this.c_stands != o.c_stands)return false;
if(this.tape != o.tape)return false;
if(this.backdrops != o.backdrops)return false;
if(this.teleprompter != o.teleprompter)return false;
if(this.steadicam != o.steadicam)return false;
if(this.switcher != o.switcher)return false;
if(this.audio_marantz != o.audio_marantz)return false;
if(this.audio_other != o.audio_other)return false;
if(this.firestore != o.firestore)return false;
if(this.battery_dionic != o.battery_dionic)return false;
if(this.battery_charger != o.battery_charger)return false;
if(this.battery_aa != o.battery_aa)return false;
if(this.battery_aaa != o.battery_aaa)return false;
if(this.battery_9volt != o.battery_9volt)return false;
if(this.createdate.ToString() != o.createdate.ToString())return false;
if(this.modifydate.ToString() != o.modifydate.ToString())return false;
return true;
}
public static bool Save(Project_Equipment j)
{
if (!Project_Equipment.isValid(j))
return false;
if (Exists(j))
{
return Project_Equipment.Update(j);
}
return Project_Equipment.Insert(j);
}
public static bool UpdateByID(Project_Equipment o)
{
o.modifydate = DateTime.Now;
pmanAPI.App_Data.pmanDBTableAdapters.Project_EquipmentTableAdapter ta = new pmanAPI.App_Data.pmanDBTableAdapters.Project_EquipmentTableAdapter();
int ret = ta.UpdateByID(
o.camera_x2,
o.camera_50D,
o.lights_650WArri,
o.lights_300WArri,
o.lights_softbox,
o.mic_shotgun,
o.mic_wireliess_lav,
o.mic_ktec_booms,
o.monitor,
o.tripod_miller,
o.tripod_sachtler,
o.cables_coax,
o.c_stands,
o.tape,
o.backdrops,
o.teleprompter,
o.steadicam,
o.switcher,
o.audio_marantz,
o.audio_other,
o.firestore,
o.battery_dionic,
o.battery_charger,
o.battery_aa,
o.battery_aaa,
o.battery_9volt,
o.createdate,
o.modifydate,
o.project_id
);
if(ret == 1) return true;
return false;
}
public static bool Remove(Project_Equipment j)
{
if (Exists(j))
{
return Delete(j);
}
return false;
}
public static void LoadProject_Equipment(pmanAPI.App_Data.pmanDB.Project_EquipmentRow row, Project_Equipment d)
{
try { d.project_id = row.project_id; }
catch (Exception) { }
try { d.camera_x2 = row.camera_x2; }
catch (Exception) { }
try { d.camera_50D = row.camera_50D; }
catch (Exception) { }
try { d.lights_650WArri = row.lights_650WArri; }
catch (Exception) { }
try { d.lights_300WArri = row.lights_300WArri; }
catch (Exception) { }
try { d.lights_softbox = row.lights_softbox; }
catch (Exception) { }
try { d.mic_shotgun = row.mic_shotgun; }
catch (Exception) { }
try { d.mic_wireliess_lav = row.mic_wireliess_lav; }
catch (Exception) { }
try { d.mic_ktec_booms = row.mic_ktec_booms; }
catch (Exception) { }
try { d.monitor = row.monitor; }
catch (Exception) { }
try { d.tripod_miller = row.tripod_miller; }
catch (Exception) { }
try { d.tripod_sachtler = row.tripod_sachtler; }
catch (Exception) { }
try { d.cables_coax = row.cables_coax; }
catch (Exception) { }
try { d.c_stands = row.c_stands; }
catch (Exception) { }
try { d.tape = row.tape; }
catch (Exception) { }
try { d.backdrops = row.backdrops; }
catch (Exception) { }
try { d.teleprompter = row.teleprompter; }
catch (Exception) { }
try { d.steadicam = row.steadicam; }
catch (Exception) { }
try { d.switcher = row.switcher; }
catch (Exception) { }
try { d.audio_marantz = row.audio_marantz; }
catch (Exception) { }
try { d.audio_other = row.audio_other; }
catch (Exception) { }
try { d.firestore = row.firestore; }
catch (Exception) { }
try { d.battery_dionic = row.battery_dionic; }
catch (Exception) { }
try { d.battery_charger = row.battery_charger; }
catch (Exception) { }
try { d.battery_aa = row.battery_aa; }
catch (Exception) { }
try { d.battery_aaa = row.battery_aaa; }
catch (Exception) { }
try { d.battery_9volt = row.battery_9volt; }
catch (Exception) { }
try { d.createdate = row.createdate; }
catch (Exception) { }
try { d.modifydate = row.modifydate; }
catch (Exception) { }
}
public static bool isValid(Project_Equipment o)
{
//if (o.project_id == 0)
// return false;
return true;
}
public static bool Exists(Project_Equipment o)
{
return Exists(o.project_id);
}
public Project_Equipment(Project_Equipment o)
{
Copy(o);
}
