public void LoadFromObj(COTransmittal oOrg)
{
miID = oOrg.ID;
miProjectID = oOrg.ProjectID;
miReleaseID = oOrg.ReleaseID;
msTransmittalNumber = oOrg.TransmittalNumber;
msProjectClient = oOrg.ProjectClient;
mdtDateTransmittal = oOrg.DateTransmittal;
msProjectTitle = oOrg.ProjectTitle;
msTransmittalTo = oOrg.TransmittalTo;
mbWeTransmitHereWith = oOrg.WeTransmitHereWith;
mbUnderSeperateCover = oOrg.UnderSeperateCover;
mbSentDrawings = oOrg.SentDrawings;
mbSentSpecifications = oOrg.SentSpecifications;
mbSentSchedule = oOrg.SentSchedule;
mbSentBrochure = oOrg.SentBrochure;
mbSentCorrespondence = oOrg.SentCorrespondence;
mbForPreliminary = oOrg.ForPreliminary;
mbForApproval = oOrg.ForApproval;
mbForBidding = oOrg.ForBidding;
mbForConstruction = oOrg.ForConstruction;
mbForNoted = oOrg.ForNoted;
msForNotedOther = oOrg.ForNotedOther;
mbByUSPS = oOrg.ByUSPS;
mbByEmail = oOrg.ByEmail;
mbByOvernight = oOrg.ByOvernight;
mbBySecondDay = oOrg.BySecondDay;
mbByMessenger = oOrg.ByMessenger;
msGeneralDesc = oOrg.GeneralDesc;
msComments = oOrg.Comments;
msPC = oOrg.PC;
msReleasedBy = oOrg.ReleasedBy;
msSentBy = oOrg.SentBy;
}
public void Copy(COTransmittal oNew)
{
oNew.ID = miID;
oNew.ProjectID = miProjectID;
oNew.ReleaseID = miReleaseID;
oNew.TransmittalNumber = msTransmittalNumber;
oNew.ProjectClient = msProjectClient;
oNew.DateTransmittal = mdtDateTransmittal;
oNew.ProjectTitle = msProjectTitle;
oNew.TransmittalTo = msTransmittalTo;
oNew.WeTransmitHereWith = mbWeTransmitHereWith;
oNew.UnderSeperateCover = mbUnderSeperateCover;
oNew.SentDrawings = mbSentDrawings;
oNew.SentSpecifications = mbSentSpecifications;
oNew.SentSchedule = mbSentSchedule;
oNew.SentBrochure = mbSentBrochure;
oNew.SentCorrespondence = mbSentCorrespondence;
oNew.ForPreliminary = mbForPreliminary;
oNew.ForApproval = mbForApproval;
oNew.ForBidding = mbForBidding;
oNew.ForConstruction = mbForConstruction;
oNew.ForNoted = mbForNoted;
oNew.ForNotedOther = msForNotedOther;
oNew.ByUSPS = mbByUSPS;
oNew.ByEmail = mbByEmail;
oNew.ByOvernight = mbByOvernight;
oNew.BySecondDay = mbBySecondDay;
oNew.ByMessenger = mbByMessenger;
oNew.GeneralDesc = msGeneralDesc;
oNew.Comments = msComments;
oNew.PC = msPC;
oNew.ReleasedBy = msReleasedBy;
oNew.SentBy = msSentBy;
}
private void LoadVals(string strXml)
{
XmlSerializer s;
StringReader sr;
s = new XmlSerializer(typeof(COTransmittal));
sr = new System.IO.StringReader(strXml);
oVar = new COTransmittal();
oVar = (COTransmittal)s.Deserialize(sr);
sr.Close();
sr = null;
s = null;
}
public void LoadVals(string strXml)
{
XmlSerializer s;
StringReader sr;
COTransmittal o;
s = new XmlSerializer(typeof(COTransmittal));
sr = new System.IO.StringReader(strXml);
o = new COTransmittal();
o = (COTransmittal)s.Deserialize(sr);
base.LoadFromObj(o);
o = null;
sr.Close();
sr = null;
s = null;
}
public string GetDataString()
{
string tmpStr;
COTransmittal o;
XmlSerializer s;
StringWriter sw;
o = new COTransmittal();
s = new XmlSerializer(typeof(COTransmittal));
sw = new StringWriter();
base.Copy(o);
s.Serialize(sw, o);
tmpStr = sw.ToString();
o = null;
s = null;
sw = null;
return(tmpStr);
}
public string GetByID(int iID)
{
SqlDataReader dr;
RSLib.CDbConnection cnn;
SqlCommand cmd;
SqlParameter prm;
string tmpStr = "";
cnn = new RSLib.CDbConnection();
cmd = new SqlCommand("spTransmittal_ByID", cnn.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
prm = cmd.Parameters.Add("@ID", SqlDbType.Int);
prm.Value = iID;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
oVar = new COTransmittal();
oVar.ID = Convert.ToInt32(dr["ID"]);
oVar.ProjectID = Convert.ToInt32(dr["ProjectID"]);
oVar.ReleaseID = Convert.ToInt32(dr["ReleaseID"]);
oVar.TransmittalNumber = dr["TransmittalNumber"].ToString();
oVar.ProjectClient = dr["ProjectClient"].ToString();
oVar.DateTransmittal = Convert.ToDateTime(dr["DateTransmittal"]);
oVar.ProjectTitle = dr["ProjectTitle"].ToString();
oVar.TransmittalTo = dr["TransmittalTo"].ToString();
oVar.WeTransmitHereWith = Convert.ToBoolean(dr["WeTransmitHereWith"]);
oVar.UnderSeperateCover = Convert.ToBoolean(dr["UnderSeperateCover"]);
oVar.SentDrawings = Convert.ToBoolean(dr["SentDrawings"]);
oVar.SentSpecifications = Convert.ToBoolean(dr["SentSpecifications"]);
oVar.SentSchedule = Convert.ToBoolean(dr["SentSchedule"]);
oVar.SentBrochure = Convert.ToBoolean(dr["SentBrochure"]);
oVar.SentCorrespondence = Convert.ToBoolean(dr["SentCorrespondence"]);
oVar.ForPreliminary = Convert.ToBoolean(dr["ForPreliminary"]);
oVar.ForApproval = Convert.ToBoolean(dr["ForApproval"]);
oVar.ForBidding = Convert.ToBoolean(dr["ForBidding"]);
oVar.ForConstruction = Convert.ToBoolean(dr["ForConstruction"]);
oVar.ForNoted = Convert.ToBoolean(dr["ForNoted"]);
oVar.ForNotedOther = dr["ForNotedOther"].ToString();
oVar.ByUSPS = Convert.ToBoolean(dr["ByUSPS"]);
oVar.ByEmail = Convert.ToBoolean(dr["ByEmail"]);
oVar.ByOvernight = Convert.ToBoolean(dr["ByOvernight"]);
oVar.BySecondDay = Convert.ToBoolean(dr["BySecondDay"]);
oVar.ByMessenger = Convert.ToBoolean(dr["ByMessenger"]);
oVar.GeneralDesc = dr["GeneralDesc"].ToString();
oVar.Comments = dr["Comments"].ToString();
oVar.PC = dr["PC"].ToString();
oVar.ReleasedBy = dr["ReleasedBy"].ToString();
oVar.SentBy = dr["SentBy"].ToString();
tmpStr = GetDataString();
}
dr.Close();
dr = null;
prm = null;
cmd = null;
cnn.CloseConnection();
cnn = null;
return(tmpStr);
}
