public static void SaveNomenclatureHeader(LookUpMetaData nomenclatureHedar)
{
List <LookUpMetaData> rez = new List <LookUpMetaData>(GetAllLookUpSpecific());
rez.Add(nomenclatureHedar);
SerializeUtil.SerializeToXML <List <LookUpMetaData> >(NOMENCLATURENOMENCLATURE, rez);
}
public static IEnumerable <IEnumerable <string> > GetNomenclatureContent(int idnomen)
{
List <List <string> > worker = new List <List <string> >();
LookUpMetaData nomenclatureHedar = GetAllLookUpSpecific().Where(e => e.Id == idnomen).FirstOrDefault();
List <LookUpMetaData> metadata = new List <LookUpMetaData>(GetNomenlatureFields(idnomen));
List <string> fields = new List <string>();
foreach (LookUpMetaData m in metadata)
{
fields.Add(m.Name);
}
worker.Add(fields);
if (nomenclatureHedar != null)
{
List <string> content = new List <string>(LoadContentinlist(nomenclatureHedar.Name + "nomen.xml"));
List <string> row = new List <string>();
int i = 0;
foreach (var current in content)
{
row.Add(current);
i++;
if (i == metadata.Count)
{
worker.Add(row);
row = new List <string>();
i = 0;
}
}
}
return(worker);
}
public static IEnumerable <string> GetLookupByName(string tablename, string fieldname)
{
List <string> result = new List <string>();
LookUpMetaData lookUpMetaData = GetAllLookups(string.Format(" where NAMEENG='{0}'", tablename)).FirstOrDefault();
var dbman = new DBManager(DataProvider.Firebird);
dbman.ConnectionString = Entrence.ConnectionString;
if (lookUpMetaData != null)
{
LookupModel lookupModel = new LookupModel(GetLookUpFields(lookUpMetaData.Id).ToList(), lookUpMetaData);
try
{
dbman.Open();
dbman.ExecuteReader(CommandType.Text, string.Format("select \"{0}\" from \"{1}\" where FIRMAID={2}", fieldname, lookUpMetaData.Tablename, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id));
while (dbman.DataReader.Read())
{
result.Add(dbman.DataReader[fieldname].ToString());
}
}
catch (Exception ex)
{
Logger.Instance().WriteLogError(ex.Message, "public static IEnumerable<string> GetLookupByName(string tablename, string fieldname)");
}
finally
{
dbman.Dispose();
}
}
return(result);
}
public static IEnumerable <LookUpMetaData> GetNomenlatureFields(int numer)
{
List <LookUpMetaData> list = GetAllNomenclatureFields().ToList();
List <LookUpMetaData> result = new List <LookUpMetaData>();
List <LookUpToFields> conector = GetAllConections().Where(e => e.IdLookUpField == numer).ToList();
foreach (var curconector in conector)
{
LookUpMetaData newmetada = list.Where(e => e.Id == curconector.IdLookUp).FirstOrDefault();
result.Add(newmetada);
}
return(result);
}
public static bool DeleteLookUp(LookUpMetaData lookup)
{
bool result = true;
var dbman = new DBManager(DataProvider.Firebird);
dbman.ConnectionString = Entrence.ConnectionString;
try
{
dbman.Open();
dbman.BeginTransaction();
StringBuilder sb = new StringBuilder();
sb.AppendFormat("Delete from \"lookups\" WHERE \"Id\"={0}", lookup.Id);
dbman.ExecuteNonQuery(CommandType.Text, sb.ToString());
sb.Clear();
sb.AppendFormat("Delete from \"lookupsdetails\" WHERE \"IdLookUp\"={0}", lookup.Id);
dbman.ExecuteNonQuery(CommandType.Text, sb.ToString());
sb.Clear();
sb.AppendFormat("DROP TRIGGER \"triger{0}\"", lookup.Tablename);
dbman.ExecuteNonQuery(CommandType.Text, sb.ToString());
sb.Clear();
sb.AppendFormat("DROP GENERATOR GENERATOR{0}", lookup.Tablename.ToUpper());
dbman.ExecuteNonQuery(CommandType.Text, sb.ToString());
sb.Clear();
sb.AppendFormat("Drop table \"{0}\"", lookup.Tablename);
dbman.ExecuteNonQuery(CommandType.Text, sb.ToString());
dbman.CommitTransaction();
}
catch (Exception ex)
{
dbman.RollBackTransaction();
Logger.Instance().WriteLogError(ex.Message, "public static bool DeleteLookUp(LookUpMetaData lookup)");
result = false;
}
finally
{
dbman.Dispose();
}
return(result);
}
public bool DeleteLookUp(LookUpMetaData lookUpMetaData)
{
return(RealDataContext.DeleteLookUp(lookUpMetaData));
}