public int Update(SqlTransaction trans, PurchaseStockModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Sm_Purchase_Stock set ");
builder.Append("scode=@scode,");
builder.Append("pscode=@pscode,");
builder.Append("number=@number,");
builder.Append("sprice=@sprice,");
builder.Append("corp=@corp,");
builder.Append("arrivalDate=@arrivalDate");
builder.Append(" where psid=@psid ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@psid", SqlDbType.NVarChar, 50), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@pscode", SqlDbType.NVarChar, 0x40), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@sprice", SqlDbType.Decimal, 9), new SqlParameter("@corp", SqlDbType.NVarChar, 0x40), new SqlParameter("@arrivalDate", SqlDbType.DateTime) };
commandParameters[0].Value = model.psid;
commandParameters[1].Value = model.scode;
commandParameters[2].Value = model.pscode;
commandParameters[3].Value = model.number;
commandParameters[4].Value = model.sprice;
commandParameters[5].Value = model.corp;
if ((model.ArrivalDate != null) && (model.ArrivalDate.ToString() != ""))
{
commandParameters[6].Value = DateTime.Parse(model.ArrivalDate);
}
else
{
commandParameters[6].Value = DBNull.Value;
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
public void stock_AddItem(ProductModel itemToAdd)
{
if (purchaseStocks.Any(x => x.ProductCode == itemToAdd.Id) && _selectedStock.ProductCode != itemToAdd.Id)
{
ConfirmationPopup form = new ConfirmationPopup((string)Application.Current.Resources["purchase_already"], header, true);
form.ShowDialog();
if (Common._isChecked)
{
PurchaseStockModel _purchaseStock = new PurchaseStockModel();
_purchaseStock.ProductName = itemToAdd.ItemName;
_purchaseStock.productCode = Convert.ToInt64(itemToAdd.Id);
purchaseStocks[rowIndex] = _purchaseStock;
lstPurchase.ItemsSource = purchaseStocks;
}
}
else
{
// if (Common._isChecked)
// {
PurchaseStockModel _purchaseStock = new PurchaseStockModel();
_purchaseStock.ProductName = itemToAdd.ItemName;
_purchaseStock.productCode = Convert.ToInt64(itemToAdd.Id);
purchaseStocks[rowIndex] = _purchaseStock;
lstPurchase.ItemsSource = purchaseStocks;
// }
}
if (_selectedStock.StockId != null)
{
_deletestocks.Add(new StockModel(_selectedStock.StockId, _purchaseData.PurchaseId.Value, _selectedStock.Quantity, _selectedStock.CostPrice, _selectedStock.SellingPrice, _selectedStock.MRP, _selectedStock.Discount, _selectedStock.BatchNo, _selectedStock.ProductCode, null));
}
}
public int Add(SqlTransaction trans, PurchaseStockModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Sm_Purchase_Stock(");
builder.Append("psid,scode,pscode,number,sprice,corp,arrivalDate)");
builder.Append(" values (");
builder.Append("@psid,@scode,@pscode,@number,@sprice,@corp,@arrivalDate)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@psid", SqlDbType.NVarChar, 50), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@pscode", SqlDbType.NVarChar, 0x40), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@sprice", SqlDbType.Decimal, 9), new SqlParameter("@corp", SqlDbType.NVarChar, 0x40), new SqlParameter("@arrivalDate", SqlDbType.DateTime) };
commandParameters[0].Value = model.psid;
commandParameters[1].Value = model.scode;
commandParameters[2].Value = model.pscode;
commandParameters[3].Value = model.number;
commandParameters[4].Value = model.sprice;
commandParameters[5].Value = model.corp;
if ((model.ArrivalDate != null) && (model.ArrivalDate.ToString() != ""))
{
commandParameters[6].Value = DateTime.Parse(model.ArrivalDate);
}
else
{
commandParameters[6].Value = DBNull.Value;
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
// PUT api/purchasestock/5
public int Put(int id, PurchaseStockModel m)
{
m.PurchaseStockId = id;
int i = PurchaseStockProvider.insertPurchaseStock(m);
return(i);
}
private void AddpurchaseItemSource(ProductModel purchaseModel)
{
PurchaseStockModel _purchaseStock = new PurchaseStockModel();
_purchaseStock.ProductName = purchaseModel.ItemName;
_purchaseStock.productCode = Convert.ToInt64(purchaseModel.Id);
purchaseStocks[rowIndex] = _purchaseStock;
lstPurchase.ItemsSource = purchaseStocks;
}
private void txtProduct_PreviewMouseDown(object sender, MouseButtonEventArgs e)
{
productPopUp.IsOpen = true;
this.IsEnabled = false;
System.Windows.Controls.ListViewItem lvi = GetAncestorByType(
e.OriginalSource as DependencyObject, typeof(System.Windows.Controls.ListViewItem)) as System.Windows.Controls.ListViewItem;
if (lvi != null)
{
lstPurchase.SelectedIndex =
lstPurchase.ItemContainerGenerator.IndexFromContainer(lvi);
rowIndex = lstPurchase.SelectedIndex;
_selectedStock = (PurchaseStockModel)lstPurchase.SelectedItem;
}
}
private void btn_remove_Click(object sender, RoutedEventArgs e)
{
PurchaseStockModel purchase = (PurchaseStockModel)lstPurchase.SelectedItem;
if (purchase.StockId != null)
{
_deletestocks.Add(new StockModel(purchase.StockId, _purchaseData.PurchaseId.Value, purchase.Quantity, purchase.CostPrice, purchase.SellingPrice, purchase.MRP, purchase.Discount, purchase.BatchNo, purchase.ProductCode, null));
}
purchaseStocks.Remove(purchase);
lstPurchase.ItemsSource = purchaseStocks;
List <PurchaseStockModel> Stocks = lstPurchase.Items.Cast <PurchaseStockModel>().Select(x => x).ToList();
ProductAmount amount = CommonFunctions.RetrunProductAmount(Stocks, purchase_cashdiscount.Text, purchase_cashdiscountDoller.Text, _taxValue, purchase_cashSubChargeAmo.Text);
netAmount.Text = Convert.ToString(CommonFunction.Common.RoundOff(amount.NetTotal == null ? Convert.ToDecimal("0.00") : Convert.ToDecimal(amount.NetTotal))); //CommonFunction.Common.RoundOff(amount.NetTotal.ToString());
totalAmount.Text = Convert.ToString(CommonFunction.Common.RoundOff(amount.TotalAmount == null ? Convert.ToDecimal("0.00") : Convert.ToDecimal(amount.TotalAmount)));
}
public static int insertPurchaseStock(PurchaseStockModel s)
{
try
{
SqlHandler sql = new SqlHandler();
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@PurchaseStockId", s.PurchaseStockId));
parameter.Add(new KeyValuePair <string, object>("@PurchaseStockGrossWt", s.PurchaseStockGrossWt));
parameter.Add(new KeyValuePair <string, object>("@PurchaseStockNetWt", s.PurchaseStockNetWt));
parameter.Add(new KeyValuePair <string, object>("@AmountPaid", s.AmountPaid));
parameter.Add(new KeyValuePair <string, object>("@StockId", s.StockId));
parameter.Add(new KeyValuePair <string, object>("@PaymentType", s.PaymentType));
parameter.Add(new KeyValuePair <string, object>("@PurchaseInvoiceNo", s.PurchaseInvoiceNo));
parameter.Add(new KeyValuePair <string, object>("@Amount", s.Amount));
parameter.Add(new KeyValuePair <string, object>("@CrAcccountId", s.AccountId));
parameter.Add(new KeyValuePair <string, object>("@FinancialYearId", s.FinancialYearId));
parameter.Add(new KeyValuePair <string, object>("@CompanyId", s.CompanyId));
parameter.Add(new KeyValuePair <string, object>("@insertBy", s.InsertBy));
parameter.Add(new KeyValuePair <string, object>("@insertDate", s.InsertDate));
parameter.Add(new KeyValuePair <string, object>("@DrAccountId", s.PaidBy));
parameter.Add(new KeyValuePair <string, object>("@Gold", s.DueGold));
parameter.Add(new KeyValuePair <string, object>("@PaidGold", s.PaidGold));
parameter.Add(new KeyValuePair <string, object>("@transactionId", 0));
int i = sql.ExecuteNonQueryI("Usp_AddPurchaseStockDetails", parameter);
return(i);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
List <string> listFromJson = JsonHelper.GetListFromJson(this.hfldPurchaseplanChecked.Value);
if (this.ViewState["modifyStockAction"].ToString() == "edit")
{
List <string> list = new List <string>();
if (this.ViewState["modifyStockIds"] != null)
{
list = (List <string>) this.ViewState["modifyStockIds"];
}
List <string> listFromJson2 = JsonHelper.GetListFromJson(this.hfldModifyStockId.Value);
foreach (string current in listFromJson2)
{
if (!string.IsNullOrEmpty(current))
{
list.Add(current);
}
}
this.ViewState["modifyStockIds"] = list;
}
List <string> listFromJson3 = JsonHelper.GetListFromJson(this.hfldPurchaseIds.Value);
List <string> list2 = new List <string>();
List <string> list3 = new List <string>();
foreach (string current2 in listFromJson3)
{
DataTable infoByPurchaseId = this.balanceStock.GetInfoByPurchaseId(current2);
if (infoByPurchaseId.Rows.Count > 0)
{
PurchaseStockModel model = this.purchaseStock.GetModel(current2);
if (model != null)
{
list3.Add(model.scode);
listFromJson.Remove(model.scode);
}
if (this.ViewState["modifyStockIds"] != null)
{
list2 = (List <string>) this.ViewState["modifyStockIds"];
DataTable infoByModifyId = this.modifyStock.GetInfoByModifyId(this.hfldModifyId.Value);
if (infoByModifyId.Rows.Count > 0)
{
DataRow[] array = infoByModifyId.Select("PurchaseId='" + current2 + "'");
DataRow[] array2 = array;
for (int i = 0; i < array2.Length; i++)
{
DataRow dataRow = array2[i];
string item = dataRow["ModifyStockId"].ToString();
list2.Remove(item);
}
}
}
this.ViewState["modifyStockIds"] = list2;
}
}
this.UpdatePurchaseplanStockDataSource();
this.DeleteResource(listFromJson);
if (list3.Count > 0)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("alert('编号为");
foreach (string current3 in list3)
{
stringBuilder.Append(current3.Trim() + ",");
}
stringBuilder.Remove(stringBuilder.Length - 1, 1);
stringBuilder.Append("的物资已经被结算，不能进行删除操作!');");
base.RegisterScript(stringBuilder.ToString());
}
this.DataBindPurchaseplanStock();
}
public void Add(SqlTransaction trans, PurchaseStockModel model)
{
this.dal.Add(trans, model);
}
public void Update(SqlTransaction trans, PurchaseStockModel model)
{
this.dal.Update(trans, model);
}
public void Update(PurchaseStockModel model)
{
this.dal.Update(null, model);
}
public void Add(PurchaseStockModel model)
{
this.dal.Add(null, model);
}
// POST api/purchasestock
public int Post(PurchaseStockModel m)
{
int i = PurchaseStockProvider.insertPurchaseStock(m);
return(i);
}
public void CommitEvent(object key)
{
string primarykey = key.ToString();
ConPayoutModify payOutModify = (from r in this.payOutSer
where r.ModifyID == primarykey
select r).FirstOrDefault <ConPayoutModify>();
BudModify budModify = (from r in this.modifySer
where r.ModifyId == payOutModify.BudModifyId
select r).FirstOrDefault <BudModify>();
budModify.Flowstate = 1;
this.modifySer.Update(budModify);
using (List <BudModifyTask> .Enumerator enumerator = (from p in this.budModifyTaskSer
where p.ModifyId == budModify.ModifyId
select p).ToList <BudModifyTask>().GetEnumerator())
{
BudModifyTask task;
while (enumerator.MoveNext())
{
task = enumerator.Current;
BudTask item = (from p in this.budTaskSer
where p.TaskId == task.TaskId
select p).FirstOrDefault <BudTask>();
if ((item != null) && (budModify.Flowstate == 1))
{
if (task.ModifyType == 0)
{
item.IsValid = true;
this.budTaskSer.Update(item);
this.budModifyTaskSer.UpdateTotal2(task.ModifyTaskId);
}
if (item.ModifyId != task.ModifyId)
{
item.ModifyId = task.ModifyId;
item.Total2 += task.Total2;
decimal?quantity = item.Quantity;
decimal num = task.Quantity;
item.Quantity = quantity.HasValue ? new decimal?(quantity.GetValueOrDefault() + num) : null;
if (item.Quantity != 0M)
{
item.UnitPrice = item.Total2 / item.Quantity;
}
this.budTaskSer.Update(item);
this.budModifyTaskSer.UpdateTotal2(task.ModifyTaskId);
}
}
}
}
string cmdText = string.Format(" SELECT * FROM Con_Modify_Stock where ModifyId='{0}' ", primarykey);
if (SqlHelper.ExecuteQuery(CommandType.Text, cmdText, null).Rows.Count != 0)
{
string str2 = string.Format("SELECT ModifyStock.*FROM Con_Modify_Stock ModifyStock\r\n INNER JOIN Sm_Purchase_Stock purchaseStock ON ModifyStock.purchaseId=purchaseStock.psid\r\n WHERE ModifyId='{0}'", primarykey);
DataTable table2 = SqlHelper.ExecuteQuery(CommandType.Text, str2, null);
string str3 = string.Format("SELECT purchaseStock.* FROM Sm_Purchase_Stock purchaseStock \r\n LEFT JOIN (SELECT *FROM Con_Modify_Stock where ModifyId='{0}') ModifyStock\r\n ON purchaseStock.psid=ModifyStock.purchaseId\r\n WHERE purchaseStock.pscode in (SELECT DISTINCT Pscode FROM Con_Modify_Stock WHERE ModifyId='{0}')\r\n AND ModifyStockId IS NULL", primarykey);
DataTable table3 = SqlHelper.ExecuteQuery(CommandType.Text, str3, null);
string str4 = string.Format("SELECT ModifyStock.* FROM Con_Modify_Stock ModifyStock\r\n LEFT JOIN Sm_Purchase_Stock purchaseStock ON ModifyStock.purchaseId=purchaseStock.psid\r\n WHERE ModifyId='{0}'AND psid IS NULL", primarykey);
DataTable table4 = SqlHelper.ExecuteQuery(CommandType.Text, str4, null);
using (SqlConnection connection = new SqlConnection(SqlHelper.ConnectionString))
{
connection.Open();
SqlTransaction trans = connection.BeginTransaction();
foreach (DataRow row in table2.Rows)
{
PurchaseStockModel model = new PurchaseStockModel {
psid = row["PurchaseId"].ToString(),
sprice = DBHelper.GetDecimal(row["Sprice"]),
number = DBHelper.GetDecimal(row["Quantity"]),
corp = DBHelper.GetString(row["Corp"])
};
if (row["ArrivalDate"] != null)
{
model.ArrivalDate = row["ArrivalDate"].ToString();
}
else
{
model.ArrivalDate = null;
}
model.pscode = row["Pscode"].ToString();
model.scode = row["Scode"].ToString();
this.purchaseSotck.Update(trans, model);
}
foreach (DataRow row2 in table3.Rows)
{
this.purchaseSotck.Delete(trans, row2["psid"].ToString());
}
foreach (DataRow row3 in table4.Rows)
{
PurchaseStockModel model2 = new PurchaseStockModel {
psid = row3["PurchaseId"].ToString(),
sprice = DBHelper.GetDecimal(row3["Sprice"]),
number = DBHelper.GetDecimal(row3["Quantity"]),
corp = DBHelper.GetString(row3["Corp"])
};
if (row3["ArrivalDate"] != null)
{
model2.ArrivalDate = row3["ArrivalDate"].ToString();
}
else
{
model2.ArrivalDate = null;
}
model2.pscode = row3["Pscode"].ToString();
model2.scode = row3["Scode"].ToString();
this.purchaseSotck.Add(trans, model2);
}
trans.Commit();
return;
}
}
string str5 = string.Format("\r\n\t\t\t\t\t\t\t\t\tSELECT PCode FROM Sm_Purchase purchase\r\n\t\t\t\t\t\t\t\t\tINNER JOIN Con_Payout_Modify payoutModify ON purchase.Contract=payoutModify.ContractId\r\n\t\t\t\t\t\t\t\t\tWHERE ModifyId='{0}' AND purchase.FlowState=1", primarykey);
DataTable table5 = SqlHelper.ExecuteQuery(CommandType.Text, str5, null);
if (table5.Rows.Count > 0)
{
using (SqlConnection connection2 = new SqlConnection(SqlHelper.ConnectionString))
{
connection2.Open();
SqlTransaction transaction2 = connection2.BeginTransaction();
foreach (DataRow row4 in table5.Rows)
{
this.purchaseSotck.DeleteByPscode(transaction2, row4["PCode"].ToString());
}
transaction2.Commit();
}
}
}
