public int SetRejection(ProductionRejectionDBModel model)
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Ref", model.RefNo),
new SqlParameter("@ProdDateTime", DateTime.Now),
new SqlParameter("@LocationRef", model.LocationRef),
new SqlParameter("@Grade", model.Grade),
new SqlParameter("@SKUCode", model.SKUCode.ToString()),
new SqlParameter("@SKUQuantiy", model.ProducedQty),
new SqlParameter("@AddedBy", model.AddedBy)
};
try
{
int count = ExecuteNonQuery(CommandType.StoredProcedure, "bimob.dbo.USP_Rejectionentry", param);
return(count);
}
catch (Exception ex)
{
//ErrorSignal.FromCurrentContext().Raise(ex);
throw ex;
}
}
public int SetRejection(ProductionRejectionDBModel model)
{
try
{
//model.RefNo = "Test Ref";
string url = RepositorySettings.BaseURl + "Rejection";
HttpClient client = new HttpClient();
HttpContent contentPost = new StringContent(JsonConvert.SerializeObject(model), Encoding.UTF8,
"application/json");
HttpResponseMessage result = client.PostAsync(url, contentPost).Result;
var aproves = JsonConvert.DeserializeObject <int>(result.Content.ReadAsStringAsync().Result);
return(aproves);
}
catch (Exception ex)
{
string msg = ex.Message;
return(0);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
if (atvReference.Text == "")
{
Toast.MakeText(this, "Please Select an item first", ToastLength.Long).Show();
return;
}
List <RecentPR> prs = DBAccess.Database.RecentPRs.Result.Where(t => t.EntryType == (int)EntryType.Rejection).ToList();
if (prs.Where(t => t.RefID == atvReference.Text).Count() == 0)
{
DBAccess.Database.SaveRecentPR(new DAL.RecentPR {
RefID = atvReference.Text, LocationRef = tvLocation.Text, EntryType = (int)EntryType.Rejection
});
prs = DBAccess.Database.RecentPRs.Result.Where(t => t.EntryType == (int)EntryType.Rejection).ToList();
if (prs.Count == 6)
{
DBAccess.Database.DeleteItemAsync(prs.Where(t => t.ID == 1).FirstOrDefault());
foreach (var pr in prs)
{
pr.ID = pr.ID - 1;
DBAccess.Database.SaveRecentPR(pr);
}
}
PopulateRecentItem();
}
ProductionAccountingDBModel model;
if (list != null)
{
model = list.Where(t => t.RefNo == atvReference.Text).First();
}
else
{
model = new ProductionAccountingDBModel {
LocationRef = DBAccess.Database.RecentPRs.Result.Where(t => t.RefID == atvReference.Text).First().LocationRef
}
};
//gifView.Visibility = ViewStates.Visible;
var progressDialog = ProgressDialog.Show(this, null, "Please Wait.", true);
var refid = atvReference.Text;
var qty = Convert.ToInt16(etQty.Text);
var userCode = bitopiApplication.User.UserCode;
//new Thread(new ThreadStart(() =>
//{
ProductionRejectionDBModel dbmodel = new ProductionRejectionDBModel();
dbmodel.RefNo = atvReference.Text;
dbmodel.LocationRef = DBAccess.Database.RecentHistory.Result.LocationID;
dbmodel.Grade = etGrade.Text;
//dbmodel.SKUCode = Convert.ToInt16(etSKUCode.Text);
dbmodel.ProducedQty = Convert.ToInt16(etQty.Text);
dbmodel.AddedBy = bitopiApplication.User.UserCode;
var result = repo.SetRejection(dbmodel);
RunOnUiThread(() =>
{
if (result > 0)
{
if (SelectedPRStatus != "")
{
LoadList(SelectedPRStatus);
}
LoadSelectedList(atvReference.Text);
progressDialog.Dismiss();
Toast.MakeText(this, "Successfully Saved", ToastLength.Long).Show();
}
else
{
progressDialog.Dismiss();
Toast.MakeText(this, "Unsuccessfull operation", ToastLength.Long).Show();
}
//gifView.Visibility = ViewStates.Gone;
});
//})).Start();
}
public int SetRejection(ProductionRejectionDBModel model)
{
int result = Context.SetRejection(model);
return(result);
}
