private LookupModel GetLookups()
{
var lookupModel = new LookupModel
{ // Example
// Affiliates = this._repo.Db.Affiliates.ToDictionary(x => x.AffiliateId, x => x.Name),
};
return lookupModel;
}
// PUT: api/Lookup/5
public IHttpActionResult Put(HttpRequestMessage request, LookupModel value)
{
if (_log.IsDebugEnabled)
{
_log.DebugFormat("Executing call in debug mode");
}
var headers = request.Headers;
//Check the request object to see if they passed a userId
if (headers.Contains("userid"))
{
var user = headers.GetValues("userid").First();
_log.InfoFormat("Handling PUT request from user: {0}", user);
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
try
{
LookupActions lookupActions = new LookupActions();
lookupActions.Update(value, user);
_log.Debug("Lookup Updated");
return(Ok());
}
catch (Exception e)
{
_log.Error("An error occurred while updating Lookup.", e);
return(InternalServerError(e));
}
}
return(BadRequest("Header value <userid> not found."));
}
public LookupModel PostLookup(LookupModel data)
{
string xml = Helper.XmlSerializer <LookupModel>(data);
using (var context = new SQLContext())
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@data", SqlDbType.Xml);
param[0].Value = xml;
param[1] = new SqlParameter("@userid", SqlDbType.Int);
param[1].Value = 0;
var insert = context.Database.SqlQuery <LookupModel>("s_post_lookups @data, @userid", param);
LookupModel result = insert.FirstOrDefault();
if (result != null)
{
return(result);
}
return(data);
}
}
public bool Create(LookupModel model)
{
try
{
bool isSaved = false;
if (!IsExist(model))
{
using (var db = new HMSEntities())
{
Status entity = new Status();
entity.Name = model.Name;
entity.DepartmentId = model.PerentId;
entity.Description = model.Description;
entity.Sequence = model.Sequence;
entity.IsActive = true;
entity.IsDeleted = false;
entity.CreatedOn = DateTime.Now;
entity.CreatedBy = UserDetailSession.Id;
db.Status.Add(entity);
db.SaveChanges();
isSaved = true;
}
}
return(isSaved);
}
catch (Exception ex)
{
throw ex;
}
}
private void dgv_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex >= 0)
{
if (dgvList.SelectedRows.Count > 0)
{
this.pId = new Guid(dgvList.CurrentRow.Cells[0].Value.ToString());
LookupModel m = service.GetById(LookUp.TPLab, this.pId.Value);
ddlThirdParty.SelectedValue = m.SubPerentId;
txtThirdPartyAmount.Text = Convert.ToString(m.Rate);
}
else
{
MessageBox.Show("Please select row");
}
}
}
catch (Exception ex)
{
Utility.ErrorLog.Logging("Doctor List", ex.Message.ToString(), ex.StackTrace.ToString());
}
}
public bool CheckLookup(List <string> list, LookupModel lookup)
{
return(RealDataContext.CheckLookup(list, lookup));
}
public bool UpdateLookup(LookupModel lookUpMetaData)
{
return(RealDataContext.UpdateLookup(lookUpMetaData));
}
public static bool SaveRow(IEnumerable <string> roww, LookupModel lookup, int firmaId)
{
var dbman = new DBManager(DataProvider.Firebird);
dbman.ConnectionString = Entrence.ConnectionString;
try
{
dbman.Open();
dbman.BeginTransaction();
List <string> row = new List <string>(roww);
//lookup.Fields.Add(new TableField { DbField = "integer", GROUP = 4, Id = 4, Length = 4, IsRequared = false, NameEng = "FIRMAID", Name = "Фирма Номер" });
if (roww != null)
{
if (lookup.Fields[1].DbField == "integer")
{
string cmd = string.Format("Select * from \"{0}\" where \"{1}\"={2} and FIRMAID={3}",
lookup.LookUpMetaData.Tablename, lookup.Fields[1].NameEng, row[1],
firmaId);
var reader = dbman.ExecuteReader(CommandType.Text, cmd);
if (reader.Read())
{
return(false);
}
}
}
dbman.CreateParameters(lookup.Fields.Count - 1);
if (row.Count == lookup.Fields.Count)
{
row[row.Count - 1] = firmaId.ToString();
}
else
{
row.Add(firmaId.ToString());
}
StringBuilder sb = new StringBuilder();
// INSERT INTO "nom_1" ("Id", "Name", "Address", "Telefon")
// VALUES (
//*Id,
//Name,
//Address,
//Telefon
//)
sb.AppendFormat("INSERT INTO \"{0}\" (", lookup.LookUpMetaData.Tablename);
foreach (var field in lookup.Fields)
{
if (field.NameEng != "Id")
{
sb.AppendFormat("\"{0}\",", field.NameEng);
}
}
sb.Remove(sb.Length - 1, 1);
sb.Append(") Values (");
var i = 0;
var k = 0;
foreach (var field in lookup.Fields)
{
if (field != null)
{
if (field.NameEng == "Id")
{
i++;
continue;
}
sb.AppendFormat("@{0},", field.NameEng.Replace(' ', '_'));
if (field.DbField.ToLower() == "integer")
{
dbman.AddParameters(k, "@" + field.NameEng.Replace(' ', '_'),
int.Parse(row.ElementAt(i)));
}
else
{
if (field.DbField.ToLower().Contains("date"))
{
dbman.AddParameters(k, "@" + field.NameEng.Replace(' ', '_'),
DateTime.Parse(row.ElementAt(i)));
}
else
{
if (field.DbField.ToLower().Contains("decimal"))
{
dbman.AddParameters(k, "@" + field.NameEng.Replace(' ', '_'),
decimal.Parse(row.ElementAt(i)));
}
else
{
if (field.DbField == ("CHAR(38)"))
{
dbman.AddParameters(k, "@" + field.NameEng.Replace(' ', '_'),
Guid.NewGuid().ToString());
}
else
{
dbman.AddParameters(k, "@" + field.NameEng.Replace(' ', '_'),
row.ElementAt(i));
}
}
}
}
k++;
i++;
}
}
sb.Remove(sb.Length - 1, 1);
sb.Append(")");
dbman.ExecuteNonQuery(CommandType.Text, sb.ToString());
dbman.CommitTransaction();
}
catch (Exception ex)
{
dbman.RollBackTransaction();
Logger.Instance().WriteLogError(ex.Message, "public static bool SaveRow(IEnumerable<string> roww, LookupModel lookup,int firmaId)");
}
finally
{
dbman.Dispose();
}
return(true);
}
public LookupModule Process(TypeModel model, BeebyteDeobfuscatorPlugin plugin)
{
PluginServices services = PluginServices.For(plugin);
services.StatusUpdate("Creating model for Mono dll");
if (plugin.CompilerType.Value != CppCompilerType.MSVC)
{
throw new System.ArgumentException("Cross compiler deobfuscation has not been implemented yet");
}
MonoDecompiler.MonoDecompiler monoDecompiler = MonoDecompiler.MonoDecompiler.FromFile(plugin.MonoPath);
if (monoDecompiler == null)
{
throw new System.ArgumentException("Could not load unobfuscated application");
}
services.StatusUpdate("Creating LookupModel for obfuscated application");
LookupModule lookupModel = new LookupModule(plugin.NamingRegex);
lookupModel.Init(model.ToLookupModel(statusCallback: services.StatusUpdate), LookupModel.FromModuleDef(monoDecompiler.Module, statusCallback: services.StatusUpdate), statusCallback: services.StatusUpdate);
services.StatusUpdate("Deobfuscating binary");
lookupModel.TranslateTypes(statusCallback: services.StatusUpdate);
plugin.CompilerType = null;
return(lookupModel);
}
private void Calculate()
{
var Context = new TempoDataBaseContext();
var cp = this.DataContext as SaldoItem;
if (cp != null && (cp.Relookup != 0 || cp.RCODELOOKUP != 0))
{
string search = Entrence.ConfigFirmaToLookup.GetField(ConfigTempoSinglenton.GetInstance().CurrentFirma.Id,
cp.Relookup);
List <FieldValuePair> current = new List <FieldValuePair>();
LookupModel lookup = null;
if (cp.Relookup > 0)
{
lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup):Context.GetLookup(cp.Relookup);
}
else
{
lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup) : Context.GetLookup(cp.Relookup);
}
int i = 0;
foreach (var item in lookup.Fields)
{
if (cp.SysLookup && i == 0)
{
i++;
continue;
}
var nf = new FieldValuePair
{
Name = item.Name,
Length = item.Length,
Value = i == 1 && string.IsNullOrWhiteSpace(search)?searcher.Text:"",
ReadOnly = item.NameEng != "Id",
IsRequared = item.IsRequared,
IsUnique = item.IsUnique,
RTABLENAME = item.RTABLENAME,
FieldName = item.NameEng
};
if (item.NameEng == search)
{
nf.Value = searcher.Text;
}
current.Add(nf);
}
LookupsEdidViewModels vmm = new LookupsEdidViewModels(current, lookup.LookUpMetaData.Tablename, true);
EditInsertLookups ds = new EditInsertLookups(vmm);
ds.ShowDialog();
if (ds.DialogResult.HasValue && ds.DialogResult.Value)
{
//nov red
if (!cp.SysLookup)
{
lookup.Fields.Add(new TableField
{
DbField = "integer",
GROUP = 4,
Id = 4,
Length = 4,
IsRequared = false,
NameEng = "FIRMAID",
Name = "Фирма Номер"
});
}
bool sys = cp.SysLookup?!Context.SaveRow(ds.GetNewFields(), lookup):!Context.SaveRow(ds.GetNewFields(), lookup, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id);
if (sys)
{
MessageBoxWrapper.Show(
"Получвава се дублиране на елемент от номенклатура! Номенклатурата не е записана!");
}
else
{
var dc = DataContext as SaldoItem;
var dat = ds.GetNewFields();
if (dat != null)
{
dc.Value = dat[1];
dc.Lookupval = dat[2];
}
if (dat != null && dat.Count > 5)
{
dc.Bulstad = dat[3];
dc.Vat = dat[4];
}
dc.LiD = 0;
OnRefreshExecuted(new FastLookupEventArgs(dc));
}
}
//cp.LookUp.Add(new SaldoItem { Value = ds.GetNewFields()[2], Key = ds.GetNewFields()[1] });
}
}
private void editdialog(bool state)
{
List <FieldValuePair> current = new List <FieldValuePair>();
LookupModel lookup = null;
if (Lookup != null)
{
if ((this.CurrentRowIndex == -1) && state)
{
return;
}
lookup = Context.GetSysLookup(Lookup.Id);
for (var i = 0; i < this.Fields[this.CurrentRowIndex + 1].Count; i++)
{
if (state)
{
current.Add(new FieldValuePair
{
Name = Fields[0][i],
Value = Fields[this.CurrentRowIndex + 1][i],
Length = lookup.Fields[i].Length,
ReadOnly = !(lookup.Fields[i].NameEng == "Id" || lookup.Fields[i].NameEng == "ID"),
IsRequared = lookup.Fields[i].IsRequared,
IsUnique = lookup.Fields[i].IsUnique,
RCODELOOKUP = lookup.Fields[i].RCODELOOKUP,
RFIELDNAME = lookup.Fields[i].RFIELDNAME,
RTABLENAME = lookup.Fields[i].RTABLENAME,
RFIELDKEY = lookup.Fields[i].RFIELDKEY,
Tn = lookup.Fields[i].Tn,
Type = lookup.Fields[i].DbField,
FieldName = lookup.Fields[i].NameEng
});
}
else
{
if (i > 0)
{
current.Add(new FieldValuePair
{
Name = Fields[0][i],
Value = "",
Length = lookup.Fields[i].Length,
ReadOnly =
(lookup.Fields[i].NameEng == "Id" || lookup.Fields[i].NameEng == "ID")
? false
: true,
IsRequared = lookup.Fields[i].IsRequared,
IsUnique = lookup.Fields[i].IsUnique,
RCODELOOKUP = lookup.Fields[i].RCODELOOKUP,
RFIELDNAME = lookup.Fields[i].RFIELDNAME,
RTABLENAME = lookup.Fields[i].RTABLENAME,
RFIELDKEY = lookup.Fields[i].RFIELDKEY,
Tn = lookup.Fields[i].Tn,
Type = lookup.Fields[i].DbField,
FieldName = lookup.Fields[i].NameEng
});
}
}
}
}
else
{
MessageBoxWrapper.Show(Resources.AnaliticManagerViewModel_editdialogres1);
return;
}
LookupsEdidViewModels vm = new LookupsEdidViewModels(current, lookup.LookUpMetaData.Tablename, false);
EditInsertLookups ds = new EditInsertLookups(vm);
ds.ShowDialog();
if (ds.DialogResult.HasValue && ds.DialogResult.Value)
{
if (state)
{
//update
Context.UpdateRowSys(ds.GetNewFields(), lookup);
}
else
{
//nov red
Context.SaveRow(ds.GetNewFields(), lookup);
}
CalculateFields();
OnPropertyChanged("Fields");
OnPropertyChanged("Lookup");
}
}
public static IEnumerable <LookupMethod> ToLookupMethodList(this IList <MethodDef> monoMethods, LookupModel lookupModel)
{
foreach (MethodDef method in monoMethods)
{
yield return(method.ToLookupMethod(lookupModel));
}
}
public static IEnumerable <LookupProperty> ToLookupPropertyList(this ReadOnlyCollection <PropertyInfo> il2cppProperties, LookupModel lookupModel)
{
foreach (PropertyInfo property in il2cppProperties)
{
yield return(property.ToLookupProperty(lookupModel));
}
}
public static IEnumerable <LookupProperty> ToLookupPropertyList(this IList <PropertyDef> monoProperties, LookupModel lookupModel)
{
int i = 0;
foreach (PropertyDef property in monoProperties)
{
yield return(property.ToLookupProperty(i, lookupModel));
i++;
}
}
public static LookupProperty ToLookupProperty(this PropertyDef property, int index, LookupModel lookupModel)
{
if (property == null)
{
return(new LookupProperty(lookupModel));
}
return(new LookupProperty(lookupModel)
{
PropertyType = property.PropertySig.RetType.TryGetTypeDef()?.ToLookupType(lookupModel, false) ?? new LookupType(lookupModel),
GetMethod = property.GetMethod.ToLookupMethod(lookupModel),
SetMethod = property.SetMethod.ToLookupMethod(lookupModel),
Index = index,
MonoProperty = property
});
}
public static IEnumerable <LookupField> ToLookupFieldList(this IList <FieldDef> monoFields, LookupModel lookupModel)
{
foreach (FieldDef field in monoFields)
{
yield return(field.ToLookupField(lookupModel));
}
}
public static IEnumerable <LookupField> ToLookupFieldList(this IReadOnlyCollection <FieldInfo> il2cppFields, LookupModel lookupModel)
{
foreach (FieldInfo field in il2cppFields)
{
yield return(field.ToLookupField(lookupModel));
}
}
public static IEnumerable <LookupType> ToLookupTypeList(this IEnumerable <TypeInfo> il2cppTypes, LookupModel lookupModel, bool recurse = true, EventHandler <string> statusCallback = null)
{
int current = 0;
var filteredTypes = il2cppTypes.Where(t => !t.IsNested);
int total = filteredTypes.Count();
return(filteredTypes
.AsParallel()
.WithDegreeOfParallelism(Math.Max(Environment.ProcessorCount / 2, 1))
.Select(type =>
{
current++;
statusCallback?.Invoke(null, $"Loaded {current}/{total} types...");
return type.ToLookupType(lookupModel, recurse);
}));
}
public int Update(LookupModel lookup)
{
return(_lookup.Delete(lookup));
}
public static IEnumerable <LookupMethod> ToLookupMethodList(this ReadOnlyCollection <MethodInfo> il2cppMethods, LookupModel lookupModel)
{
foreach (MethodInfo method in il2cppMethods)
{
yield return(method.ToLookupMethod(lookupModel));
}
}
public int Create(LookupModel model)
{
return(_context.DOCUS_SYS_ADD_LOOKUP_VALUE(model.Section, model.Type, model.Value));
}
public int Create(LookupModel lookup)
{
return(_lookup.Create(lookup));
}
public static bool UpdateRow(IEnumerable <string> row, LookupModel lookup)
{
List <List <string> > result = new List <List <string> >();
var dbman = new DBManager(DataProvider.Firebird);
dbman.ConnectionString = Entrence.ConnectionString;
try
{
dbman.Open();
dbman.CreateParameters(lookup.Fields.Count);
if (lookup.LookUpMetaData.Tablename == "DDSDNEVSELLSFIELDS" || lookup.LookUpMetaData.Tablename == "DDSDNEVFIELDS")
{
lookup.Fields[0].DbField = "ID";
lookup.Fields[0].NameEng = "ID";
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE \"{0}\" SET ", lookup.LookUpMetaData.Tablename);
foreach (var field in lookup.Fields.Take(lookup.Fields.Count - 1))
{
if (field.NameEng != "ID" || field.NameEng != "Id")
{
sb.AppendFormat("\"{0}\"=@{1},", field.NameEng, field.NameEng.Replace(' ', '_'));
}
}
sb.Remove(sb.Length - 1, 1);
if (lookup.LookUpMetaData.Tablename == "DDSDNEVSELLSFIELDS" || lookup.LookUpMetaData.Tablename == "DDSDNEVFIELDS")
{
sb.AppendFormat(" where \"ID\"={0}", row.ElementAt(0));
}
else
{
sb.AppendFormat(" where \"Id\"={0}", row.ElementAt(0));
}
var i = 0;
foreach (var field in lookup.Fields.Take(lookup.Fields.Count - 1))
{
if (field.DbField.ToLower() == "integer")
{
dbman.AddParameters(i, "@" + field.NameEng.Replace(' ', '_'), int.Parse(row.ElementAt(i)));
}
else
{
if (field.DbField.ToUpper().Contains("DECIMAL"))
{
dbman.AddParameters(i, "@" + field.NameEng.Replace(' ', '_'),
decimal.Parse(row.ElementAt(i)));
}
else
{
if (field.DbField.ToUpper() == ("CHAR(38)"))
{
if (field.Name != "Id" || field.Name != "ID")
{
dbman.AddParameters(i, "@" + field.NameEng.Replace(' ', '_'),
Guid.NewGuid().ToString());
}
}
else
{
if (field.DbField.ToUpper() == ("DATE"))
{
dbman.AddParameters(i, "@" + field.NameEng.Replace(' ', '_'),
DateTime.Parse(row.ElementAt(i)));
}
else
{
dbman.AddParameters(i, "@" + field.NameEng.Replace(' ', '_'), row.ElementAt(i));
}
}
}
}
i++;
}
dbman.ExecuteNonQuery(CommandType.Text, sb.ToString());
}
catch (Exception ex)
{
Logger.Instance().WriteLogError(ex.Message, "public static bool UpdateRow(IEnumerable<string> row, LookupModel lookup)");
}
finally
{
dbman.Dispose();
}
return(true);
}
public IEnumerable <SaldoItem> LoadCreditAnaliticAtributes(IEnumerable <SaldoAnaliticModel> fields, int typecpnto,
TempoDataBaseContext context)
{
List <SaldoItem> saldoItems = new List <SaldoItem>();
foreach (SaldoAnaliticModel analiticalFields in fields)
{
//Titles.Add(analiticalFields.Name);
SaldoItemTypes saldotype = SaldoItemTypes.String;
if (analiticalFields.DBField == "integer")
{
saldotype = SaldoItemTypes.Integer;
}
if (analiticalFields.DBField.Contains("DECIMAL"))
{
saldotype = SaldoItemTypes.Currency;
}
if (analiticalFields.DBField == "Date")
{
saldotype = SaldoItemTypes.Date;
}
SaldoItem saldoItem = new SaldoItem
{
Name = analiticalFields.Name,
Type = saldotype,
Value = analiticalFields.VAL,
Fieldkey = analiticalFields.ACCFIELDKEY,
IsK = typecpnto == 0,
IsD = typecpnto == 1,
Id = analiticalFields.ID,
KursDif = analiticalFields.KURSD,
ValueKurs = analiticalFields.KURS,
MainKurs = analiticalFields.KURSM,
ValueVal = analiticalFields.VALVAL,
ValueCredit = analiticalFields.VALUEMONEY,
Lookupval = analiticalFields.LOOKUPVAL
};
if (analiticalFields.ACCFIELDKEY == 29 || analiticalFields.ACCFIELDKEY == 30 ||
analiticalFields.ACCFIELDKEY == 31)
{
saldoItem.IsDK = true;
if (analiticalFields.ACCFIELDKEY == 30)
{
saldoItem.InfoTitle = "Валутен курс";
saldoItem.IsVal = true;
}
if (analiticalFields.ACCFIELDKEY == 31)
{
saldoItem.InfoTitle = "Единичнa цена";
saldoItem.IsKol = true;
}
}
if (analiticalFields.LOOKUPID != 0)
{
saldoItem.Key = analiticalFields.LOOKUPFIELDKEY.ToString();
saldoItem.IsLookUp = true;
saldoItem.Relookup = analiticalFields.LOOKUPID;
LookupModel lm = context.GetLookup(analiticalFields.LOOKUPID);
var list = context.GetLookup(lm.LookUpMetaData.Tablename,
1);
int k = 0;
foreach (IEnumerable <string> enumerable in list)
{
int i = 0;
SaldoItem saldoitem = new SaldoItem();
saldoitem.Name = saldoItem.Name;
foreach (string s in enumerable)
{
if (i == 2)
{
saldoitem.Value = s;
}
if (i == 1)
{
saldoitem.Key = s;
}
if (k == 0 && i == 1)
{
k++;
}
if (k == 1 && i == 2)
{
k++;
}
i++;
}
saldoItem.LookUp.Add(saldoitem);
saldoItem.SelectedLookupItem =
saldoItem.LookUp.FirstOrDefault(e => e.Value == saldoItem.Value);
}
}
saldoItems.Add(saldoItem);
}
return(saldoItems);
}
public static IEnumerable <LookupType> ToLookupTypeList(this IEnumerable <TypeInfo> il2cppTypes, LookupModel lookupModel, bool recurse = true, EventHandler <string> statusCallback = null)
{
int current = 0;
int total = il2cppTypes.Count(t => !t.IsNested);
foreach (TypeInfo type in il2cppTypes)
{
if (!type.IsNested)
{
current++;
statusCallback?.Invoke(null, $"Loaded {current}/{total} types...");
yield return(type.ToLookupType(lookupModel, recurse));
}
}
}
private void ButtonBase_OnClick(object sender, RoutedEventArgs e)
{
var Context = new TempoDataBaseContext();
var sen = (sender as Button);
if (sen != null)
{
var cp = sen.CommandParameter as SaldoItem;
if (cp != null && (cp.Relookup != 0 || cp.RCODELOOKUP != 0))
{
List <FieldValuePair> current = new List <FieldValuePair>();
LookupModel lookup = null;
if (cp.Relookup > 0)
{
lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup) : Context.GetLookup(cp.Relookup);
}
else
{
lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup) : Context.GetLookup(cp.Relookup);
}
int i = 0;
foreach (var item in lookup.Fields)
{
if (cp.SysLookup && i == 0)
{
i++;
continue;
}
current.Add(new FieldValuePair
{
Name = item.Name,
Value = "",
Length = item.Length,
ReadOnly = (item.NameEng == "Id") ? false : true,
IsRequared = item.IsRequared,
IsUnique = item.IsUnique,
RTABLENAME = item.RTABLENAME,
FieldName = item.NameEng
});
}
LookupsEdidViewModels vmm = new LookupsEdidViewModels(current, lookup.LookUpMetaData.Tablename, true);
EditInsertLookups ds = new EditInsertLookups(vmm);
ds.ShowDialog();
if (ds.DialogResult.HasValue && ds.DialogResult.Value)
{
//nov red
lookup.Fields.Add(new TableField {
DbField = "integer", GROUP = 4, Id = 4, Length = 4, IsRequared = false, NameEng = "FIRMAID", Name = "Фирма Номер"
});
if (!Context.SaveRow(ds.GetNewFields(), lookup, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id))
{
MessageBoxWrapper.Show("Получвава се дублиране на елемент от номенклатура! Номенклатурата не е записана!");
}
else
{
var dc = DataContext as SaldoItem;
var dat = ds.GetNewFields();
if (dat != null)
{
if (dc != null)
{
dc.Value = dat[1];
dc.Lookupval = dat[2];
}
}
if (dat != null && dat.Count > 5)
{
if (dc != null)
{
dc.Bulstad = dat[3];
dc.Vat = dat[4];
}
}
OnRefreshExecuted(new FastLookupEventArgs(dc));
}
}
//cp.LookUp.Add(new SaldoItem { Value = ds.GetNewFields()[2], Key = ds.GetNewFields()[1] });
}
}
}
public bool DeleteRow(List <string> list, LookupModel lookupModel)
{
return(RealDataContext.DeleteRow(list, lookupModel));
}
public bool CreateTable(LookupModel model)
{
return(RealDataContext.CreateTable(model));
}
public static bool SaveRow(IEnumerable <string> roww, LookupModel lookup)
{
var dbman = new DBManager(DataProvider.Firebird);
dbman.ConnectionString = Entrence.ConnectionString;
try
{
dbman.Open();
dbman.BeginTransaction();
List <string> row = new List <string>(roww);
if (roww != null)
{
if (lookup.Fields[1].DbField == "integer")
{
string cmd = string.Format("Select * from \"{0}\" where \"{1}\"={2}}",
lookup.LookUpMetaData.Tablename, lookup.Fields[1].NameEng, row[1]);
var reader = dbman.ExecuteReader(CommandType.Text, cmd);
if (reader.Read())
{
return(false);
}
}
}
dbman.CreateParameters(lookup.Fields.Count - 1);
row.Insert(0, "1");
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO \"{0}\" (", lookup.LookUpMetaData.Tablename);
foreach (var field in lookup.Fields)
{
if (field.NameEng != "Id")
{
sb.AppendFormat("\"{0}\",", field.NameEng);
}
}
sb.Remove(sb.Length - 1, 1);
sb.AppendFormat(") Values (", lookup.LookUpMetaData.Tablename);
var i = 0;
var k = 0;
foreach (var field in lookup.Fields)
{
if (field != null)
{
if (field.NameEng == "Id")
{
i++;
continue;
}
sb.AppendFormat("@{0},", field.NameEng.Replace(' ', '_'));
if (field.DbField.ToLower() == "integer")
{
dbman.AddParameters(k, "@" + field.NameEng.Replace(' ', '_'),
int.Parse(row.ElementAt(i)));
}
else
{
if (field.DbField.ToLower().Contains("date"))
{
dbman.AddParameters(k, "@" + field.NameEng.Replace(' ', '_'),
DateTime.Parse(row.ElementAt(i)));
}
else
{
if (field.DbField.ToLower().Contains("decimal"))
{
dbman.AddParameters(k, "@" + field.NameEng.Replace(' ', '_'),
decimal.Parse(row.ElementAt(i)));
}
else
{
if (field.DbField == ("CHAR(38)"))
{
dbman.AddParameters(k, "@" + field.NameEng.Replace(' ', '_'),
Guid.NewGuid().ToString());
}
else
{
dbman.AddParameters(k, "@" + field.NameEng.Replace(' ', '_'),
row.ElementAt(i));
}
}
}
}
k++;
i++;
}
}
sb.Remove(sb.Length - 1, 1);
sb.Append(")");
dbman.ExecuteNonQuery(CommandType.Text, sb.ToString());
dbman.CommitTransaction();
}
catch (Exception ex)
{
dbman.RollBackTransaction();
Logger.Instance().WriteLogError(ex.Message, "public static bool SaveRow(IEnumerable<string> roww, LookupModel lookup)");
}
finally
{
dbman.Dispose();
}
return(true);
}
public async Task <LookupModel> GetLookup(string keys)
{
using var unitOfWork = UnitOfWorkFactory();
var keyArray = keys?.Split(',');
var result = new LookupModel();
if (string.IsNullOrEmpty(keys))
{
return(new LookupModel
{
Roles = (await unitOfWork.Repository <Role>().GetAllAsync()).Select(_ =>
new DropDownModel <int> {
Key = _.Id, Value = _.Name
}).ToList(),
//
Units = (await unitOfWork.Repository <Unit>().GetAllAsync()).Select(_ =>
new DropDownModel <int> {
Key = _.Id, Value = _.Name
}).ToList(),
//
Statuses = (await unitOfWork.Repository <Status>().GetAllAsync()).Select(_ =>
new DropDownModel <int> {
Key = _.Id, Value = _.Name
}).ToList(),
//
ChangeOfficialDocumentTypes = (await unitOfWork.Repository <ChangeOfficialDocumentType>().GetAllAsync()).Select(_ =>
new DropDownModel <int> {
Key = _.Id, Value = _.Name
}).ToList(),
//
Ratings = (await unitOfWork.Repository <Rating>().GetAllAsync()).Select(_ =>
new DropDownModel <int> {
Key = _.Id, Value = _.Name
}).ToList(),
//
Years = (await unitOfWork.Repository <Year>().GetAllAsync()).Select(_ =>
new DropDownModel <int> {
Key = _.Id, Value = _.Value.ToString()
}).ToList(),
});
}
if (string.IsNullOrEmpty(keys) ||
keyArray.Any(_ => _ == AppDropdownDataType.Roles.ToString()))
{
result.Roles = (await unitOfWork.Repository <Role>().GetAllAsync()).Select(_ =>
new DropDownModel <int> {
Key = _.Id, Value = _.Name
}).ToList();
}
if (string.IsNullOrEmpty(keys) ||
keyArray.Any(_ => _ == AppDropdownDataType.Units.ToString()))
{
result.Units = (await unitOfWork.Repository <Unit>().GetAllAsync()).Select(_ =>
new DropDownModel <int> {
Key = _.Id, Value = _.Name
}).ToList();
}
if (string.IsNullOrEmpty(keys) ||
keyArray.Any(_ => _ == AppDropdownDataType.Statuses.ToString()))
{
result.Statuses = (await unitOfWork.Repository <Status>().GetAllAsync()).Select(_ =>
new DropDownModel <int> {
Key = _.Id, Value = _.Name
}).ToList();
}
if (string.IsNullOrEmpty(keys) ||
keyArray.Any(_ => _ == AppDropdownDataType.ChangeOfficialDocumentTypes.ToString()))
{
result.ChangeOfficialDocumentTypes = (await unitOfWork.Repository <ChangeOfficialDocumentType>().GetAllAsync()).Select(_ =>
new DropDownModel <int> {
Key = _.Id, Value = _.Name
}).ToList();
}
if (string.IsNullOrEmpty(keys) ||
keyArray.Any(_ => _ == AppDropdownDataType.ChangeOfficialDocuments.ToString()))
{
result.ChangeOfficialDocuments = _mapper.Map <IList <ChangeOfficialDocumentModel> >(await unitOfWork.Repository <ChangeOfficialDocument>().GetAllAsync()).ToList();
}
return(result);
}
public bool SaveRow(IEnumerable <string> row, LookupModel lookup)
{
return(RealDataContext.SaveRow(row, lookup));
}
