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());
}
}
}