/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromCamcontactcriteria(ref DataRow row, Camcontactcriteria entity) { row.SetField("fifirstname", entity.fifirstname); row.SetField("cbcontacttype", entity.cbcontacttype); row.SetField("fistate", entity.fistate); row.SetField("fifromzip", entity.fifromzip); row.SetField("filastname", entity.filastname); row.SetField("fipriority", entity.fipriority); row.SetField("fitozip", entity.fitozip); row.SetField("firecordlimit", entity.firecordlimit); row.SetField("cblangcd", entity.cblangcd); row.SetField("fiintuser5", entity.fiintuser5); row.SetField("fiintuser4", entity.fiintuser4); row.SetField("fiintuser3", entity.fiintuser3); row.SetField("fiintuser2", entity.fiintuser2); row.SetField("fiintuser1", entity.fiintuser1); row.SetField("fidecuser5", entity.fidecuser5); row.SetField("fidecuser4", entity.fidecuser4); row.SetField("fidecuser3", entity.fidecuser3); row.SetField("fidecuser2", entity.fidecuser2); row.SetField("fidecuser1", entity.fidecuser1); row.SetField("fidateuser5", entity.fidateuser5); row.SetField("fidateuser4", entity.fidateuser4); row.SetField("fidateuser3", entity.fidateuser3); row.SetField("fidateuser2", entity.fidateuser2); row.SetField("fidateuser1", entity.fidateuser1); row.SetField("ficharuser9", entity.ficharuser9); row.SetField("ficharuser8", entity.ficharuser8); row.SetField("ficharuser7", entity.ficharuser7); row.SetField("ficharuser6", entity.ficharuser6); row.SetField("ficharuser5", entity.ficharuser5); row.SetField("ficharuser4", entity.ficharuser4); row.SetField("ficharuser3", entity.ficharuser3); row.SetField("ficharuser2", entity.ficharuser2); row.SetField("ficharuser10", entity.ficharuser10); row.SetField("ficharuser1", entity.ficharuser1); row.SetField("rsintuser5", entity.rsintuser5); row.SetField("rsintuser4", entity.rsintuser4); row.SetField("rsintuser3", entity.rsintuser3); row.SetField("rsintuser2", entity.rsintuser2); row.SetField("rsintuser1", entity.rsintuser1); row.SetField("rsdecuser5", entity.rsdecuser5); row.SetField("rsdecuser4", entity.rsdecuser4); row.SetField("rsdecuser3", entity.rsdecuser3); row.SetField("rsdecuser2", entity.rsdecuser2); row.SetField("rsdecuser1", entity.rsdecuser1); row.SetField("rsdateuser5", entity.rsdateuser5); row.SetField("rsdateuser4", entity.rsdateuser4); row.SetField("rsdateuser3", entity.rsdateuser3); row.SetField("rsdateuser2", entity.rsdateuser2); row.SetField("rsdateuser1", entity.rsdateuser1); row.SetField("cbloguser5", entity.cbloguser5); row.SetField("cbloguser4", entity.cbloguser4); row.SetField("cbloguser3", entity.cbloguser3); row.SetField("cbloguser2", entity.cbloguser2); row.SetField("cbloguser1", entity.cbloguser1); row.SetField("userfield", entity.userfield); }
public static Camcontactcriteria BuildCamcontactcriteriaFromRow(DataRow row) { Camcontactcriteria entity = new Camcontactcriteria(); entity.fifirstname = row.IsNull("fifirstname") ? string.Empty : row.Field <string>("fifirstname"); entity.cbcontacttype = row.IsNull("cbcontacttype") ? string.Empty : row.Field <string>("cbcontacttype"); entity.fistate = row.IsNull("fistate") ? string.Empty : row.Field <string>("fistate"); entity.fifromzip = row.IsNull("fifromzip") ? string.Empty : row.Field <string>("fifromzip"); entity.filastname = row.IsNull("filastname") ? string.Empty : row.Field <string>("filastname"); entity.fipriority = row.IsNull("fipriority") ? 0 : row.Field <int>("fipriority"); entity.fitozip = row.IsNull("fitozip") ? string.Empty : row.Field <string>("fitozip"); entity.firecordlimit = row.IsNull("firecordlimit") ? 0 : row.Field <int>("firecordlimit"); entity.cblangcd = row.IsNull("cblangcd") ? string.Empty : row.Field <string>("cblangcd"); entity.fiintuser5 = row.IsNull("fiintuser5") ? 0 : row.Field <int>("fiintuser5"); entity.fiintuser4 = row.IsNull("fiintuser4") ? 0 : row.Field <int>("fiintuser4"); entity.fiintuser3 = row.IsNull("fiintuser3") ? 0 : row.Field <int>("fiintuser3"); entity.fiintuser2 = row.IsNull("fiintuser2") ? 0 : row.Field <int>("fiintuser2"); entity.fiintuser1 = row.IsNull("fiintuser1") ? 0 : row.Field <int>("fiintuser1"); entity.fidecuser5 = row.IsNull("fidecuser5") ? decimal.Zero : row.Field <decimal>("fidecuser5"); entity.fidecuser4 = row.IsNull("fidecuser4") ? decimal.Zero : row.Field <decimal>("fidecuser4"); entity.fidecuser3 = row.IsNull("fidecuser3") ? decimal.Zero : row.Field <decimal>("fidecuser3"); entity.fidecuser2 = row.IsNull("fidecuser2") ? decimal.Zero : row.Field <decimal>("fidecuser2"); entity.fidecuser1 = row.IsNull("fidecuser1") ? decimal.Zero : row.Field <decimal>("fidecuser1"); entity.fidateuser5 = row.Field <DateTime?>("fidateuser5"); entity.fidateuser4 = row.Field <DateTime?>("fidateuser4"); entity.fidateuser3 = row.Field <DateTime?>("fidateuser3"); entity.fidateuser2 = row.Field <DateTime?>("fidateuser2"); entity.fidateuser1 = row.Field <DateTime?>("fidateuser1"); entity.ficharuser9 = row.IsNull("ficharuser9") ? string.Empty : row.Field <string>("ficharuser9"); entity.ficharuser8 = row.IsNull("ficharuser8") ? string.Empty : row.Field <string>("ficharuser8"); entity.ficharuser7 = row.IsNull("ficharuser7") ? string.Empty : row.Field <string>("ficharuser7"); entity.ficharuser6 = row.IsNull("ficharuser6") ? string.Empty : row.Field <string>("ficharuser6"); entity.ficharuser5 = row.IsNull("ficharuser5") ? string.Empty : row.Field <string>("ficharuser5"); entity.ficharuser4 = row.IsNull("ficharuser4") ? string.Empty : row.Field <string>("ficharuser4"); entity.ficharuser3 = row.IsNull("ficharuser3") ? string.Empty : row.Field <string>("ficharuser3"); entity.ficharuser2 = row.IsNull("ficharuser2") ? string.Empty : row.Field <string>("ficharuser2"); entity.ficharuser10 = row.IsNull("ficharuser10") ? string.Empty : row.Field <string>("ficharuser10"); entity.ficharuser1 = row.IsNull("ficharuser1") ? string.Empty : row.Field <string>("ficharuser1"); entity.rsintuser5 = row.IsNull("rsintuser5") ? string.Empty : row.Field <string>("rsintuser5"); entity.rsintuser4 = row.IsNull("rsintuser4") ? string.Empty : row.Field <string>("rsintuser4"); entity.rsintuser3 = row.IsNull("rsintuser3") ? string.Empty : row.Field <string>("rsintuser3"); entity.rsintuser2 = row.IsNull("rsintuser2") ? string.Empty : row.Field <string>("rsintuser2"); entity.rsintuser1 = row.IsNull("rsintuser1") ? string.Empty : row.Field <string>("rsintuser1"); entity.rsdecuser5 = row.IsNull("rsdecuser5") ? string.Empty : row.Field <string>("rsdecuser5"); entity.rsdecuser4 = row.IsNull("rsdecuser4") ? string.Empty : row.Field <string>("rsdecuser4"); entity.rsdecuser3 = row.IsNull("rsdecuser3") ? string.Empty : row.Field <string>("rsdecuser3"); entity.rsdecuser2 = row.IsNull("rsdecuser2") ? string.Empty : row.Field <string>("rsdecuser2"); entity.rsdecuser1 = row.IsNull("rsdecuser1") ? string.Empty : row.Field <string>("rsdecuser1"); entity.rsdateuser5 = row.IsNull("rsdateuser5") ? string.Empty : row.Field <string>("rsdateuser5"); entity.rsdateuser4 = row.IsNull("rsdateuser4") ? string.Empty : row.Field <string>("rsdateuser4"); entity.rsdateuser3 = row.IsNull("rsdateuser3") ? string.Empty : row.Field <string>("rsdateuser3"); entity.rsdateuser2 = row.IsNull("rsdateuser2") ? string.Empty : row.Field <string>("rsdateuser2"); entity.rsdateuser1 = row.IsNull("rsdateuser1") ? string.Empty : row.Field <string>("rsdateuser1"); entity.cbloguser5 = row.IsNull("cbloguser5") ? string.Empty : row.Field <string>("cbloguser5"); entity.cbloguser4 = row.IsNull("cbloguser4") ? string.Empty : row.Field <string>("cbloguser4"); entity.cbloguser3 = row.IsNull("cbloguser3") ? string.Empty : row.Field <string>("cbloguser3"); entity.cbloguser2 = row.IsNull("cbloguser2") ? string.Empty : row.Field <string>("cbloguser2"); entity.cbloguser1 = row.IsNull("cbloguser1") ? string.Empty : row.Field <string>("cbloguser1"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }