public void SBCRUDLoadDetail()
{
SBUser sbu = (SBUser)SBCRUDInput;
txtUserName.Text = sbu.Name;
cmbUserRole.SelectedItem = sbu.Role;
}
public override void SetDbData(Hashtable data)
{
base.SetDbData(data);
if (this.UserId > 0)
{
this.User = new SBUser(this.UserId);
}
}
public void SBCRUDUpdate()
{
SBUser sbu = (SBUser)SBCRUDInput;
sbu.Name = txtUserName.Text;
sbu.Role = (Role)cmbUserRole.SelectedItem;
rps.UpdateSaveChanges();
}
public override void GetDbData(object transaction_code)
{
Hashtable row = (transaction_code is int) ? this.db_table.getRow("transaction_id = " + transaction_code.ToString()) :
this.db_table.getRow("transaction_code = '" + transaction_code.ToString() + "'");
if (row == null)
{
return;
}
this._dbData = row;
if (this.UserId > 0)
{
this.User = new SBUser(this.UserId);
}
//get details
this.GetDbItems(this.TransactionCode);
this.GetDbMeta(this.TransactionCode);
this.TransactionType = new SBTransactionType(this.TransactionTypeId);
}
/// <summary>
/// Bu metot veritabanı olmadığında ve yeninden oluşturulması gerektiğinde,
/// oluşturulduktan sonra örnek verinin içine eklenmesini sağlar.
/// </summary>
/// <param name="context"></param>
protected override void Seed(SBContext context)
{
Random rnd = new Random();
#region Insert Sample Users
string[] users = new string[3] {
"Murat Başeren", "Yavuz Selim Bayram", "Bulut Kırca"
};
foreach (string userName in users)
{
SBUser user = new SBUser()
{
Name = userName,
Role = (Role)Enum.ToObject(typeof(Role), rnd.Next(0, 2))
};
context.Users.Add(user);
}
context.SaveChanges();
#endregion
#region Insert Sample Categories
string[] categories = new string[4] {
"Todo", "InProgress", "Test", "Done"
};
foreach (string cat in categories)
{
SBCategory category = new SBCategory()
{
Name = cat
};
context.Categories.Add(category);
}
context.SaveChanges();
#endregion
#region Insert Sample Sprints
List <SBCategory> catsForSprints = context.Categories.ToList();
for (int i = 0; i < 5; i++)
{
SBSprint sprint = new SBSprint()
{
Name = "Sprint-" + i.ToString(),
Deadline = DateTime.Now.AddDays(rnd.Next(-3, 10)),
Category = catsForSprints[rnd.Next(0, catsForSprints.Count - 1)]
};
context.Sprints.Add(sprint);
}
context.SaveChanges();
#endregion
#region Insert Sample Tasks
List <SBSprint> sprintsForTasks = context.Sprints.ToList();
List <SBUser> usersForTasks = context.Users.ToList();
for (int i = 0; i < 50; i++)
{
SBTask task = new SBTask()
{
Name = FakeData.TextData.GetAlphabetical(rnd.Next(10, 140)),
CreateTime = DateTime.Now.AddHours(rnd.Next(1, 10)),
Descrp = FakeData.TextData.GetAlphabetical(rnd.Next(50, 200)),
User = usersForTasks[rnd.Next(0, usersForTasks.Count - 1)],
Sprint = sprintsForTasks[rnd.Next(0, sprintsForTasks.Count - 1)]
};
context.Tasks.Add(task);
}
context.SaveChanges();
#endregion
}
/// <summary>
/// Complete an INPUT/OUTPUT transaction
/// </summary>
/// <returns><c>true</c>, if transaction was completed, <c>false</c> otherwise.</returns>
/// <param name="transaction_code">Transaction code.</param>
/// <param name="apply_price_rules">If set to <c>true</c> apply price rules.</param>
public static bool CompleteTransaction(string transaction_code, bool apply_price_rules = false)
{
try
{
SBTransaction transaction = new SBTransaction(transaction_code);
Hashtable tt = SBWarehouse.GetTransactionType(transaction.TransactionTypeId);
//check if it's an input
if (tt["in_out"].ToString().ToUpper() == "IN" || tt["in_out"].ToString().ToUpper() == "INPUT")
{
//update stocks
foreach (Hashtable item in transaction.Items)
{
SBProduct prod = new SBProduct();
prod.GetDbData(item["object_code"]);
prod.Quantity = prod.Quantity + Convert.ToInt32(item["object_quantity"]);
prod.Cost = Convert.ToDouble(item["object_price"]);
/*
* //check to apply price rules
* if( apply_price_rules )
* {
* //update product prices
* double _price = SBWarehouse.GetPriceFromPriceRule((float)prod.Cost, "price_1");
* if( _price != prod.Cost )
* prod.Price = _price;
* _price = SBWarehouse.GetPriceFromPriceRule((float)prod.Cost, "price_2");
* if( _price != prod.Cost )
* prod.Price2 = _price;
* //we need to round decimals to next integer for prices
* prod.Price = Math.Ceiling(prod.Price);
* prod.Price2 = Math.Ceiling(prod.Price2);
* }
* else
* {
* }
*/
//string p_code = prod.Code;
prod.Update();
string real_cost_str = SBMeta.GetMeta("transaction_item_meta",
"transaction_item_id", Convert.ToInt32(item["transaction_item_id"]),
"_real_cost"
).ToString();
float real_cost = 0;
float.TryParse(real_cost_str, out real_cost);
SBMeta.UpdateMeta("product_meta",
"product_code", prod.Code,
"_real_cost", real_cost.ToString("0.00")
);
//##get latest two cost of the product for weighted average inventory
float weighted_cost = 0;
string query = "SELECT unit_price FROM product_kardex " +
"WHERE transaction_type_id = {0} " +
"AND product_code = '{1}' " +
"ORDER BY creation_date DESC " +
"LIMIT 2";
query = string.Format(query, transaction.TransactionTypeId, item["object_id"].ToString());
//Console.WriteLine(query);
var costs = SBFactory.getDbh().Query(query);
if (costs != null)
{
float total_cost = 0;
foreach (Hashtable row in costs)
{
total_cost += Convert.ToSingle(row["unit_price"]);
}
weighted_cost = total_cost / 2;
}
//##get fifo cost
float cost_fifo = 0;
//##build data to create product kardex
Hashtable k = new Hashtable();
k.Add("product_code", prod.Id);
k.Add("quantity", item["object_quantity"]);
k.Add("quantity_balance", prod.Quantity);
k.Add("unit_price", item["object_price"]);
k.Add("cost", item["object_price"]);
k.Add("cost_fifo", cost_fifo);
k.Add("cost_weighted_average", weighted_cost);
k.Add("total_amount", item["total"]);
k.Add("monetary_balance", prod.Quantity * Convert.ToSingle(item["object_price"]));
k.Add("author_id", SBUser.getLoggedInUser().UserId);
k.Add("creation_date", DateTime.Now);
k.Add("transaction_code", transaction.TransactionCode);
if (prod.Status.ToLower() == "initial")
{
//create initial kardex
k.Add("in_out", "initial");
k.Add("transaction_type_id", -1);
prod.Status = "publish";
prod.Update();
}
else
{
//update product kardex
k.Add("in_out", "input");
k.Add("transaction_type_id", tt["transaction_type_id"]);
}
SBFactory.getDbh().insert("product_kardex", k);
}
//update transaction status to completed|received
string tquery = string.Format("UPDATE transactions SET status = 'received' WHERE transaction_code = '{0}'",
transaction.TransactionCode);
SBFactory.getDbh().Execute(tquery);
}
//##complete OUTPUT transaction
else
{
foreach (Hashtable item in transaction.Items)
{
//##update product stock
SBProduct prod = new SBProduct(Convert.ToInt32(item["object_id"]));
prod.Quantity = prod.Quantity - Convert.ToInt32(item["object_quantity"]);
string p_code = prod.Code;
prod.Update();
//##update product kardex
Hashtable k = new Hashtable();
k.Add("product_code", prod.Id);
k.Add("in_out", "output");
k.Add("quantity", item["object_quantity"]);
k.Add("quantity_balance", prod.Quantity);
k.Add("cost", prod.Cost);
k.Add("cost_fifo", 0); //TODO: calculated fifo cost
k.Add("cost_weighted_average", 0); //TODO: calculate average cost
k.Add("unit_price", Convert.ToSingle(item["object_price"]));
k.Add("total_amount", item["sub_total"]);
k.Add("monetary_balance", prod.Quantity * prod.Cost);
k.Add("transaction_type_id", tt["transaction_type_id"]);
k.Add("author_id", SBUser.getLoggedInUser().UserId);
k.Add("creation_date", DateTime.Now);
k.Add("transaction_code", transaction.TransactionCode);
SBFactory.getDbh().insert("product_kardex", k);
}
}
return(true);
}
catch (Exception e)
{
(SBGlobals.getVar("app") as SBApplication).logString(e.Message);
(SBGlobals.getVar("app") as SBApplication).logString(e.StackTrace);
throw e;
}
}
