LOV createLOVWithItems(CompanyModel company, int numItemsToAdd)
{
LOV lov = new LOV {
LOVName = RandomString(),
MultiTenanted = true,
Enabled = true
};
db.InsertOrUpdateLOV(lov);
// Now add some items
for (int i = 0; i < numItemsToAdd; i++)
{
LOVItem newItem = new LOVItem {
LovId = lov.Id,
CompanyId = company.Id,
ItemText = RandomString(),
OrderNo = i + 1,
Enabled = true
};
db.InsertOrUpdateLOVItem(newItem);
}
return(lov);
}
public static SelectList LOVList(string LOVType, object selectedItem, string parentValue)
{
LOV selectLOV = new LOV()
{
LOV_Value = " ", LOV_Display_Value = " -- Select Value ---"
};
IEnumerable <LOV> selectList = new LOV[] { selectLOV };
ILibrary <LOV> lib = new LOVLibrary(ConfigurationHelper.GetsmARTDBContextConnectionString());
IEnumerable <LOV> result;
if (!string.IsNullOrEmpty(parentValue))
{
result = ((LOVLibrary)lib).GetByParentValue(parentValue);
}
else
{
result = ((LOVLibrary)lib).GetByLOVType(LOVType);
}
result = result.OrderBy(o => o.LOV_Display_Value);
selectList = selectList.Concat <LOV>(result);
SelectList sList = new SelectList(selectList, "LOV_Value", "LOV_Display_Value", selectedItem);
return(sList);
}
public HttpResponseMessage PutLOV(int id, LOV item)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
if (id != item.LOVID)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
db.Entry(item).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public LOV GetLOV(int id)
{
var items = db.LOVs;
LOV item = items.Where(p => p.LOVID == id).FirstOrDefault();
if (item == null)
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(item);
}
LOVItemModel createLOVItem(CompanyModel company, LOV lov)
{
LOVItemModel model = new LOVItemModel {
CompanyId = company.Id,
LovId = lov.Id,
ItemText = RandomString(),
ItemValue1 = RandomString().Left(16),
ItemValue2 = RandomString().Left(16),
Enabled = true
};
return(model);
}
private void ChooseOrder()
{
MySqlCommand sc = new MySqlCommand("select * from raw_purchase_order_tab", con);
LOV lov = new LOV(sc);
lov.Text = "Choose Order";
lov.ShowDialog();
if (lov.DialogResult == DialogResult.OK)
{
DataRowView row = lov.selectedRow;
string orderId = row.Row.ItemArray[0].ToString();
txtOrderId.Text = orderId;
txtNetValue.Text = getTotal(txtOrderId.Text).ToString();
}
}
public HttpResponseMessage PostLOV(LOV item)
{
if (ModelState.IsValid)
{
db.LOVs.Add(item);
db.SaveChanges();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, item);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = item.LOVID }));
return(response);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
private void ChooseSupplier()
{
MySqlCommand sc = new MySqlCommand("select * from raw_supplier_tab", con);
LOV lov = new LOV(sc);
lov.Text = "Choose Supplier";
lov.ShowDialog();
if (lov.DialogResult == DialogResult.OK)
{
DataRowView row = lov.selectedRow;
string supplierId = row.Row.ItemArray[0].ToString();
string supplierName = row.Row.ItemArray[1].ToString();
txtSupplierId.Text = supplierId;
txtSupplierName.Text = supplierName;
}
}
public void MoveLOVItemDownTest()
{
// Check that moving an item down an LOV order list is correctly maintained
int numItems = 5;
var user = GetTestUser();
var testCompany = GetTestCompany(user);
List <string> excludes = new List <string>();
excludes.Add("OrderNo"); // Exclude this because it will change in these tests
// Create a new LOV
LOV lov = createLOVWithItems(testCompany, numItems);
LOVListModel model = LookupService.FindLOVItemsModel(testCompany.Id, 0, lov.Id, 1, PageSize, "");
// Move the last item up one place
int idx = 0;
LookupService.MoveLOVItemDown(testCompany, lov.Id, model.Items[idx].Id);
LOVListModel test = LookupService.FindLOVItemsModel(testCompany.Id, 0, lov.Id, 1, PageSize, "");
idx++;
AreEqual(model.Items[0], test.Items[1], excludes);
int expectedOrderNo = idx + 1,
actualOrderNo = test.Items[idx].OrderNo;
Assert.IsTrue(actualOrderNo == expectedOrderNo, $"Error: OrderNo is {actualOrderNo} when {expectedOrderNo} was expected");
// Now move it to the top and check that it got there
while (idx < numItems)
{
LookupService.MoveLOVItemDown(testCompany, lov.Id, test.Items[idx].Id);
test = LookupService.FindLOVItemsModel(testCompany.Id, 0, lov.Id, 1, PageSize, "");
idx++;
}
AreEqual(model.Items[0], test.Items[numItems - 1], excludes);
// Now try to move it down again (shouldn't move beyond end)
LookupService.MoveLOVItemDown(testCompany, lov.Id, test.Items[0].Id);
test = LookupService.FindLOVItemsModel(testCompany.Id, 0, lov.Id, 1, PageSize, "");
AreEqual(model.Items[0], test.Items[numItems - 1], excludes);
}
public HttpResponseMessage DeleteLOV(int id)
{
LOV item = db.LOVs.Find(id);
if (item == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
db.LOVs.Remove(item);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK, item));
}
private void AddOrderItem()
{
DataRowView order = rawpurchaseorderBindingSource.Current as DataRowView;
string order_id = order.Row.ItemArray[0].ToString();
MySqlCommand sc = new MySqlCommand("select * from raw_item_tab where item_id NOT IN (SELECT item_id FROM RAW_ORDER_LINE_TAB WHERE order_id = @order_id)", con);
sc.Parameters.AddWithValue("@order_id", order_id);
LOV lov = new LOV(sc);
lov.Text = "Choose Item";
lov.ShowDialog();
if (lov.DialogResult == System.Windows.Forms.DialogResult.OK)
{
DataRowView r = lov.selectedRow;
string itemId = r.Row.ItemArray[0].ToString();
string itemName = r.Row.ItemArray[1].ToString();
DataRowView row = fKrawpurchaseorderraworderlineBindingSource.AddNew() as DataRowView;
row.Row.SetField("item_id", itemId);
row.Row.SetField("item_name", itemName);
}
}
private void AddRole()
{
DataRowView drv = userBindingSource.Current as DataRowView;
string user = drv.Row.ItemArray[0].ToString();
MySqlCommand com = new MySqlCommand("select * from role_tab where role NOT IN (select role from user_role_tab where user = @user)", con);
com.Parameters.AddWithValue("@user", user);
LOV lov = new LOV(com);
lov.Text = "Choose Role";
lov.ShowDialog();
if (lov.DialogResult == System.Windows.Forms.DialogResult.OK)
{
DataRowView row = lov.selectedRow;
string role = row.Row.ItemArray[0].ToString();
string description = row.Row.ItemArray[1].ToString();
DataRowView newrow = user_roleBindingSource.AddNew() as DataRowView;
newrow.Row.SetField("role", role);
newrow.Row.SetField("description", description);
}
}
