private void Load(string id, bool loadExternal)
{
_effId = new EffortID(id);
using (MySqlConnection conn = (MySqlConnection)this.Conn){
MySqlCommand cmd = new MySqlCommand("SELECT * FROM " + _table + " WHERE extId = @extId AND type = @type ORDER BY 1", conn);
cmd.Parameters.Add("@extID", _effId.NumericPart);
cmd.Parameters.Add("@type", _effId.TypeChar.ToString());
conn.Open();
using(MySqlDataReader dr = cmd.ExecuteReader()){
if (dr.HasRows) {
dr.Read();
this.Load(dr);
SetId(_id); // Load internal id after load since we are using external id for load.
}else{
// No data in private DB so create entry corresponding to external db
this._extId = _effId.NumericPart;
MarkNew();
}
}
}
if (loadExternal){
LoadExternal();
}
}
public Effort(string id, bool loadExternal)
{
_effId = new EffortID(id);
if (_effId.Type == EffortType.Undetermined || _effId.Type == EffortType.InValid) {
throw new Exception("Effort Id is in the wrong format. Correct format: P05431 or T10210");
}else{
Setup();
this.Load(_effId.ToString(), loadExternal);
}
}
public void Load(MySqlDataReader dr)
{
Setup();
SetId(Convert.ToInt32(dr["Id"]));
_extId = Convert.ToInt32(dr["extId"]);
this._effId = new EffortID(dr["type"].ToString() + _extId);
_testedBy = Convert.ToString(dr["testedBy"]);
_approved = Convert.ToBoolean(dr["approved"]);
_pmResource = Convert.ToString(dr["pmResource"]);
_webResource = Convert.ToString(dr["webResource"]);
_dbResource = Convert.ToString(dr["dbResource"]);
_uatApproved = Convert.ToBoolean(dr["uatApproved"]);
_projectManager = Convert.ToString(dr["pmResource"]);
_maxResource = Convert.ToString(dr["maxResource"]);
_uatApprovedBy = Convert.ToString(dr["uatApprovedBy"]);
_branchFileHierarchy = Convert.ToString(dr["branchFileHierarchy"]);
_environment = Convert.ToString(dr["environment"]);
if (Convert.ToChar(dr["type"]) == 'P')
_effType = EffortType.Project;
if (Convert.ToChar(dr["type"]) == 'T')
_effType = EffortType.Ticket;
this._desc = Convert.ToString(dr["desc_"]);
_requester = Convert.ToString(dr["requestor"]);
MarkOld();
}
