public ViewDepositsForm(List <deposits> _ld, freight _fre)
{
List <deposits> ld = _ld;// new List<deposits>();
//ld.Clear();
//foreach (deposits d in _ld)
// ld.Add(d);
InitializeComponent();
ControlsUtil.SetBackColor(this.Controls);
fre = _fre;
if (ld == null)
{
ld = new List <deposits>();
ld.Clear();
}
else
{
for (int i = 0; i < ld.Count; i++)
{
bank_account ba = bank_account.SingleOrDefault(ld[i].account_id);
banks b = banks.SingleOrDefault(ba.bank_id);
ld[i].account = String.Format("{0}/{1} - {2}/{3}", ba.agency, ba.account, b.code, b.name);
ld[i].customer_name = customer.SingleOrDefault(ld[i].customer_id).corporate_name;
ld[i].type_name = ld[i].type == 0 ? "Dinheiro" : "Cheque";
ld[i].truck_board = truck.SingleOrDefault(ld[i].truck_id).board;
}
}
bdgDeposits.DataSource = ld;
if (bdgDeposits.Count == 0)
{
btnAdd_Click(this, null);
}
}
//===============================================
public JsonResult update_bank(int id, string name, string address, string phone1, string phone2, string phone3, string fax, string notes, string responsible)
{
try
{
banks bk = DB.banks.Where(b => b.id == id).Single();
bk.name = name;
bk.address = address;
bk.phone1 = phone1;
bk.phone2 = phone2;
bk.phone3 = phone3;
bk.fax = fax;
bk.responsible = responsible;
bk.notes = notes;
DB.Entry(bk).State = EntityState.Modified;
DB.SaveChanges();
addAdminOperation("u", bk.id, "banks", "تعديل بنك");
return(Json(new { msg = "تمت تعديل بيانات البنك بنجاح" }));
}
catch
{
return(Json(new { msg = "لم تتم عمليه التعديل .. حاول مره اخري" }));
}
}
private void loadModels()
{
bdgCustomer.DataSource = customer.Fetch("");
List <bank_account> bc = bank_account.Fetch("");
for (int i = 0; i < bc.Count; i++)
{
banks b = banks.SingleOrDefault(bc[i].bank_id);
bc[i].account_name = String.Format("{0}-{1} / {2}-{3}", b.code, b.name, bc[i].agency, bc[i].account);
bc[i].bank_name = b.name;
bc[i].holder = customer.SingleOrDefault(bc[i].customer_id).corporate_name;
}
bdgBankAccounts.DataSource = bc;
}
public ParseXml(BankDb dbConnect)
{
string path = "kurs.xml";
banks Banks = null;
XDocument xmlDoc = XDocument.Load("http://www.obmennik.by/xml/kurs.xml");
xmlDoc.Save(path);
using (FileStream ff = new FileStream(path, FileMode.Open))
{
XmlSerializer xml = new XmlSerializer(typeof(banks));
Banks = (banks)xml.Deserialize(ff);
}
dbConnect.UpdateKurs(Banks);
}
private void SearchAll()
{
List <bank_account> ba = bank_account.Fetch("");
for (int i = 0; i < ba.Count; i++)
{
banks b = banks.SingleOrDefault(ba[i].bank_id);
customer c = customer.SingleOrDefault(ba[i].customer_id);
ba[i].bank_name = b.name;
ba[i].bank_number = b.code;
ba[i].holder = c.corporate_name;
ba[i].document = c.document;
}
bdgBankAccounts.DataSource = ba;
}
//===============================================
public JsonResult delete_bank(int id)
{
try
{
banks bk = DB.banks.Where(p => p.id == id).Single();
DB.banks.Remove(bk);
DB.SaveChanges();
return(Json(new { msg = "تم حذف البنك بنجاح" }));
}
catch
{
return(Json(new { msg = "لم تتم عمليه الحذف .. حاول مره اخري" }));
}
}
public void UpdateKurs(banks banks)
{
foreach (var item in banks.bankid)
{
Bank singleBank =
(from bankdb in dbLink.Bank
where bankdb.idparsebank == item.idbank
select bankdb).FirstOrDefault();
singleBank.datekurs = item.date;
singleBank.time = (int)(new TimeSpan(item.time.Hour, item.time.Minute, item.time.Second)).TotalSeconds;
singleBank.usdbuy = item.usd.buy;
singleBank.usdsell = item.usd.sell;
singleBank.eurbuy = item.eur.buy;
singleBank.eursell = item.eur.sell;
singleBank.rurbuy = (double)item.rur.buy;
singleBank.rursell = (double)item.rur.sell;
dbLink.SaveChanges();
}
}
//===============================================
public JsonResult add_bank(string name, string address, string phone1, string phone2, string phone3, string fax, string notes, string responsible)
{
try
{
banks bk = new banks();
bk.name = name;
bk.address = address;
bk.phone1 = phone1;
bk.phone2 = phone2;
bk.phone3 = phone3;
bk.fax = fax;
bk.responsible = responsible;
bk.notes = notes;
DB.banks.Add(bk);
DB.SaveChanges();
return(Json(new { msg = "تمت اضافه البنك بنجاح" }));
}
catch
{
return(Json(new { msg = "لم تتم عمليه الاضافه .. حاول مره اخري" }));
}
}
public string Delete(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
string message = "";
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int bankId = 0;
int userId = 0;
Boolean final = false;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "itemId")
{
bankId = int.Parse(c.Value);
}
else if (c.Type == "userId")
{
userId = int.Parse(c.Value);
}
else if (c.Type == "final")
{
final = bool.Parse(c.Value);
}
}
if (final)
{
try
{
using (incposdbEntities entity = new incposdbEntities())
{
banks bankDelete = entity.banks.Find(bankId);
entity.banks.Remove(bankDelete);
message = entity.SaveChanges().ToString();
return(TokenManager.GenerateToken(message));
}
}
catch
{
return(TokenManager.GenerateToken("0"));
}
}
else
{
try
{
using (incposdbEntities entity = new incposdbEntities())
{
banks bankObj = entity.banks.Find(bankId);
bankObj.isActive = 0;
bankObj.updateUserId = userId;
bankObj.updateDate = DateTime.Now;
message = entity.SaveChanges().ToString();
return(TokenManager.GenerateToken(message));
}
}
catch
{
return(TokenManager.GenerateToken("0"));
}
}
}
}
public string Save(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
string message = "";
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
string bankId = "";
banks newObject = null;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "itemObject")
{
bankId = c.Value.Replace("\\", string.Empty);
bankId = bankId.Trim('"');
newObject = JsonConvert.DeserializeObject <banks>(bankId, new IsoDateTimeConverter {
DateTimeFormat = "dd/MM/yyyy"
});
break;
}
}
if (newObject.updateUserId == 0 || newObject.updateUserId == null)
{
Nullable <int> id = null;
newObject.updateUserId = id;
}
if (newObject.createUserId == 0 || newObject.createUserId == null)
{
Nullable <int> id = null;
newObject.createUserId = id;
}
try
{
using (incposdbEntities entity = new incposdbEntities())
{
banks tmpBank = new banks();
var bankEntity = entity.Set <banks>();
if (newObject.bankId == 0)
{
newObject.createDate = DateTime.Now;
newObject.updateDate = DateTime.Now;
newObject.updateUserId = newObject.createUserId;
tmpBank = bankEntity.Add(newObject);
entity.SaveChanges();
message = tmpBank.bankId.ToString();;
}
else
{
tmpBank = entity.banks.Where(p => p.bankId == newObject.bankId).FirstOrDefault();
tmpBank.name = newObject.name;
tmpBank.accNumber = newObject.accNumber;
tmpBank.address = newObject.address;
tmpBank.mobile = newObject.mobile;
tmpBank.notes = newObject.notes;
tmpBank.phone = newObject.phone;
tmpBank.updateDate = DateTime.Now;
tmpBank.updateUserId = newObject.updateUserId;
tmpBank.isActive = newObject.isActive;
entity.SaveChanges();
message = tmpBank.bankId.ToString();
}
return(TokenManager.GenerateToken(message));
}
}
catch
{
message = "0";
return(TokenManager.GenerateToken(message));
}
}
}