private void Btnsubmit_Click(object sender, EventArgs e)
{
using (UnitofWork db = new UnitofWork())
{
if (BaseValidator.IsFormValid(this.components))
{
if (Txtrepeatpassword.Text != TxtPassword.Text)
{
RtlMessageBox.Show("لطفا کلمه عبور را دوباره وارد کنید");
Txtrepeatpassword.Focus();
Txtrepeatpassword.SelectAll();
}
else
{
DataLayer.Login login = new DataLayer.Login()
{
FullName = TxtName.Text,
UserName = TxtUsername.Text,
Password = TxtPassword.Text
};
if (db.LoginRepository.GetAll(l => l.UserName == TxtUsername.Text).Any() == false)
{
db.LoginRepository.Insert(login);
}
db.Save();
Application.Restart();
DialogResult = DialogResult.OK;
}
}
}
}
public void CalcularPrecio()
{
UnitofWork unit = new UnitofWork();
Producto aux = unit.RepositorioProducto.ObtenerUno(c => c.ProductoId == ProductoId);
PrecioTotal = Cantidad * aux.Precio;
}
public BlokService(UnitofWork uow)
{
_uow = uow;
_blokRepository = _uow.GetRepository <blok>();
_bagimsizBolumRepository = _uow.GetRepository <bagimsiz_bolumler>();
_blokDTO = new EBlokDTO();
}
private void BtnSubmit_Click(object sender, EventArgs e)
{
using (UnitofWork db = new UnitofWork())
{
if (BaseValidator.IsFormValid(this.components))
{
DataLayer.Product product = new DataLayer.Product()
{
ProductName = TxtProductName.Text,
Unit = TxtUnit.Text,
QTY = int.Parse(NumQTY.Value.ToString()),
Price = int.Parse(NumPrice.Value.ToString())
};
if (IsEdit == false)
{
db.ProductRepository.Insert(product);
}
else
{
int id = Convert.ToInt32(MydataGridView.CurrentRow.Cells[0].Value.ToString());
product.ProductID = id;
db.ProductRepository.Update(product);
}
}
db.Save();
DialogResult = DialogResult.OK;
bindgrid();
}
}
private void btnFillter_Click(object sender, EventArgs e)
{
DateTime DateStart = Convert.ToDateTime(string.Format("{0: dd/MM/yyyy 00:00:00}", dtpDateStart.Value));
DateTime DateFinish = Convert.ToDateTime(string.Format("{0: dd/MM/yyyy 00:00:00}", dtpDateFinish.Value));
UnitofWork unitofWork = new UnitofWork(ctx);
Expense_Suppliers_Service expense_Suppliers_Service = new Expense_Suppliers_Service(unitofWork);
List <Expense_Suppliers> expense_Suppliers = expense_Suppliers_Service.GetAllExpense_Suppliers().Where(x => x.ExpenseDate >= DateStart && x.ExpenseDate <= DateFinish).ToList();
dataGridView1.DataSource = expense_Suppliers;
dataGridView1.Columns[0].HeaderText = "Tarih";
dataGridView1.Columns[1].HeaderText = "Firma";
dataGridView1.Columns[2].HeaderText = "Açıklama";
dataGridView1.Columns[3].HeaderText = "Tutar";
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[7].Visible = false;
dataGridView1.Columns[8].Visible = false;
Tools tools = new Tools();
tools.DataGridViewResize(dataGridView1, 4);
txtTotalRevenues.Text = expense_Suppliers.Sum(x => x.Price).ToString();
}
public UserService(UnitofWork uow)
{
_uow = uow;
_kisilerRepository = _uow.GetRepository <kisiler>();
_bagimsizKisiRepository = _uow.GetRepository <bagimsiz_bolum_kisiler>();
_userDTO = new EUserDTO();
}
private void btnClear_Click(object sender, EventArgs e)
{
try
{
UnitofWork unitofWork = new UnitofWork(ctx);
TotalExpenses_Service totalExpenses_Service = new TotalExpenses_Service(unitofWork);
List <TotalExpenses> totalExpenses = totalExpenses_Service.GetAllTotalExpenses();
dataGridView1.DataSource = totalExpenses;
dataGridView1.Columns[0].HeaderText = "Tarih";
dataGridView1.Columns[2].HeaderText = "Gider Tipi";
dataGridView1.Columns[3].HeaderText = "Fiyat";
dataGridView1.Columns[1].Visible = false;
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[7].Visible = false;
Tools tools = new Tools();
tools.DataGridViewResize(dataGridView1, 4);
txtTotalRevenues.Text = totalExpenses.Sum(x => x.Price).ToString();
}
catch (Exception)
{
MessageBox.Show("Hata Oluştu.");
}
}
private void frmReport_Load(object sender, EventArgs e)
{
using (UnitofWork db = new UnitofWork())
{
List <ListCustomerViewModel> list = new List <ListCustomerViewModel>();
list.Add(new ListCustomerViewModel()
{
CustomerID = 0,
FullName = "انتخاب کنید"
});
list.AddRange(db.CustomerRepository.GetCustomersName());
CbCustomer.DataSource = list;
CbCustomer.DisplayMember = "FullName";
CbCustomer.ValueMember = "CustomerID";
}
if (TypeID == 1)
{
this.Text = "گزارش دریافتی ها";
}
else
{
this.Text = " گزارش پرداختی ها";
}
}
private void btnClear_Click(object sender, EventArgs e)
{
UnitofWork unitofWork = new UnitofWork(ctx);
DailyCastingEntry_Catering_Service dailyCastingEntry_Catering_Service = new DailyCastingEntry_Catering_Service(unitofWork);
List <DailyCastingEntry_Catering> dailyCastingEntry_Caterings = dailyCastingEntry_Catering_Service.GetAllCateringPaymentCasting();
dataGridView1.DataSource = dailyCastingEntry_Caterings;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[7].Visible = false;
dataGridView1.Columns[8].Visible = false;
dataGridView1.Columns[9].Visible = false;
dataGridView1.Columns[10].Visible = false;
dataGridView1.Columns[0].HeaderText = "Tarih";
dataGridView1.Columns[1].HeaderText = "Firma";
dataGridView1.Columns[2].HeaderText = "Kişi";
dataGridView1.Columns[3].HeaderText = "Tutar";
dataGridView1.Columns[4].HeaderText = "Fatura";
dataGridView1.Columns[5].HeaderText = "Ödeme Durumu";
Tools tools = new Tools();
tools.DataGridViewResize(dataGridView1, 6);
txtRealRevenues.Text = dailyCastingEntry_Caterings.Sum(x => x.Price).ToString();
txtTotalRevenues.Text = dailyCastingEntry_Caterings.Sum(x => x.Price).ToString();
}
public ActionResult ListByCat(int id, int page = 1)
{
using (UnitofWork uow = new UnitofWork())
{
return(View(uow.GetRepository <Product>().Listele().Where(x => x.CategoryID == id).ToPagedList(page, 9)));
}
}
private void BtnLogin_Click(object sender, EventArgs e)
{
if (BaseValidator.IsFormValid(this.components))
{
using (UnitofWork db = new UnitofWork())
{
if (IsEdit)
{
var Login = db.LoginRepository.GetAll().First();
Login.UserName = TxtUsername.Text;
Login.Password = Txtpassword.Text;
db.LoginRepository.Update(Login);
db.Save();
Application.Restart();
}
else
{
if (db.LoginRepository.GetAll(l =>
l.UserName == TxtUsername.Text &&
l.Password == Txtpassword.Text).Any())
{
DialogResult = DialogResult.OK;
}
else
{
RtlMessageBox.Show("اطلاعات وارد شده صحیح نمیباشد");
}
}
}
}
}
public async Task <IActionResult> EmailInvoiceAsync(string Id)
{
ApplicationUser Usr = _userManager.GetUserAsync(User).Result;
var unitOfWork = new UnitofWork(_applicationDBcontext, Usr, loggerfactory);
var result = unitOfWork.Invoices.GetInvoicebyId(Id);
var model = _mapper.Map <tblInvoice, InvoiceVewModel>(result);
model.OrganisationEmail = Usr.OrganisationEmail;
model.OrganisationName = Usr.OrganisationName;
model.Person = Usr.Person;
model.AddressCode = Usr.AddressCode;
model.AddressL1 = Usr.AddressL1;
model.AddressL2 = Usr.AddressL2;
model.AddressL3 = Usr.AddressL3;
model.AddressL4 = Usr.AddressL4;
model.AddressL5 = Usr.AddressL5;
model.InvoiceUrl = Url.Action("ViewInvoice", "Invoice", new { Id = model.Id }, Request.Scheme);
var HTMLstring = await this.RenderViewAsync <InvoiceVewModel>("InvoiceEmail", model, true);
//StreamWriter sw = new StreamWriter("C:\\Users\\Carl\\Emailtest.html");
//sw.Write(HTMLstring);
//sw.Close();
var PostEmail = new SendGridClient(_appSettings.SendGridKey);
var From = new EmailAddress(Usr.Email, Usr.UserName);
var Replyto = new EmailAddress(Usr.OrganisationEmail, Usr.OrganisationName);
var To = new EmailAddress(result.ToEmail, result.To);
var Subject = "Invoice :" + model.Code + " from :" + model.OrganisationName + " Date :" + model.Date;
var Mail = MailHelper.CreateSingleEmail(From, To, Subject, "", HTMLstring);
var response = await PostEmail.SendEmailAsync(Mail);
result.Status = status.Sent;
unitOfWork.Complete();
return(RedirectToAction("Index"));
}
public IActionResult POIndex()
{
UnitofWork _uofw = new UnitofWork(_context, _userManager.GetUserAsync(User).Result);
var result = _uofw.PurchaseOrders.GetAllPurchaseOrders();
return(View("Index", PODTO.ToIndexModel(result, "Code", "Ascending")));
}
// GET: PurchaseOrder/Edit/5
public async Task <IActionResult> Edit(Guid id)
{
UnitofWork _uofw = new UnitofWork(_context, _userManager.GetUserAsync(User).Result);
var PO = _uofw.PurchaseOrders.GetPurchaseOrderbyIdIncludeItems(id);
Guid guidOutput = new Guid();
try
{
guidOutput = Guid.Parse(PO.To);
}
catch
{
guidOutput = Guid.NewGuid();
}
var ViewModel = PODTO.ToViewModel(
PO,
_uofw.Lookups.GetLookuplist("BudgetCode"),
_uofw.Organisations.GetOrganisations(),
_uofw.Organisations.GetOrganisationbyIdandItems(guidOutput));
if (ViewModel.Status == "Open")
{
return(View(ViewModel));
}
else
{
return(View("Details", ViewModel));
}
}
public override void OnAuthorization(AuthorizationContext filterContext)
{
bool authorized = false;
UnitofWork uow = new UnitofWork();
AppUser user = uow.GetRepository <AppUser>().Listele().First(x => x.UserName == HttpContext.Current.User.Identity.Name);
string userRole = Enum.GetName(typeof(Role), user.Role);
foreach (var role in this.UserProfilesRequired)
{
if (userRole == role)
{
authorized = true;
break;
}
}
if (!authorized)
{
var url = new UrlHelper(filterContext.RequestContext);
var logonUrl = url.Action("Http", "Error", new { Id = 401, Area = "" });
filterContext.Result = new RedirectResult(logonUrl);
}
base.OnAuthorization(filterContext);
}
public MuhtelifIslemlerService(UnitofWork uow)
{
_uow = uow;
_muhtelifIslemler = _uow.GetRepository <muhtelif_islemler>();
_bankaHareketRepository = _uow.GetRepository <banka_hareket>();
_kasaHareketRepository = _uow.GetRepository <kasa_hareket>();
}
// GET: Organisations
public async Task <IActionResult> Index()
{
UnitofWork _uofw = new UnitofWork(_context, _userManager.GetUserAsync(User).Result);
var result = _uofw.Organisations.GetAllOrganisations();
return(View(OrgDTO.ToIndexModel(result)));
}
private void BtnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtName.Text))
{
DialogResult dialogResult = MessageBox.Show("Kaydı Eklemek İstediğinize Emin misiniz?", "Yeni Kayıt", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialogResult == DialogResult.Yes)
{
Tools tools = new Tools();
UnitofWork unitofWork = new UnitofWork(ctx);
SupplierCompanies_Service supplierCompanies_Service = new SupplierCompanies_Service(unitofWork);
SupplierCompanies supplierCompanies = new SupplierCompanies
{
Name = txtName.Text,
Descriptions = txtDescriptions.Text,
Code = tools.CreateCode()
};
if (supplierCompanies_Service.Insert(supplierCompanies))
{
txtName.Text = "";
txtDescriptions.Text = "";
MessageBox.Show("İşlem Başarılı");
}
else
{
MessageBox.Show("İşlem Başarısız.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("Boş Geçilemez.", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnFillter_Click(object sender, EventArgs e)
{
try
{
DateTime DateStart = Convert.ToDateTime(string.Format("{0: dd/MM/yyyy 00:00:00}", dtpDateStart.Value));
DateTime DateFinish = Convert.ToDateTime(string.Format("{0: dd/MM/yyyy 00:00:00}", dtpDateFinish.Value));
UnitofWork unitofWork = new UnitofWork(ctx);
TotalExpenses_Service totalExpenses_Service = new TotalExpenses_Service(unitofWork);
List <TotalExpenses> totalExpenses = totalExpenses_Service.GetAllTotalExpenses().Where(x => x.ExpenseDate >= DateStart && x.ExpenseDate <= DateFinish).ToList();
dataGridView1.DataSource = totalExpenses;
dataGridView1.Columns[0].HeaderText = "Tarih";
dataGridView1.Columns[2].HeaderText = "Gider Tipi";
dataGridView1.Columns[3].HeaderText = "Fiyat";
dataGridView1.Columns[1].Visible = false;
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[7].Visible = false;
Tools tools = new Tools();
tools.DataGridViewResize(dataGridView1, 4);
txtTotalRevenues.Text = totalExpenses.Sum(x => x.Price).ToString();
}
catch (Exception)
{
MessageBox.Show("Hata Oluştu.");
}
}
private void TxtFilter_TextChanged(object sender, EventArgs e)
{
db = new UnitofWork();
MydataGridView.AutoGenerateColumns = false;
MydataGridView.DataSource = db.CustomerRepository.GetCustomersName(TxtFilter.Text);
db.Dispose();
}
private void TxtFilter_TextChanged(object sender, EventArgs e)
{
using (UnitofWork db = new UnitofWork())
{
MydataGridView.DataSource = db.CustomerRepository.GetCustomersByFilter(TxtFilter.Text);
}
}
private void BtnSubmit_Click(object sender, EventArgs e)
{
if (BaseValidator.IsFormValid(this.components))
{
if (RbtnIncome.Checked || RbtnOutgoing.Checked)
{
db = new UnitofWork();
DataLayer.Accounting accounting = new DataLayer.Accounting()
{
Amount = int.Parse(NumericAmount.Value.ToString()),
TypeID = (RbtnIncome.Checked) ? 1 : 2,
CustomerID = db.CustomerRepository.GetCustomerIdByName(TxtName.Text),
Description = TxtDecription.Text,
Datetime = DateTime.Now
};
if (AccountId == 0)
{
db.accountingrepository.Insert(accounting);
}
else
{
accounting.AccID = AccountId;
db.accountingrepository.Update(accounting);
}
db.Save();
db.Dispose();
DialogResult = DialogResult.OK;
}
else
{
RtlMessageBox.Show("لطفا نوع تراکنش را انتخاب کنید");
}
}
}
private void btnClear_Click(object sender, EventArgs e)
{
UnitofWork unitofWork = new UnitofWork(ctx);
Expense_Suppliers_Service expense_Suppliers_Service = new Expense_Suppliers_Service(unitofWork);
List <Expense_Suppliers> expense_Suppliers = expense_Suppliers_Service.GetAllExpense_Suppliers();
dataGridView1.DataSource = expense_Suppliers;
dataGridView1.Columns[0].HeaderText = "Tarih";
dataGridView1.Columns[1].HeaderText = "Firma";
dataGridView1.Columns[2].HeaderText = "Açıklama";
dataGridView1.Columns[3].HeaderText = "Tutar";
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[7].Visible = false;
dataGridView1.Columns[8].Visible = false;
Tools tools = new Tools();
tools.DataGridViewResize(dataGridView1, 4);
txtTotalRevenues.Text = expense_Suppliers.Sum(x => x.Price).ToString();
}
// GET: OrganisationItem
public async Task <IActionResult> Index(Guid id)
{
UnitofWork _uofw = new UnitofWork(_context, _userManager.GetUserAsync(User).Result);
var result = _uofw.Organisations.GetOrganisationbyIdandItems(id);
return(View(OrgItemDTO.ToIndexModel(result)));
}
public AnasayacService(UnitofWork uow)
{
_uow = uow;
_anaSayacRepository = _uow.GetRepository <anasayac>();
_bagimsizSayacRepository = _uow.GetRepository <bagimsiz_bolum_sayaclari>();
_anaSayacDTO = new EAnasayacDTO();
}
public void AddTask()
{
UnitofWork.Setup(x => x.Repository <Task>().Insert(It.IsAny <Task>()));
var result = Service.AddTask(new TaskContract());
Assert.IsNotNull(result);
}
public PostService(UnitofWork uow)
{
_uow = uow;
_postRepository = uow.GetRepository <Post>();
_userRepository = uow.GetRepository <User>();
_categoryRepository = uow.GetRepository <Category>();
}
public void AddUser()
{
UnitofWork.Setup(x => x.Repository <User>().Insert(It.IsAny <User>()));
var result = Service.AddUser(new UserContract());
Assert.IsNotNull(result);
}
private void btnFillter_Click(object sender, EventArgs e)
{
DateTime DateStart = Convert.ToDateTime(string.Format("{0: dd/MM/yyyy 00:00:00}", dtpDateStart.Value));
DateTime DateFinish = Convert.ToDateTime(string.Format("{0: dd/MM/yyyy 00:00:00}", dtpDateFinish.Value));
UnitofWork unitofWork = new UnitofWork(ctx);
DailyCastingEntry_Personal_Service dailyCastingEntry_Personal_Service = new DailyCastingEntry_Personal_Service(unitofWork);
List <DailyCastingEntry_Personal> dailyCastingEntry_Personals = dailyCastingEntry_Personal_Service.GetAllDailyCastingEntry_Personal().Where(x => x.CastingDate >= DateStart && x.CastingDate <= DateFinish).ToList();
dataGridView1.DataSource = dailyCastingEntry_Personals;
dataGridView1.Columns[0].HeaderText = "Tarih";
dataGridView1.Columns[1].HeaderText = "Tutar";
dataGridView1.Columns[2].HeaderText = "Açıklama";
dataGridView1.Columns[3].Visible = false;
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
Tools tools = new Tools();
tools.DataGridViewResize(dataGridView1, 3);
txtTotalRevenues.Text = dailyCastingEntry_Personals.Sum(x => x.Price).ToString();
}
static void Main(string[] args)
{
//Tek class üzerinden bütün bütün repository yönetebiliyoruz
UnitofWork unitofWork = new UnitofWork(new PersonelContext());
unitofWork.DepartmentRepository.Add(new Department()
{
Name = "Pazarlama", IsActive = true, CreatedDate = DateTime.Now
});
unitofWork.DepartmentRepository.Add(new Department()
{
Name = "Muhasebe",
IsActive = true,
CreatedDate = DateTime.Now
});
unitofWork.DepartmentRepository.Add(new Department()
{
Name = "Satis",
IsActive = true,
CreatedDate = DateTime.Now
});
unitofWork.Complete();
System.Console.WriteLine("oluþtu");
}
