public async Task <bool> Handle(CreateSubsidiaryCommand request, CancellationToken cancellationToken) { if (Guid.TryParse(request.FiefId, out Guid id)) { var fief = await _context.Fiefs.FindAsync(id); var subsidiary = new Subsidiary { Fief = fief, SubsidiaryTypeId = request.SubsidiaryTypeId, Quality = request.Quality, IsBeingDeveloped = false }; fief.Industries.Add(subsidiary); await _context.SaveChangesAsync(cancellationToken); return(true); throw new CustomException($"CreateSubsidiaryCommand >> Unauthorized!"); } throw new CustomException($"CreateSubsidiaryCommand >> Could not parse FiefId({request.FiefId})."); }
public void SetSubsidiary(Employee employee, Subsidiary subsidiary) { if (subsidiary != null) { employee.Subsidiary = subsidiary.Id; } }
public static List <Subsidiary> GetSubsidiary() { var dbUtil = new DatabaseManager(); var subsidiaries = new List <Subsidiary>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spDisGetPCFSubsidiary"; cmd.CommandTimeout = 180; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var subsidiary = new Subsidiary { SubsidiaryID = ReferenceEquals(reader["intSubsidiaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSubsidiaryID"]), Code = ReferenceEquals(reader["strCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCode"]), Description = ReferenceEquals(reader["strDescription"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strDescription"]), COAID = ReferenceEquals(reader["intCOAID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intCOAID"]) }; subsidiaries.Add(subsidiary); } return(subsidiaries); } } } }
private void btnCreateSubMarket_Click(object sender, EventArgs e) { try { if (string.IsNullOrWhiteSpace(txtFlialNAme.Text)) { MessageBox.Show("Zəhmıət olmasa Filialin adını daxil edin!!"); return; } ComboItem selectedMarket = cmbMarket.SelectedItem as ComboItem; var subsidiary = db.Subsidiary.Any(w => w.Subsidiary1 == txtFlialNAme.Text && w.DeletedDate == null && w.MarketId == selectedMarket.value); if (subsidiary) { MessageBox.Show("Bu adda Filial var"); return; } Subsidiary newFilial = new Subsidiary(); newFilial.MarketId = selectedMarket.value; newFilial.Subsidiary1 = txtFlialNAme.Text.ToUpper(); newFilial.CreatedDate = DateTime.Now; db.Subsidiary.Add(newFilial); db.SaveChanges(); dgvSubsidaryList(); } catch (Exception ex) { MessageBox.Show("Please, check again after some minutes!! "); File.AppendAllText(pathTxt, "\n" + ex + ":" + DateTime.Now); } }
public static List <Subsidiary> GetBPREntryLedgerSubsidiary(string criteria, int coaid) { var dbUtil = new DatabaseManager(); var subsidiaries = new List <Subsidiary>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spDisBPRGet_Subsidiary"; cmd.CommandTimeout = 180; cmd.Parameters.AddWithValue("@strCriteria", criteria); cmd.Parameters.AddWithValue("@intCOAID", coaid); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var subsidiary = new Subsidiary { SubsidiaryID = ReferenceEquals(reader["intSubsidiaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSubsidiaryID"]), Description = ReferenceEquals(reader["strDescription"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strDescription"]), HasIndividualSubsidiary = ReferenceEquals(reader["blnHasIndividualSubsidiary"], DBNull.Value) ? 0 : Convert.ToInt32(reader["blnHasIndividualSubsidiary"]) }; subsidiaries.Add(subsidiary); } } } } return(subsidiaries); }
public double GetAggregatedPriceForSubsidiary(Subsidiary subsidiary) { var group = new BsonDocument("$group", new BsonDocument { { "_id", "$InSubsidiary" }, { "Price", new BsonDocument("$sum", "$Price") } } ); try { var aggregation = this.Collection.Aggregate() .AppendStage <BsonDocument>(group) .Match(Builders <BsonDocument> .Filter.Eq("_id", subsidiary.Id)).First() .AsBsonDocument; return(aggregation["Price"].AsDouble); } catch (InvalidOperationException) { return(0); } }
public ActionResult DeleteConfirmed(string id) { Subsidiary subsidiary = db.Subsidiaries.Find(id); db.Subsidiaries.Remove(subsidiary); db.SaveChanges(); return(RedirectToAction("Index")); }
public Subsidiary ToSubsidiary() { var subsidiary = new Subsidiary(); subsidiary.Id = SubsidiaryId; subsidiary.SubsidiaryName = SubsidiaryName; return(subsidiary); }
public static bool ForTernaryOperator(int index, Word[] words, ref Span span, ref List <int> colons) { if (words[index].Text == Data.QUESTION_MARK.Text && NextColonIndex(index, words, ref colons)) { Subsidiary.AddOperator(words[index], Data.ConditionalOperatorsColor, ref span); return(true); } return(false); }
public static bool For_DO(Word word, ref Span span) { if (word.Text == Data.DO.Text) { Subsidiary.SelectOperator(word, Data.ConditionalOperatorsColor, ref span); return(true); } return(false); }
public Disney(string title, string description, string audinceRating, double rating, double length, Subsidiary company, Type type) { Title = title; Description = description; MaturityRating = audinceRating; StarRating = rating; LengthInMinutes = length; Company = company; ContentType = type; }
public IHttpActionResult GetHeadQuarter(int key) { Subsidiary sub = ModelBase.Oscorp.SubSidiaries.SingleOrDefault(s => s.SubId == key); if (sub.HeadQuarter == null) { return(NotFound()); } return(Ok(sub.HeadQuarter)); }
public ActionResult Edit([Bind(Include = "CompanyID,SubsiID,SubType,SubPercent,DirectRel,UpdateDate,ChangeDate,NoShares_YN")] Subsidiary subsidiary) { if (ModelState.IsValid) { db.Entry(subsidiary).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CompanyID = new SelectList(db.CompanyNames, "CompanyID", "ExchangeCode", subsidiary.CompanyID); ViewBag.SubType = new SelectList(db.SubsidiariesTypes, "SubType", "Description", subsidiary.SubType); return(View(subsidiary)); }
public IHttpActionResult DeleteRef(int key, string navigationProperty) { if (navigationProperty != "HeadQuarter") { return(NotFound()); } Subsidiary sub = ModelBase.Oscorp.SubSidiaries.SingleOrDefault(s => s.SubId == key); sub.HeadQuarter = null; return(Ok()); }
public static bool InWordOperatorsWithBrackets(Word word, ref Span span) { foreach (string @operator in Operators.WordWithBrackets) { if (word.Text == @operator) { Subsidiary.AddOperator(word, Data.OtherOperatorsColor, ref span); return(true); } } return(false); }
public static bool InSingleWordsOperators(Word word, ref Span span) { foreach (string @operator in Operators.SingleWords) { if (word.Text == @operator + Data.SEMICOLON.Text) { Subsidiary.AddOperator(word, Data.OtherOperatorsColor, ref span); return(true); } } return(false); }
public async Task <IActionResult> Post([FromBody] Subsidiary model) { model.Validate(); if (model.Invalid) { return(BadRequest(model.Notifications)); } await _repository.Add(model); return(Ok()); }
// GET: Subsidiaries/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Subsidiary subsidiary = db.Subsidiaries.Find(id); if (subsidiary == null) { return(HttpNotFound()); } return(View(subsidiary)); }
public static bool ForSquareBrackets(Word word, ref Span span) { if (word.Text == "[") { Subsidiary.AddOperator(word, Data.OtherOperatorsColor, ref span); return(true); } if (word.Text == "]") { Subsidiary.SelectOperator(word, Data.OtherOperatorsColor, ref span); return(true); } return(false); }
public static bool InSymbolicOperators(Word word, ref Span span) { foreach (string[] operators in Operators.Symbolic) { foreach (string @operator in operators) { if (word.Text == @operator) { Subsidiary.AddOperator(word, Data.OtherOperatorsColor, ref span); return(true); } } } return(false); }
// GET: Subsidiaries/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Subsidiary subsidiary = db.Subsidiaries.Find(id); if (subsidiary == null) { return(HttpNotFound()); } ViewBag.CompanyID = new SelectList(db.CompanyNames, "CompanyID", "ExchangeCode", subsidiary.CompanyID); ViewBag.SubType = new SelectList(db.SubsidiariesTypes, "SubType", "Description", subsidiary.SubType); return(View(subsidiary)); }
public bool PutClient(Company client, EngineContext context, IEngineLogical funcion) { bool resultado = false; try { using (context) { Company C = context.Company.Where(x => x.Id == client.Id).FirstOrDefault(); if (C != null) { C.NameCompany = client.NameCompany; C.BusinessBranch = client.BusinessBranch; C.Email = client.Email; C.Phone = client.Phone; C.AnnualGross = client.AnnualGross; C.TypeCompany = funcion.TypeCompany(client.AnnualGross); context.Company.Attach(C); context.SaveChanges(); if (client.Subsidiary.Count > 0) { foreach (Subsidiary item in client.Subsidiary) { Subsidiary S = context.Subsidiary.Where(s => s.Id == item.Id).FirstOrDefault(); if (S != null) { S.NameSubsidiary = item.NameSubsidiary; S.Email = item.Email; S.Phone = item.Phone; S.AnnualGross = item.AnnualGross; S.TypeSubsidiary = funcion.TypeSubsidiary(item.AnnualGross); context.Subsidiary.Attach(S); context.SaveChanges(); } } } } } } catch { } return(resultado); }
public static List <Subsidiary> GetFormSubsidiary(int branchID, string criteria) { var dbUtil = new DatabaseManager(); var payees = new List <Subsidiary>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spDisGetPCFFormSubsidiary"; cmd.CommandTimeout = 180; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@intIDMasLocation", branchID); cmd.Parameters.AddWithValue("@strCriteria", criteria); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var payee = new Subsidiary { SubsidiaryID = ReferenceEquals(reader["intSubsidiaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSubsidiaryID"]), Code = ReferenceEquals(reader["strCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCode"]), Description = ReferenceEquals(reader["strDescription"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strDescription"]), COAID = ReferenceEquals(reader["intCOAID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intCOAID"]), COAName = ReferenceEquals(reader["strCOAName"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCOAName"]), HasIndividualSubsidiary = ReferenceEquals(reader["blnHasIndividualSubsidiary"], DBNull.Value) ? 0 : Convert.ToInt32(reader["blnHasIndividualSubsidiary"]) }; payees.Add(payee); } return(payees); } } } }
public static bool CompareWithConditionalOperators(Word word, ref Span span, int lineNumber) { if (Subsidiary.ConditionalCompare(word, Data.IF.Text, ref span, lineNumber) || Subsidiary.ConditionalCompare(word, Data.SWITCH.Text, ref span, lineNumber) || Subsidiary.ConditionalCompare(word, Data.FOR.Text, ref span, lineNumber) || Subsidiary.ConditionalCompare(word, Data.WHILE.Text, ref span, lineNumber)) { return(true); } if (word == Data.ELSE.Text) { Subsidiary.SelectOperator(word, Data.ConditionalOperatorsColor, ref span); return(true); } if (word == Data.ELSEIF.Text) { Subsidiary.SelectOperator(Data.ELSEIF.Text, Data.ConditionalOperatorsColor, ref span); return(true); } return(false); }
public static List <Subsidiary> GetSubsidiary(int coaID, int branchID) { var dbUtil = new DatabaseManager(); var subsidiaries = new List <Subsidiary>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spAccGLGetCOASubsidiary"; cmd.CommandTimeout = 180; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@intIDMasCOA", coaID); cmd.Parameters.AddWithValue("@intIDMasLocation", branchID); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var subsidiary = new Subsidiary { SubsidiaryID = ReferenceEquals(reader["intSubsidiaryID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSubsidiaryID"]), Code = ReferenceEquals(reader["strCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCode"]), Description = ReferenceEquals(reader["strDescription"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strDescription"]) }; subsidiaries.Add(subsidiary); } return(subsidiaries); } } } }
// POST api/<controller> public void Post([FromBody] Subsidiary value) { }
private void OnSubsidiarySearchOnEntityChanged(Subsidiary x) { this.Model.Employees.SetSubsidiary(this.Entity, x); }
// PUT api/<controller>/5 public void Put(int id, [FromBody] Subsidiary value) { }
private static void SearchForAllOperatorsInLineWithoutQuotes(Word[] words, int lineNumber, ref Span span) { MakeGapsAfterWords(words); bool wasFunction = false; bool needsCheckingForTernaryOperator = Word.ContainsString(words, Data.QUESTION_MARK.Text); List <int> colonsIndexes = new List <int>(); for (int i = 0; i < words.Length; i++) { if (wasFunction) { if (words[i] == "{") { wasFunction = false; } else { span.Inlines.Add(words[i].ToString()); continue; } } if (Split.IsTag(words[i].Text)) { span.Inlines.Add(words[i].ToString()); continue; } if (words[i].Text == Data.FUNCTION.Text) { wasFunction = true; span.Inlines.Add(words[i].ToString()); continue; } if (Search.InSymbolicOperators(words[i], ref span)) { continue; } if (Search.InSingleWordsOperators(words[i], ref span)) { continue; } if (Search.InWordOperatorsWithoutBrackets(words[i], ref span)) { continue; } if (Search.InWordOperatorsWithBrackets(words[i], ref span)) { continue; } if (Search.For_DO(words[i], ref span)) { continue; } if (Search.ForSquareBrackets(words[i], ref span)) { continue; } if (Search.CompareWithConditionalOperators(words[i], ref span, lineNumber)) { continue; } if (needsCheckingForTernaryOperator) { if (Search.ForTernaryOperator(i, words, ref span, ref colonsIndexes)) { continue; } } if (words[i].Text == "(" || words[i].Text == "{" || words[i].Text == "[") { words[i].IsSpaceAfter = false; } if (Line.TrimmedLine(words[i].Text) == "") { words[i].IsSpaceAfter = false; } if (needsCheckingForTernaryOperator) { if (!colonsIndexes.Contains(i)) { span.Inlines.Add(words[i].ToString()); } else { Subsidiary.SelectOperator(words[i], Data.ConditionalOperatorsColor, ref span); } } else { span.Inlines.Add(words[i].ToString()); } } }