private void PopulateVRFs() { VRF vrf = new VRF(); grdRRF.DataSource = vrf.GetSavedVRFForDisplay(); _tblrrf = vrf.GetSavedVRFForDisplay(); grdRRF.RefreshDataSource(); }
private int SaveVRF() { var vrf = new VRF(); if (vrf.VRFExists(_storeID, _fromYear, _fromMonth, _toYear, _toMonth)) { if (XtraMessageBox.Show("VRF Exists on disk, are you sure you want to replace it?", "RRF Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return(-1); } } var rrfID = vrf.AddNewVRF(_storeID, _fromYear, _fromMonth, _toYear, _toMonth, true); var dtbl1 = new DataTable(); if (gridItemChoiceView.DataSource != null) { dtbl1 = ((DataView)gridItemChoiceView.DataSource).Table; } foreach (DataRow dr in dtbl1.Rows) { var itemID = Convert.ToInt32(dr["ID"]); var requestedqty = Convert.ToInt32(dr["QuantityOrdered"]); var storeID = int.Parse(cboStores.EditValue.ToString()); var doses = Convert.ToInt32(dr["Doses"]); var wasteFactor = Convert.ToDecimal(dr["WasteFactor"]); var targetcoverage = Convert.ToInt32(dr["TargetCoverage"]); var vacigiven = Convert.ToInt32(dr["VaccinationGiven"]); var remark = Convert.ToString(dr["Remark"]); var rrfDetail = new VRFDetail(); rrfDetail.AddNewVRFDetail(rrfID, storeID, itemID, requestedqty, doses, wasteFactor, targetcoverage, vacigiven, remark); } return(vrf.ID); }