public BranchesModel GetBranches()
{
var head = _repository.Head;
if (head.Tip == null)
{
return(new BranchesModel());
}
var key = CalcBranchesKey();
var accessor = GitCacheAccessor.Singleton(new HistoryDivergenceAccessor(_repoId, _repository, key));
var aheadBehinds = accessor.Result.Value;
var model = new BranchesModel
{
Commit = ToCommitModel(head.Tip, head.FriendlyName),
AheadBehinds = aheadBehinds.Select(s => new AheadBehindModel
{
Ahead = s.Ahead,
Behind = s.Behind,
Commit = new CommitModel
{
ReferenceName = s.Name,
Author = CreateSafeSignature(s.AuthorName, s.AuthorEmail, s.AuthorWhen),
Committer = CreateSafeSignature(s.CommitterName, s.CommitterEmail, s.CommitterWhen),
},
}).ToArray(),
};
return(model);
}
public async Task <JsonResult> UpdateBranches(BranchesModel model)
{
var Messaging = new RenderMessaging();
try
{
if (User == null)
{
Messaging.isError = true;
Messaging.messaging = "Phiên đăng nhập đã hết hạn.";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
if (string.IsNullOrEmpty(model.BranchesName) ||
string.IsNullOrEmpty(model.Address) ||
string.IsNullOrEmpty(model.Phone))
{
Messaging.isError = true;
Messaging.messaging = "Thông tin Kho không hợp lệ";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
Messaging.isError = !await _IBrachesBusiness.UpdateBranches(model, User.UserId);
Messaging.messaging = !Messaging.isError ? "Cập nhật kho thành công!" : "Cập nhật kho không thành công!";
}
catch (Exception ex)
{
Messaging.isError = true;
Messaging.messaging = "Cập nhật kho không thành công!";
}
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
public async Task <bool> UpdateBranches(BranchesModel model, int UserId)
{
if (model.BranchesId <= 0)
{
return(false);
}
var ob = unitOfWork.BrachesRepository.GetById(model.BranchesId);
if (ob == null)
{
return(false);
}
ob.Code = model.Code;
ob.IsPrimary = model.IsPrimary;
ob.BranchesName = model.BranchesName;
ob.Phone = model.Phone;
ob.Address = model.Address;
ob.DateUpdate = DateTime.Now;
ob.EmployeeUpdate = UserId;
unitOfWork.BrachesRepository.Update(ob, o => o.BranchesName,
o => o.Code,
o => o.IsPrimary,
o => o.Phone, o => o.Address,
o => o.DateUpdate, o => o.EmployeeUpdate);
await unitOfWork.SaveChanges();
return(true);
}
}// end of function
public BranchesModel GetLastNO(BranchesModel _refmodel, string _Brstn)
{
DBConnect();
string sql = "SELECT DateEncoded,BRSTN,Address1,LastNo_C,LastNo_CS,LastNo_P FROM " + databaseName + ".banko_nuestra_branches where BRSTN ='" + _Brstn + "'";
MySqlCommand cmd = new MySqlCommand(sql, myConnect);
MySqlDataReader myReader = cmd.ExecuteReader();
while (myReader.Read())
{
// _refmodel.ID = int.Parse(myReader.GetString(0));
_refmodel.Date = DateTime.Parse(myReader.GetString(0));
_refmodel.BRSTN = myReader.GetString(1);
_refmodel.Address1 = myReader.GetString(2);
_refmodel.LastNo_C = myReader.GetInt64(3);
_refmodel.LastNo_CS = myReader.GetInt64(4);
_refmodel.LastNo_P = myReader.GetInt64(5);
//_refmodel.C_Before = int.Parse(myReader.GetString(7));
}
DBClosed();
return(_refmodel);
}// end of function
public async Task <JsonResult> RemoveBranchs(BranchesModel model)
{
var Messaging = new RenderMessaging();
try
{
if (User == null)
{
Messaging.isError = true;
Messaging.messaging = "Phiên đăng nhập đã hết hạn.";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
if (model.BranchesId <= 0)
{
Messaging.isError = true;
Messaging.messaging = "Thông tin Kho không hợp lệ";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
Messaging.isError = !await _IBrachesBusiness.RemoveBranchs(model.BranchesId);
Messaging.messaging = Messaging.isError ? "Kho không xóa được vui lòng kiểm tra lại." : "Xóa Kho thành công!";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
catch
{
Messaging.isError = true;
Messaging.messaging = "Kho không xóa được vui lòng kiểm tra lại.";
}
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(BranchesModel modifiedModel, string FILTER_Keyword, int?FILTER_Active)
{
if (ModelState.IsValid)
{
if (isExists(modifiedModel.Id, modifiedModel.Name))
{
ModelState.AddModelError(BranchesModel.COL_Name.Name, $"{modifiedModel.Name} sudah terdaftar");
}
else
{
BranchesModel originalModel = db.Branches.AsNoTracking().Where(x => x.Id == modifiedModel.Id).FirstOrDefault();
string log = string.Empty;
log = Helper.append(log, originalModel.Name, modifiedModel.Name, BranchesModel.COL_Name.LogDisplay);
log = Helper.append(log, originalModel.Address, modifiedModel.Address, BranchesModel.COL_Address.LogDisplay);
log = Helper.append(log, originalModel.PhoneNumber, modifiedModel.PhoneNumber, BranchesModel.COL_PhoneNumber.LogDisplay);
log = Helper.append(log, originalModel.Notes, modifiedModel.Notes, BranchesModel.COL_Notes.LogDisplay);
log = Helper.append(log, originalModel.InvoiceHeaderText, modifiedModel.InvoiceHeaderText, BranchesModel.COL_InvoiceHeaderText.LogDisplay);
log = Helper.append(log, originalModel.Active, modifiedModel.Active, BranchesModel.COL_Active.LogDisplay);
if (!string.IsNullOrEmpty(log))
{
db.Entry(modifiedModel).State = EntityState.Modified;
ActivityLogsController.AddEditLog(db, Session, modifiedModel.Id, log);
db.SaveChanges();
}
return(RedirectToAction(nameof(Index), new { FILTER_Keyword = FILTER_Keyword, FILTER_Active = FILTER_Active }));
}
}
setViewBag(FILTER_Keyword, FILTER_Active);
return(View(modifiedModel));
}
public BranchesModel GetBranches()
{
var head = _repository.Head;
if (head.Tip == null)
{
return(new BranchesModel());
}
var sha = CalcBranchesSha();
var aheadBehinds = GitCache.Get <RevisionSummaryCacheItem[]>(sha, "branches");
if (aheadBehinds == null)
{
aheadBehinds = _repository.Branches
.Where(s => s != head && s.Name != "HEAD")
.OrderByDescending(s => s.Tip.Author.When)
.Select(branch =>
{
var commit = branch.Tip;
var divergence = _repository.ObjectDatabase.CalculateHistoryDivergence(commit, head.Tip);
return(new RevisionSummaryCacheItem
{
Ahead = divergence.AheadBy ?? 0,
Behind = divergence.BehindBy ?? 0,
Name = branch.Name,
Sha = commit.Sha,
AuthorName = commit.Author.Name,
AuthorEmail = commit.Author.Email,
AuthorWhen = commit.Author.When,
CommitterName = commit.Committer.Name,
CommitterEmail = commit.Committer.Email,
CommitterWhen = commit.Committer.When,
});
})
.ToArray();
GitCache.Set(sha, "branches", aheadBehinds);
}
var model = new BranchesModel
{
Commit = ToCommitModel(head.Tip, head.Name),
AheadBehinds = aheadBehinds.Select(s => new AheadBehindModel
{
Ahead = s.Ahead,
Behind = s.Behind,
Commit = new CommitModel
{
ReferenceName = s.Name,
Author = new Signature(s.AuthorName, s.AuthorEmail, s.AuthorWhen),
Committer = new Signature(s.CommitterName, s.CommitterEmail, s.CommitterWhen),
},
}).ToArray(),
};
return(model);
}
}// end of function
public BranchesModel UpdateRef(BranchesModel _ref, string _brstn)
{
DBConnect();
string sql = "Update " + databaseName + ".banko_nuestra_branches SET LastNo_C = '" + _ref.LastNo_C + "',LastNo_CS = '" + _ref.LastNo_CS + "' ,LastNo_P = '" + _ref.LastNo_P + "', DateUpdated = '" + _ref.DateUpdated.ToString("yyyy-MM-dd") + "' where BRSTN = '" + _brstn + "'";
MySqlCommand cmd = new MySqlCommand(sql, myConnect);
MySqlDataReader myReader = cmd.ExecuteReader();
DBClosed();
return(_ref);
}// end of function
private void Hapus_Click(object sender, EventArgs e)
{
DialogResult dialog = MessageBox.Show("Yakin ?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialog == DialogResult.Yes)
{
BranchesModel branch = (BranchesModel)BranchBS.Current;
BranchXpCollection.Remove(branch);
branch.Delete();
BranchUOW.CommitChanges();
}
}
private void Simpan_Click(object sender, EventArgs e)
{
if (!validator.Validate())
{
return;
}
BranchesModel branch = (BranchesModel)BranchBS.Current;
branch.Save();
BranchXpCollection.Add(branch);
BranchUOW.CommitChanges();
BranchBS.EndEdit();
ViewState();
}
public async Task <bool> CreateBranches(BranchesModel model, int UserId)
{
var objBraches = Mapper.Map <soft_Branches>(model);
objBraches.DateCreate = DateTime.Now;
objBraches.EmployeeCreate = UserId;
objBraches.Type = 1;
unitOfWork.BrachesRepository.Add(objBraches);
await unitOfWork.SaveChanges();
return(true);
}
public BranchesModel GetBrstn(BranchesModel _refmodel, string _branch)
{
DBConnect();
string sql = "Select brstn from " + databaseName + ".banko_nuestra_branches where Address1 = '" + _branch + "'";
MySqlCommand cmd = new MySqlCommand(sql, myConnect);
MySqlDataReader myReader = cmd.ExecuteReader();
while (myReader.Read())
{
_refmodel.BRSTN = myReader.GetString(0);
}
DBClosed();
return(_refmodel);
}
private void cmbBranch_SelectedIndexChanged(object sender, EventArgs e)
{
// DataTable dt = new DataTable();
BranchesModel brmodel = new BranchesModel();
if (cmbBranch.Text == "SAN SIMON PAMPANGA BRANCH")
{
db.GetBrstn(brmodel, cmbBranch.Text);
txtBrstn.Text = brmodel.BRSTN.ToString();
cheque.BRSTN = txtBrstn.Text;
db.GetLastNO(br, cheque.BRSTN);
LastNoP = int.Parse(br.LastNo_P.ToString());
LastNoC = int.Parse(br.LastNo_C.ToString());
}
}
public ActionResult Create(BranchesModel model, string FILTER_Keyword, int?FILTER_Active)
{
if (ModelState.IsValid)
{
if (isExists(null, model.Name))
{
ModelState.AddModelError(BranchesModel.COL_Name.Name, $"{model.Name} sudah terdaftar");
}
else
{
model.Id = Guid.NewGuid();
model.Active = true;
db.Branches.Add(model);
ActivityLogsController.AddCreateLog(db, Session, model.Id);
db.SaveChanges();
return(RedirectToAction(nameof(Index), new { id = model.Id, FILTER_Keyword = FILTER_Keyword, FILTER_Active = FILTER_Active }));
}
}
setViewBag(FILTER_Keyword, FILTER_Active);
return(View(model));
}
}//end of function
public BranchesModel GetBranchesDetails(BranchesModel _refmodel, string _Brstn)
{
DBConnect();
string sql = "SELECT BRSTN,Address1, Address2, Address3,Address4,Address5,Address6 FROM captive_database.isla_branches where BRSTN ='" + _Brstn + "'";
MySqlCommand cmd = new MySqlCommand(sql, myConnect);
MySqlDataReader myReader = cmd.ExecuteReader();
while (myReader.Read())
{
_refmodel.BRSTN = myReader.GetString(0);
_refmodel.Address1 = myReader.GetString(1);
_refmodel.Address2 = myReader.GetString(2);
_refmodel.Address3 = myReader.GetString(3);
_refmodel.Address4 = myReader.GetString(4);
_refmodel.Address5 = myReader.GetString(5);
_refmodel.Address6 = myReader.GetString(6);
}
DBClosed();
return(_refmodel);
}// end of function
public string ConvertBranches(BranchesModel data)
{
return("Branchname is: " + data.branchname + ", ID is: " + data.id + ", description is: " + data.description + ", created at"
+ data.created_date + ", ID of creator: " + data.creator_id + "\\n");
}
private void btnSave_Click(object sender, EventArgs e)
{
DatabaseConnectionsServices dbconnection = new DatabaseConnectionsServices();
if (deliveryDate == dateTime)
{
MessageBox.Show("Please set the delivery date!!!");
}
else
{
DialogResult result1 = MessageBox.Show("", "Do you to saved this record?", MessageBoxButtons.YesNo);
BranchesModel branch = new BranchesModel();
if (result1.ToString() == "Yes")
{
CheckBRSTNandChkType();
qty = int.Parse(txtOrQty.Text);
_checkModel.AccountNo = txtAccountNumber.Text;
_checkModel.Address1 = cmbBranch.Text;
_checkModel.ChkType = _ChkType;
if (_checkModel.ChkType == "MC")
{
_checkModel.ChkTypeName = "MANAGERS CHECK";
}
else if (_checkModel.ChkType == "MC_CONT")
{
_checkModel.ChkTypeName = "MANAGERS CHECK CONTINUES";
}
else
{
_checkModel.ChkTypeName = cmbChkType.Text;
}
_checkModel.Name1 = txtAccountName1.Text;
_checkModel.Name2 = txtAccountName2.Text;
_checkModel.BRSTN = _Brstn;
_checkModel.BranchName = cmbBranch.Text;
_checkModel.Address1 = cmbBranch.Text;
dbconnection.GetBranchesDetails(branch, _checkModel.BRSTN);
if (branch != null)
{
_checkModel.Address2 = branch.Address2.ToString();
_checkModel.Address3 = branch.Address3.ToString();
_checkModel.Address4 = branch.Address4.ToString();
_checkModel.Address5 = branch.Address5.ToString();
_checkModel.Address6 = branch.Address6.ToString();
}
_checkModel.Qty = qty;
deliveryDate = dateTimePicker1.Value;
_checkModel.DeliveryDate = deliveryDate;
if (_checkModel != null)
{
for (int i = 0; i < qty; i++)
{
dbconnection.GetLastNO(refMode, _checkModel.ChkType, _checkModel.BRSTN);
Int64 s = refMode.LastNo + 1;
string lastNo = refMode.LastNo.ToString();
int endRefno = int.Parse(lastNo);
_checkModel.StartSeries = s.ToString();
if (_checkModel.ChkType == "A" || _checkModel.ChkType == "MC" || _checkModel.ChkType == "MC_CONT" || _checkModel.ChkType == "SR" || _checkModel.ChkType == "TD")
{
endRefno = endRefno + bookperpcs;
}
else if (_checkModel.ChkType == "B")
{
endRefno = endRefno + bookperpcs;
}
_checkModel.EndSeries = endRefno.ToString();
refMode.Date = dateTime;
refMode.LastNo = endRefno;
dbconnection.SaveToSecondaryTable(_checkModel);
// dbconnection.UpdateRef(refMode);
string _brstn = _checkModel.BRSTN.ToString();
string _chktype = _checkModel.ChkType.ToString();
}
MessageBox.Show("Data has been Saved!");
dbconnection.UpdateRef(refMode);
CheckLoadData();
}
// MessageBox.Show(_checkModel.DeliveryDate.ToString() + dateTime.ToString());
ClearAllInputText();
}
else
{
MessageBox.Show("Saving Cancelled!!!!");
}
}
}
