//create parameter
public void createParameter(proposalchecklistexteriorwallsClass obj, DB_con.DBTrans trans)
{
try
{
obj_con.clearParameter();
obj_con.addParameter("@Buildingid", string.IsNullOrEmpty(Convert.ToString(obj.Buildingid)) ? 0 : obj.Buildingid);
obj_con.addParameter("@Sidewalkbridge", string.IsNullOrEmpty(Convert.ToString(obj.Sidewalkbridge)) ? "" : obj.Sidewalkbridge);
obj_con.addParameter("@Scaffold", string.IsNullOrEmpty(Convert.ToString(obj.Scaffold)) ? "" : obj.Scaffold);
obj_con.addParameter("@Hoist", string.IsNullOrEmpty(Convert.ToString(obj.Hoist)) ? "" : obj.Hoist);
obj_con.addParameter("@Noofdrops", string.IsNullOrEmpty(Convert.ToString(obj.Noofdrops)) ? 0 : obj.Noofdrops);
obj_con.addParameter("@Nooflintels", string.IsNullOrEmpty(Convert.ToString(obj.Nooflintels)) ? 0 : obj.Nooflintels);
obj_con.addParameter("@Qtycaulking", string.IsNullOrEmpty(Convert.ToString(obj.Qtycaulking)) ? "" : obj.Qtycaulking);
obj_con.addParameter("@Dutchmanrepairs", string.IsNullOrEmpty(Convert.ToString(obj.Dutchmanrepairs)) ? "" : obj.Dutchmanrepairs);
obj_con.addParameter("@Nosillsreplacescapped", string.IsNullOrEmpty(Convert.ToString(obj.Nosillsreplacescapped)) ? 0 : obj.Nosillsreplacescapped);
obj_con.addParameter("@Metalpanelreplaced", string.IsNullOrEmpty(Convert.ToString(obj.Metalpanelreplaced)) ? "" : obj.Metalpanelreplaced);
obj_con.addParameter("@Stonereplacement", string.IsNullOrEmpty(Convert.ToString(obj.Stonereplacement)) ? "" : obj.Stonereplacement);
obj_con.addParameter("@Brickreplacement", string.IsNullOrEmpty(Convert.ToString(obj.Brickreplacement)) ? "" : obj.Brickreplacement);
obj_con.addParameter("@Chute", string.IsNullOrEmpty(Convert.ToString(obj.Chute)) ? "" : obj.Chute);
obj_con.addParameter("@Noofwythes", string.IsNullOrEmpty(Convert.ToString(obj.Noofwythes)) ? 0 : obj.Noofwythes);
obj_con.addParameter("@Dumpsters", string.IsNullOrEmpty(Convert.ToString(obj.Dumpsters)) ? "" : obj.Dumpsters);
obj_con.addParameter("@Userid", string.IsNullOrEmpty(Convert.ToString(obj.Userid)) ? 0 : obj.Userid);
obj_con.addParameter("@Inserteddatetime", string.IsNullOrEmpty(Convert.ToString(obj.Inserteddatetime)) ? Convert.ToDateTime("1900-01-01") : obj.Inserteddatetime);
obj_con.addParameter("@Proposalcheckexteriorwallsid", obj.Proposalcheckexteriorwallsid, trans);
}
catch (Exception ex)
{
throw ex;
}
}
//Select Constructor
public proposalchecklistexteriorwallsCtl(Int32 id)
{
obj_con = new ConnectionCls();
proposalchecklistexteriorwallsClass obj_pro = new proposalchecklistexteriorwallsClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_pro.Proposalcheckexteriorwallsid = Convert.ToInt32(dt.Rows[0]["Proposalcheckexteriorwallsid"]);
obj_pro.Buildingid = Convert.ToInt32(dt.Rows[0]["Buildingid"]);
obj_pro.Sidewalkbridge = Convert.ToString(dt.Rows[0]["Sidewalkbridge"]);
obj_pro.Scaffold = Convert.ToString(dt.Rows[0]["Scaffold"]);
obj_pro.Hoist = Convert.ToString(dt.Rows[0]["Hoist"]);
obj_pro.Noofdrops = Convert.ToInt32(dt.Rows[0]["Noofdrops"]);
obj_pro.Nooflintels = Convert.ToInt32(dt.Rows[0]["Nooflintels"]);
obj_pro.Qtycaulking = Convert.ToString(dt.Rows[0]["Qtycaulking"]);
obj_pro.Dutchmanrepairs = Convert.ToString(dt.Rows[0]["Dutchmanrepairs"]);
obj_pro.Nosillsreplacescapped = Convert.ToInt32(dt.Rows[0]["Nosillsreplacescapped"]);
obj_pro.Metalpanelreplaced = Convert.ToString(dt.Rows[0]["Metalpanelreplaced"]);
obj_pro.Stonereplacement = Convert.ToString(dt.Rows[0]["Stonereplacement"]);
obj_pro.Brickreplacement = Convert.ToString(dt.Rows[0]["Brickreplacement"]);
obj_pro.Chute = Convert.ToString(dt.Rows[0]["Chute"]);
obj_pro.Noofwythes = Convert.ToInt32(dt.Rows[0]["Noofwythes"]);
obj_pro.Dumpsters = Convert.ToString(dt.Rows[0]["Dumpsters"]);
obj_pro.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]);
obj_pro.Inserteddatetime = Convert.ToDateTime(dt.Rows[0]["Inserteddatetime"]);
}
}
}
//insert data into database
public Int32 insert(proposalchecklistexteriorwallsClass obj)
{
try
{
obj_con.clearParameter();
createParameter(obj, DBTrans.Insert);
obj_con.BeginTransaction();
obj_con.ExecuteNoneQuery("sp_proposalchecklistexteriorwalls_insert", CommandType.StoredProcedure);
obj_con.CommitTransaction();
return(obj.Proposalcheckexteriorwallsid = Convert.ToInt32(obj_con.getValue("@Proposalcheckexteriorwallsid")));
}
catch (Exception ex)
{
obj_con.RollbackTransaction();
throw new Exception("sp_proposalchecklistexteriorwalls_insert");
}
}
//Convert DataTable To object method
public proposalchecklistexteriorwallsClass ConvertToOjbect(DataTable dt)
{
proposalchecklistexteriorwallsClass obj_proposalchecklistexteriorwalls = new proposalchecklistexteriorwallsClass();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToString(dt.Rows[i]["Proposalcheckexteriorwallsid"]) != "")
{
obj_proposalchecklistexteriorwalls.Proposalcheckexteriorwallsid = Convert.ToInt32(dt.Rows[i]["Proposalcheckexteriorwallsid"]);
}
else
{
obj_proposalchecklistexteriorwalls.Proposalcheckexteriorwallsid = Convert.ToInt32("0");
}
if (Convert.ToString(dt.Rows[i]["Buildingid"]) != "")
{
obj_proposalchecklistexteriorwalls.Buildingid = Convert.ToInt32(dt.Rows[i]["Buildingid"]);
}
else
{
obj_proposalchecklistexteriorwalls.Buildingid = Convert.ToInt32("0");
}
if (Convert.ToString(dt.Rows[i]["Sidewalkbridge"]) != "")
{
obj_proposalchecklistexteriorwalls.Sidewalkbridge = Convert.ToString(dt.Rows[i]["Sidewalkbridge"]);
}
else
{
obj_proposalchecklistexteriorwalls.Sidewalkbridge = Convert.ToString("");
}
if (Convert.ToString(dt.Rows[i]["Scaffold"]) != "")
{
obj_proposalchecklistexteriorwalls.Scaffold = Convert.ToString(dt.Rows[i]["Scaffold"]);
}
else
{
obj_proposalchecklistexteriorwalls.Scaffold = Convert.ToString("");
}
if (Convert.ToString(dt.Rows[i]["Hoist"]) != "")
{
obj_proposalchecklistexteriorwalls.Hoist = Convert.ToString(dt.Rows[i]["Hoist"]);
}
else
{
obj_proposalchecklistexteriorwalls.Hoist = Convert.ToString("");
}
if (Convert.ToString(dt.Rows[i]["Noofdrops"]) != "")
{
obj_proposalchecklistexteriorwalls.Noofdrops = Convert.ToInt32(dt.Rows[i]["Noofdrops"]);
}
else
{
obj_proposalchecklistexteriorwalls.Noofdrops = Convert.ToInt32("0");
}
if (Convert.ToString(dt.Rows[i]["Nooflintels"]) != "")
{
obj_proposalchecklistexteriorwalls.Nooflintels = Convert.ToInt32(dt.Rows[i]["Nooflintels"]);
}
else
{
obj_proposalchecklistexteriorwalls.Nooflintels = Convert.ToInt32("0");
}
if (Convert.ToString(dt.Rows[i]["Qtycaulking"]) != "")
{
obj_proposalchecklistexteriorwalls.Qtycaulking = Convert.ToString(dt.Rows[i]["Qtycaulking"]);
}
else
{
obj_proposalchecklistexteriorwalls.Qtycaulking = Convert.ToString("");
}
if (Convert.ToString(dt.Rows[i]["Dutchmanrepairs"]) != "")
{
obj_proposalchecklistexteriorwalls.Dutchmanrepairs = Convert.ToString(dt.Rows[i]["Dutchmanrepairs"]);
}
else
{
obj_proposalchecklistexteriorwalls.Dutchmanrepairs = Convert.ToString("");
}
if (Convert.ToString(dt.Rows[i]["Nosillsreplacescapped"]) != "")
{
obj_proposalchecklistexteriorwalls.Nosillsreplacescapped = Convert.ToInt32(dt.Rows[i]["Nosillsreplacescapped"]);
}
else
{
obj_proposalchecklistexteriorwalls.Nosillsreplacescapped = Convert.ToInt32("0");
}
if (Convert.ToString(dt.Rows[i]["Metalpanelreplaced"]) != "")
{
obj_proposalchecklistexteriorwalls.Metalpanelreplaced = Convert.ToString(dt.Rows[i]["Metalpanelreplaced"]);
}
else
{
obj_proposalchecklistexteriorwalls.Metalpanelreplaced = Convert.ToString("");
}
if (Convert.ToString(dt.Rows[i]["Stonereplacement"]) != "")
{
obj_proposalchecklistexteriorwalls.Stonereplacement = Convert.ToString(dt.Rows[i]["Stonereplacement"]);
}
else
{
obj_proposalchecklistexteriorwalls.Stonereplacement = Convert.ToString("");
}
if (Convert.ToString(dt.Rows[i]["Brickreplacement"]) != "")
{
obj_proposalchecklistexteriorwalls.Brickreplacement = Convert.ToString(dt.Rows[i]["Brickreplacement"]);
}
else
{
obj_proposalchecklistexteriorwalls.Brickreplacement = Convert.ToString("");
}
if (Convert.ToString(dt.Rows[i]["Chute"]) != "")
{
obj_proposalchecklistexteriorwalls.Chute = Convert.ToString(dt.Rows[i]["Chute"]);
}
else
{
obj_proposalchecklistexteriorwalls.Chute = Convert.ToString("");
}
if (Convert.ToString(dt.Rows[i]["Noofwythes"]) != "")
{
obj_proposalchecklistexteriorwalls.Noofwythes = Convert.ToInt32(dt.Rows[i]["Noofwythes"]);
}
else
{
obj_proposalchecklistexteriorwalls.Noofwythes = Convert.ToInt32("0");
}
if (Convert.ToString(dt.Rows[i]["Dumpsters"]) != "")
{
obj_proposalchecklistexteriorwalls.Dumpsters = Convert.ToString(dt.Rows[i]["Dumpsters"]);
}
else
{
obj_proposalchecklistexteriorwalls.Dumpsters = Convert.ToString("");
}
if (Convert.ToString(dt.Rows[i]["Userid"]) != "")
{
obj_proposalchecklistexteriorwalls.Userid = Convert.ToInt32(dt.Rows[i]["Userid"]);
}
else
{
obj_proposalchecklistexteriorwalls.Userid = Convert.ToInt32("0");
}
if (Convert.ToString(dt.Rows[i]["Inserteddatetime"]) != "")
{
obj_proposalchecklistexteriorwalls.Inserteddatetime = Convert.ToDateTime(dt.Rows[i]["Inserteddatetime"]);
}
else
{
obj_proposalchecklistexteriorwalls.Inserteddatetime = Convert.ToDateTime("01/01/1900");
}
}
return(obj_proposalchecklistexteriorwalls);
}
//update edited object
public proposalchecklistexteriorwallsClass updateObject(proposalchecklistexteriorwallsClass obj)
{
try
{
proposalchecklistexteriorwallsClass oldObj = selectById(obj.Proposalcheckexteriorwallsid);
if (obj.Buildingid == null || obj.Buildingid.ToString().Trim() == "0")
{
obj.Buildingid = oldObj.Buildingid;
}
if (obj.Sidewalkbridge == null || obj.Sidewalkbridge.ToString().Trim() == "update")
{
obj.Sidewalkbridge = oldObj.Sidewalkbridge;
}
if (obj.Scaffold == null || obj.Scaffold.ToString().Trim() == "update")
{
obj.Scaffold = oldObj.Scaffold;
}
if (obj.Hoist == null || obj.Hoist.ToString().Trim() == "update")
{
obj.Hoist = oldObj.Hoist;
}
if (obj.Noofdrops == null || obj.Noofdrops.ToString().Trim() == "0")
{
obj.Noofdrops = oldObj.Noofdrops;
}
if (obj.Nooflintels == null || obj.Nooflintels.ToString().Trim() == "0")
{
obj.Nooflintels = oldObj.Nooflintels;
}
if (obj.Qtycaulking == null || obj.Qtycaulking.ToString().Trim() == "update")
{
obj.Qtycaulking = oldObj.Qtycaulking;
}
if (obj.Dutchmanrepairs == null || obj.Dutchmanrepairs.ToString().Trim() == "update")
{
obj.Dutchmanrepairs = oldObj.Dutchmanrepairs;
}
if (obj.Nosillsreplacescapped == null || obj.Nosillsreplacescapped.ToString().Trim() == "0")
{
obj.Nosillsreplacescapped = oldObj.Nosillsreplacescapped;
}
if (obj.Metalpanelreplaced == null || obj.Metalpanelreplaced.ToString().Trim() == "update")
{
obj.Metalpanelreplaced = oldObj.Metalpanelreplaced;
}
if (obj.Stonereplacement == null || obj.Stonereplacement.ToString().Trim() == "update")
{
obj.Stonereplacement = oldObj.Stonereplacement;
}
if (obj.Brickreplacement == null || obj.Brickreplacement.ToString().Trim() == "update")
{
obj.Brickreplacement = oldObj.Brickreplacement;
}
if (obj.Chute == null || obj.Chute.ToString().Trim() == "update")
{
obj.Chute = oldObj.Chute;
}
if (obj.Noofwythes == null || obj.Noofwythes.ToString().Trim() == "0")
{
obj.Noofwythes = oldObj.Noofwythes;
}
if (obj.Dumpsters == null || obj.Dumpsters.ToString().Trim() == "update")
{
obj.Dumpsters = oldObj.Dumpsters;
}
if (obj.Userid == null || obj.Userid.ToString().Trim() == "0")
{
obj.Userid = oldObj.Userid;
}
if (obj.Inserteddatetime == null || obj.Inserteddatetime == Convert.ToDateTime("1900-01-01"))
{
obj.Inserteddatetime = oldObj.Inserteddatetime;
}
return(obj);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}