private void HighlightDuplicates()
{
Dictionary <string, List <int> > dictIds = new System.Collections.Generic.Dictionary <string, List <int> >();
Dictionary <string, List <int> > dictNames = new System.Collections.Generic.Dictionary <string, List <int> >();
Dictionary <string, List <int> > dictAlias = new System.Collections.Generic.Dictionary <string, List <int> >();
Dictionary <string, List <int> > dictAliasPlural = new System.Collections.Generic.Dictionary <string, List <int> >();
foreach (System.Windows.Forms.DataGridViewRow row in dataGridViewX1.Rows)
{
if (row.IsNewRow)
{
continue;
}
string id = row.Cells[(int)ColumnNames.Id].Value == null ? "" : row.Cells[(int)ColumnNames.Id].Value.ToString();
string name = row.Cells[(int)ColumnNames.Name].Value == null ? "" : row.Cells[(int)ColumnNames.Name].Value.ToString();
string alias = row.Cells[(int)ColumnNames.Alias].Value == null ? "" : row.Cells[(int)ColumnNames.Alias].Value.ToString();
string aliasPlural = row.Cells[(int)ColumnNames.AliasPlural].Value == null ? "" : row.Cells[(int)ColumnNames.AliasPlural].Value.ToString();
LookupValue lookupValue = (LookupValue)row.Tag;
string errorDescription;
if (!lookupValue.IsValid(false, out errorDescription))
{
row.Cells[(int)ColumnNames.Id].ErrorText = errorDescription;
}
else
{
row.Cells[(int)ColumnNames.Id].ErrorText = "";
}
}
}
public async Task <IActionResult> Edit(int id, [Bind("LookupValueID,LookupID,LookupValueCode,LookupValueDesc,Attribute1,Attribute2,Attribute3,Attribute4,Attribute5,ActiveFlag")] LookupValue lookupValue)
{
if (id != lookupValue.LookupValueID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(lookupValue);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LookupValueExists(lookupValue.LookupValueID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ActiveFlag"] = new SelectList(_context.LookupValues.Where(lv => lv.ActiveFlag == GlobalData.gY).Join(_context.Lookups.Where(lu => lu.ActiveFlag == GlobalData.gY && lu.LookupCode == GlobalData.YesNo), lv => lv.LookupID, lu => lu.LookupID, (lv, lu) => new { lv.Attribute1, lv.Attribute2 }), "Attribute2", "Attribute1", lookupValue.ActiveFlag);
ViewData["LookupID"] = new SelectList(_context.Lookups, "LookupID", "ActiveFlag", lookupValue.LookupID);
return(View(lookupValue));
}
public override MicroLatticeElement EvaluatePredicate(Expr e, LookupValue lookup)
{
NAryExpr nary = e as NAryExpr;
if (nary != null &&
(nary.Fun.FunctionName.Equals("==") || nary.Fun.FunctionName.Equals("!=")))
{
Debug.Assert(nary.Args.Length == 2);
Expr arg0 = nary.Args[0], arg1 = nary.Args[1];
Variable var = null;
// Look for "x OP null" or "null OP x" where OP is "==" or "!=".
if (arg0 is IdentifierExpr && arg1 is LiteralExpr && ((LiteralExpr)arg1).Val == null)
{
var = ((IdentifierExpr)arg0).Decl;
}
else if (arg1 is IdentifierExpr && arg0 is LiteralExpr && ((LiteralExpr)arg0).Val == null)
{
var = ((IdentifierExpr)arg1).Decl;
}
if (var != null) // found the pattern
{
return(nary.Fun.FunctionName.Equals("==") ?
NullnessLatticeElement.Null :
NullnessLatticeElement.NotNull);
}
}
return(Top);
}
private string GetInsertValues(LookupValue arg, int idx)
{
string Id = (arg.Index ?? (idx + 1)).ToString(),
Name = $"'{arg.Name}'",
Description = $"N'{arg.Description}'";
List <string> insertValues = new List <string>
{
Id,
Name,
Description
};
insertValues.AddRange(
arg.OtherColumns.Select(Convert.ToBoolean)
.Select(v => v ? "1" : "0"));
if (LookupContext.Atom.AdditionalInfo.Temporal.HasTemporal.GetValueOrDefault())
{
insertValues.Add($"'{DateTime.UtcNow.ToString()}'");
insertValues.Add($"'{DateTime.UtcNow.ToString()}'");
}
if (LookupContext.Atom.AdditionalInfo.UseSoftDeletes.GetValueOrDefault())
{
insertValues.Add(arg.IsDeleted ? "1" : "0");
}
return($@"{string.Join(", ", insertValues)}");
}
public override MicroLatticeElement EvaluateExpression(Expr e, LookupValue lookup)
{
if (e is LiteralExpr && ((LiteralExpr)e).Val == null)
{
return(NullnessLatticeElement.Null);
}
return(Top);
}
public void Add <TSagaData>(string propertyName, object propertyValue)
{
entries[typeof(TSagaData)] = new LookupValue
{
PropertyName = propertyName,
PropertyValue = propertyValue
};
}
private string GetEnumDefinitionType(LookupValue element, int idx, string namePrefix)
{
return($@"
/// <summary>
/// {element.Description}
/// </summary>
[EnumMember]
{namePrefix}{element.Name} = {element.Index ?? (idx + 1)}");
}
/// <summary>
/// update multiple lines on the grid
/// </summary>
private void Save()
{
bool isOk = false;
for (int i = 0; i < dg.Rows.Count; i++)
{
if (dg.Rows[i].Cells.FromKey("TermValue").Value == null)
{
isOk = false;
}
else
{
LookupValue lv = LookupValue.GetByKey(Convert.ToInt32(dg.Rows[i].Cells.FromKey("LookupValueId").Value));
if (lv != null)
{
lv.Sort = i;
lv.Text = dg.Rows[i].Cells.FromKey("TermValue").Value.ToString();
lv.Comment = (dg.Rows[i].Cells.FromKey("Comment").Value == null ? string.Empty : dg.Rows[i].Cells.FromKey("Comment").Value.ToString());
//#ACQ8.20 Starts
TemplatedColumn col = (TemplatedColumn)dg.Rows[i].Cells.FromKey("IsTranslateRow").Column;
CheckBox cb = (CheckBox)((CellItem)col.CellItems[i]).FindControl("IsTranslateRows");
bool isTranslatable = cb.Checked;
lv.IsTranslatable = isTranslatable;
//#ACQ8.20 Ends
if (!lv.Save(SessionState.User.Id))
{
lbError.CssClass = "hc_error";
lbError.Text = LookupValue.LastError;
lbError.Visible = true;
return;
}
else
{
isOk = true;
}
}
else
{
lbError.CssClass = "hc_error";
lbError.Text = "Lookup value doesn't exists";
lbError.Visible = true;
return;
}
}
}
if (isOk) // Success
{
// Display message of success
lbError.CssClass = "hc_success";
lbError.Text = "Data saved!";
lbError.Visible = true;
}
UpdateDataView();
}
public IActionResult Get()
{
var lookup = new LookupValue()
{
Id = 1,
Name = "One"
};
return(new JsonResult(lookup));
}
protected override void SetLookupValue(LookupValue value)
{
if (value.Value != null)
{
App.WebDriver.ExecuteScript($"Xrm.Page.getAttribute('{LogicalName}').setValue([ {{ id: '{value.Value.Id}', name: '{value.Value.Name.Replace("'", @"\'")}', entityType: '{value.Value.LogicalName}' }} ])");
App.WebDriver.ExecuteScript($"Xrm.Page.getAttribute('{LogicalName}').fireOnChange()");
}
else
{
App.App.Entity.ClearValue(value.ToLookupItem(Metadata));
}
}
public async Task <IActionResult> Create([Bind("LookupValueID,LookupID,LookupValueCode,LookupValueDesc,Attribute1,Attribute2,Attribute3,Attribute4,Attribute5,ActiveFlag")] LookupValue lookupValue)
{
if (ModelState.IsValid)
{
_context.Add(lookupValue);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["LookupID"] = new SelectList(_context.Lookups, "LookupID", "LookupCode", lookupValue.LookupID);
ViewData["ActiveFlag"] = new SelectList(_context.LookupValues.Where(lv => lv.ActiveFlag == GlobalData.gY).Join(_context.Lookups.Where(lu => lu.ActiveFlag == GlobalData.gY && lu.LookupCode == GlobalData.YesNo), lv => lv.LookupID, lu => lu.LookupID, (lv, lu) => new { lv.Attribute1, lv.Attribute2 }), "Attribute2", "Attribute1", lookupValue.ActiveFlag);
return(View(lookupValue));
}
private static LookupValue CreateLookupValue(IDataRecord reader)
{
//source_code, target_concept_id, target_domain_id, validstartdate, validenddate, source_vocabulary_id, source_target_concept_id, source_validstartdate, source_validenddate, ingredient_concept_id
// 1 2 3 4 5 6 7 8 9 10
//source_code, target_concept_id, target_domain_id, validstartdate, validenddate
// 1 2 3 4 5
var sourceCode = string.Intern(reader[0].ToString().Trim());
int conceptId = -1;
if (int.TryParse(reader[1].ToString(), out var cptId))
{
conceptId = cptId;
}
if (!DateTime.TryParse(reader[3].ToString(), out var validStartDate))
{
validStartDate = DateTime.MinValue;
}
if (!DateTime.TryParse(reader[4].ToString(), out var validEndDate))
{
validEndDate = DateTime.MaxValue;
}
var lv = new LookupValue
{
ConceptId = conceptId,
SourceCode = sourceCode,
Domain = string.Intern(reader[2].ToString().Trim()),
ValidStartDate = validStartDate,
ValidEndDate = validEndDate,
Ingredients = new HashSet <int>()
};
if (reader.FieldCount > 5)
{
lv.SourceConceptId = int.TryParse(reader[6].ToString(), out var scptId) ? scptId : 0;
if (int.TryParse(reader[9].ToString(), out var ingredient))
{
lv.Ingredients.Add(ingredient);
}
}
return(lv);
}
public static string TagDelegateTwoLevel(MappingColumn column, ProcessedImportRow processedImportRow)
{
string mainCategory = processedImportRow.Row[column.TemplateColumnOrdinal - 1] == DBNull.Value ? "" : processedImportRow.Row[column.TemplateColumnOrdinal - 1].ToString().Trim();
string subCategory = processedImportRow.Row[column.TemplateColumnOrdinal] == DBNull.Value ? "" : processedImportRow.Row[column.TemplateColumnOrdinal].ToString().Trim();
//main category and all sub category is empty, we can continue with the import without categories
if (string.IsNullOrWhiteSpace(mainCategory) && string.IsNullOrWhiteSpace(subCategory))
{
column.IgnoreThisTable = true;
return("");
}
//only main Category is available
if (!string.IsNullOrWhiteSpace(mainCategory) && string.IsNullOrWhiteSpace(subCategory))
{
LookupValue categoryLookup = column.LookupValues.Where(tag => tag.Lookup == mainCategory.ToUpperInvariant()).FirstOrDefault();
if (categoryLookup != null)
{
return(categoryLookup.ReplacementId.ToString());
}
processedImportRow.AddException(new ImportDataException {
ExceptionType = ExceptionType.CategoryIsNotValid, TemplateMappingColumn = column.TemplateMappingColumn, TemplateColumnName = column.TemplateColumnName, IsValid = false
});
return("");
}
//We have main category and subcategory level 2
if (!string.IsNullOrWhiteSpace(mainCategory) && !string.IsNullOrWhiteSpace(subCategory))
{
string category = string.Format("{0}||{1}", mainCategory, subCategory).ToUpperInvariant();
LookupValue categoryLookup = column.LookupValues.Where(tag => tag.Lookup == category).FirstOrDefault();
if (categoryLookup != null)
{
return(categoryLookup.ReplacementId.ToString());
}
processedImportRow.AddException(new ImportDataException {
ExceptionType = ExceptionType.CategoryIsNotValid, TemplateMappingColumn = column.TemplateMappingColumn, TemplateColumnName = column.TemplateColumnName, IsValid = false
});
return("");
}
//All other conditions are invalid hierarchy
processedImportRow.AddException(new ImportDataException {
ExceptionType = ExceptionType.CategoryIsNotValid, TemplateMappingColumn = column.TemplateMappingColumn, TemplateColumnName = column.TemplateColumnName, IsValid = false
});
return("");
}
//private Base AddLookupValue(AddLookupValueRequest lookupValue)
//{
// Base viewModel = new Base();
// try
// {
// }
// catch (Exception exc)
// {
// viewModel.ResultInfo.Result = Base.ResultInfoDto.ResultEnum.Error;
// viewModel.ResultInfo.ErrorMessage = exc.Message;
// }
// return viewModel;
//}
private Base DeleteLookupValue(LookupValue lookupValue)
{
Base viewModel = new Base();
try
{
}
catch (Exception exc)
{
viewModel.ResultInfo.Result = Base.ResultInfoDto.ResultEnum.Error;
viewModel.ResultInfo.ErrorMessage = exc.Message;
}
return(viewModel);
}
public string ToWhereClause()
{
var sb = new StringBuilder();
if (IndexNumber == -1)
{
//temp hook to handle straight lookups
sb.Append("FILENAME " + Operator + " '" + LookupValue.Replace("'", "''") + "'");
}
else
{
sb.Append("INDEX" + IndexNumber.ToString() + " " + Operator + " '" + LookupValue.Replace("'", "''") + "'");
}
return(sb.ToString());
}
public Lookup()
{
_table = new TypologyTable();
_typology = new LookupKey(this, "Typology");
_n = new LookupValue("N", "Nitrogen", "kg/ha");
_p = new LookupValue("P", "Phosphorus", "kg/ha");
DataItems.Add(new DataItem(_table, "Table", typeof(TypologyTable),
DataItemRole.Input, "TypologyTableTag"));
DataItems.Add(new DataItem(_typology, "Typology", typeof(LookupKey),
DataItemRole.Input, "TypologyTag"));
DataItems.Add(new DataItem(_n, "N", typeof(LookupValue),
DataItemRole.Output, "NTag"));
DataItems.Add(new DataItem(_p, "P", typeof(LookupValue),
DataItemRole.Output, "PTag"));
}
public async Task UpdateUser(string userId)
{
var user = await _context.Users.FindAsync(userId);
user.LastLoggedIn = DateTime.Now;
_context.Entry(user).State = EntityState.Modified;
var apiRequests = await _context.LookupValues.Where(x => x.LookupValuesId == (long)LookupValueEnum.ApiRequests).LastOrDefaultAsync();
if (apiRequests == null)
{
await _context.LookupValues.AddAsync(new LookupValue
{
LookupValuesId = (long)LookupValueEnum.ApiRequests,
DataType = DataType.Integer,
DataValue = "1",
Updated = DateTime.Now
});
}
else
{
if (apiRequests.Updated.Date == DateTime.Today)
{
var lastApi = Convert.ToInt32(apiRequests.DataValue);
lastApi = lastApi + 1;
var newLookup = new LookupValue
{
DataType = DataType.Integer,
DataValue = lastApi.ToString(),
LookupValuesId = (long)LookupValueEnum.ApiRequests,
Updated = DateTime.Now
};
await _context.LookupValues.AddAsync(newLookup);
}
else
{
await _context.LookupValues.AddAsync(new LookupValue
{
LookupValuesId = (long)LookupValueEnum.ApiRequests,
DataType = DataType.Integer,
DataValue = "1",
Updated = DateTime.Now
});
}
}
await _context.SaveChangesAsync();
}
public void TestLookups()
{
string keyValue = "target";
string missingValue = "small sheep";
Entity lookup = new Entity("entity", Guid.NewGuid())
{
["key"] = keyValue
};
LookupValue target = new LookupValue("entity", "key");
this.context.Initialize(lookup);
Assert.AreEqual(lookup.Id, ((EntityReference)target.Convert(keyValue, this.service)).Id);
Assert.AreEqual(null, (EntityReference)target.Convert(null, this.service));
Assert.AreEqual(null, (EntityReference)target.Convert(missingValue, this.service));
}
private void SetFieldControlValue(object fieldValue)
{
if (!HasValueSet || !LookupValue.Equals(fieldValue))
{
Clear();
LookupValue = fieldValue;
HasValueSet = true;
if (DataSource != null)
{
if (DropList != null)
{
DropList.SelectedIndex = SelectedValueIndex >= 0
? SelectedValueIndex
: -1;
}
else if (TextField != null)
{
DataRowView view = null;
if (SelectedValueIndex >= 0)
{
view = _dataSource[SelectedValueIndex];
TextField.Text = view["TextField"] as string;
}
if (Page != null)
{
var strFieldValue = "0";
if (SelectedValueIndex >= 0)
{
view = _dataSource[SelectedValueIndex];
strFieldValue = ((int)view["ValueField"]).ToString(CultureInfo.InvariantCulture);
}
else if (Page.IsPostBack)
{
strFieldValue = Context.Request.Form[HiddenFieldName];
if (string.IsNullOrWhiteSpace(strFieldValue))
{
strFieldValue = "0";
}
}
Page.ClientScript.RegisterHiddenField(HiddenFieldName, strFieldValue);
}
}
}
}
}
public static int CompareByString(LookupValue x, LookupValue y)
{
if (x == null)
{
if (y == null)
{
return(0);
}
else
{
return(-1);
}
}
else
{
return(x.Description.CompareTo(y.Description));
}
}
/// <summary>
/// Handles a click on the OK button.
/// </summary>
/// <remarks>When the user clicks OK, the dialog is closed by calling
/// the <see cref="M:Sitecore.Web.UI.Sheer.ClientResponse.CloseWindow">CloseWindow</see> method.</remarks>
protected override void OK_Click()
{
var selectedValue = GridUtil.GetSelectedValue(this.Entities.ID);
if (!string.IsNullOrEmpty(selectedValue) && selectedValue != "null")
{
this.ResetMetadata();
var value = new LookupValue(this.Metadata.PrimaryKey, this.Metadata.PrimaryField, selectedValue, this.Target);
SheerResponse.SetDialogValue(value.ToString());
base.OK_Click();
}
else
{
SheerResponse.Alert(ResourceManager.Localize("SELECT_RECORD"));
}
}
public List <LookupValue> LookupValueGetByGroupName(string groupName)
{
List <LookupValue> lookupValues = null;
using (SqlConnection conn = GetNewConnection())
{
List <SqlParameter> paramColl = new List <SqlParameter>();
paramColl.Add(new SqlParameter()
{
ParameterName = "@GroupName", Value = groupName
});
using (SqlCommand command = BuildCommand(usp_LookupValue_SelectByGroup, CommandType.StoredProcedure, paramColl))
{
command.Connection = conn;
command.Connection.Open();
SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
LookupValue lookupValue = new LookupValue()
{
Id = reader.GetValueOrDefault <int>("Id"),
GroupId = reader.GetValueOrDefault <int>("GroupId"),
Name = reader.GetValueOrDefault <string>("Name"),
Value = reader.GetValueOrDefault <string>("Value"),
Description = reader.GetValueOrDefault <string>("Description"),
RowStatus = reader.GetValueOrDefault <string>("RowStatus")
};
if (lookupValues == null)
{
lookupValues = new List <LookupValue>();
}
lookupValues.Add(lookupValue);
}
reader.Close();
}
}
return(lookupValues);
}
private string GetInsertValues(LookupValue arg, int idx)
{
string Id = (arg.Index ?? (idx + 1)).ToString(),
Name = $"'{arg.Name}'",
Description = $"N'{arg.Description}'";
List <string> insertValues = new List <string>
{
Id,
Name,
Description
};
insertValues.AddRange(
arg.OtherColumns.Select(Convert.ToBoolean)
.Select(v => v ? "1" : "0"));
return($@"({string.Join(", ", insertValues)})");
}
protected override GetInitialisationDataResponse Execute(GetInitialisationDataRequest request)
{
var response = CreateTypedResponse();
var instruments = new List <LookupValue>();
for (var index = 0; index < 10; index++)
{
var instrument = new LookupValue
{
Id = index,
Value = "Instrument" + index
};
instruments.Add(instrument);
}
response.Instruments = instruments;
return(response);
}
/// <summary>
/// Delete multiple values on the grid
/// </summary>
private void Delete()
{
lbError.Visible = false;
for (int i = 0; i < dg.Rows.Count; i++)
{
TemplatedColumn col = (TemplatedColumn)dg.Rows[i].Cells.FromKey("Select").Column;
CheckBox cb = (CheckBox)((CellItem)col.CellItems[i]).FindControl("g_sd");
if (cb.Checked)
{
LookupValue lgValuesObj = LookupValue.GetByKey(Convert.ToInt32(dg.Rows[i].Cells.FromKey("LookupValueId").Text));
if (!lgValuesObj.Delete())
{
lbError.CssClass = "hc_error";
lbError.Text = LookupValue.LastError;
lbError.Visible = true;
break;
}
}
}
UpdateDataView();
}
private void btAddRow_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
lbError.Visible = false;
if (txtValue.Text.Length > 0)
{
//QC2691 Check for validation of Terms if it already exists was not there so added
TermList Termdetails = Term.GetAll("TermValue = '" + txtValue.Text + "' AND TermTypeCode='C'");
LookupValue lgValuesObj;
if (Termdetails == null || Termdetails.Count == 0) //#2712
//if (Termdetails == null) //#2712 Commented
{
lgValuesObj = new LookupValue(-1, lookupGroupId, 0, txtValue.Text, txtComment.Text, IsTranslateDefaultOption);
}
else
{
lgValuesObj = new LookupValue(-1, lookupGroupId, 0, txtValue.Text, txtComment.Text, Termdetails[0].IsTranslatable);
}
if (!lgValuesObj.Save(SessionState.User.Id))
{
lbError.CssClass = "hc_error";
lbError.Text = LookupValue.LastError;
lbError.Visible = true;
}
else
{
txtComment.Text = string.Empty;
txtValue.Text = string.Empty;
UpdateDataView();
}
}
else
{
lbError.CssClass = "hc_error";
lbError.Text = "Value cannot be empty";
lbError.Visible = true;
}
}
public override MicroLatticeElement EvaluateExpression (Expr e, LookupValue lookup)
{
if (e is LiteralExpr && ((LiteralExpr)e).Val == null)
{
return NullnessLatticeElement.Null;
}
return Top;
}
public override MicroLatticeElement EvaluatePredicate (Expr e, LookupValue lookup)
{
NAryExpr nary = e as NAryExpr;
if (nary != null &&
(nary.Fun.FunctionName.Equals("==") || nary.Fun.FunctionName.Equals("!=")))
{
Debug.Assert(nary.Args.Length == 2);
Expr arg0 = nary.Args[0], arg1 = nary.Args[1];
Variable var = null;
// Look for "x OP null" or "null OP x" where OP is "==" or "!=".
if (arg0 is IdentifierExpr && arg1 is LiteralExpr && ((LiteralExpr)arg1).Val == null)
{
var = ((IdentifierExpr)arg0).Decl;
}
else if (arg1 is IdentifierExpr && arg0 is LiteralExpr && ((LiteralExpr)arg0).Val == null)
{
var = ((IdentifierExpr)arg1).Decl;
}
if (var != null) // found the pattern
{
return nary.Fun.FunctionName.Equals("==") ?
NullnessLatticeElement.Null :
NullnessLatticeElement.NotNull;
}
}
return Top;
}
public LookupValueRepository()
{
_BodyStyles = new List <LookupValue>
{
new LookupValue {
Description = "Car"
},
new LookupValue {
Description = "SUV"
},
new LookupValue {
Description = "Truck"
},
new LookupValue {
Description = "Van"
},
};
_exteriorColors = new List <LookupValue>
{
new LookupValue {
Description = "Black"
},
new LookupValue {
Description = "Blue"
},
new LookupValue {
Description = "Brown"
},
new LookupValue {
Description = "Green"
},
new LookupValue {
Description = "Red"
},
new LookupValue {
Description = "Orange"
},
new LookupValue {
Description = "Yellow"
},
new LookupValue {
Description = "White"
},
};
_interiorColors = new List <LookupValue>
{
new LookupValue {
Description = "Black"
},
new LookupValue {
Description = "Blue"
},
new LookupValue {
Description = "Red"
},
new LookupValue {
Description = "Tan"
},
};
_price = new List <LookupValue>();
List <string> listPrice = new List <string>();
for (int i = 10000; i <= 100000; i++)
{
if (i % 5000 == 0) //5000 dollar increments
{
var x = new LookupValue {
Description = i.ToString()
};
_price.Add(x);
}
}
_purchaseTypes = new List <LookupValue>
{
new LookupValue {
Description = "Bank Finance"
},
new LookupValue {
Description = "Cash"
},
new LookupValue {
Description = "Dealer Finance"
},
};
_states = new List <LookupValue>
{
new LookupValue {
Description = "IN"
},
new LookupValue {
Description = "KY"
},
new LookupValue {
Description = "MN"
},
new LookupValue {
Description = "OH"
},
new LookupValue {
Description = "TN"
},
};
_transmissionTypes = new List <LookupValue>
{
new LookupValue {
Description = "Automatic"
},
new LookupValue {
Description = "Manual"
},
};
_userRoles = new List <LookupValue>
{
new LookupValue {
Description = "Admin"
},
new LookupValue {
Description = "Sales"
},
new LookupValue {
Description = "Disabled"
},
};
_years = new List <LookupValue>();
//Generate years between 2000 and current year + 1 as per app specs.
List <int> listYears = Enumerable.Range(2000, DateTime.Now.Year - 1998).ToList();
foreach (var i in listYears)
{
var x = new LookupValue {
Description = i.ToString()
};
_years.Add(x);
}
_condition = new List <LookupValue>
{
new LookupValue {
Description = "New"
},
new LookupValue {
Description = "Used"
}
};
}
/// <summary>
/// Populates existing information for update purpose, if it is text box then it fills the value
/// if it is dropdown list then it chooses from one of the alternatives supplied by FillControls() method
/// </summary>
private void PopulateExistingData()
{
//if (theArrival.IsNew) return;
GRNStatusNew GRNStatus;
GRNStatusNew.TryParse(theArrival.GRNStatus.ToString(), out GRNStatus);
if (GRNStatus == GRNStatusNew.New || GRNStatus == GRNStatusNew.NotCreated)
{
btnSave.Enabled = true;
}
else
{
btnSave.Enabled = false;
btnSave.ToolTip = "Can't Update Arrival because this step is at " + GRNStatus.ToString() + " Stage";
}
if (theArrival.WarehouseID != WarehouseBLL.CurrentWarehouse.WarehouseId)
{
Response.Redirect("ErrorPage.aspx");
}
try
{
lblClient.Text = theArrival.ClientName;
lblWarehouse.Text = WarehouseBLL.CurrentWarehouse.WarehouseName;
isNonTruck.Checked = theArrival.IsNonTruck;
cboCommodity.SelectedValue = theArrival.CommodityID.ToString();
//chkIsSourceDetermined.Checked = theArrival.IsLocationKnown;
if (!theArrival.IsLocationKnown)
{
cboRegion.SelectedValue = Guid.Empty.ToString();
}
else
{
LookupValue lv = SimpleLookup.Lookup(LookupTypeEnum.Woredas).GetDictionary()[theArrival.WoredaID];
cboRegion.SelectedValue = lv.RegionID.ToString();
cboRegion_SelectedIndexChanged(this, EventArgs.Empty);
cboZone.SelectedValue = lv.ZoneID.ToString();
cboZone_SelectedIndexChanged(this, EventArgs.Empty);
cboWoreda.SelectedValue = theArrival.WoredaID.ToString();
txtSpecificArea.Text = theArrival.SpecificArea;
}
cboProductionYear.SelectedValue = theArrival.ProductionYear.ToString();
txtProcessingCenter.Text = theArrival.ProcessingCenter;
txtNumberOfBags.Text = theArrival.NumberofBags.ToString() == "0" ? "" : theArrival.NumberofBags.ToString();
txtWeight.Text = theArrival.VoucherWeight.ToString() == "0" ? "" : theArrival.VoucherWeight.ToString();
if ("1/1/1901" == theArrival.DateTimeReceived.ToShortDateString() || theArrival.DateTimeReceived.ToShortDateString() == "1/1/0001")
{
txtArrivalDate.Text = "";
txtTimeArrival.Text = "";
}
else
{
txtArrivalDate.Text = theArrival.DateTimeReceived.ToShortDateString();
txtTimeArrival.Text = theArrival.DateTimeReceived.ToShortTimeString();
}
txtRemark.Text = theArrival.Remark;
if (!theArrival.IsNonTruck)
{
chkIsTruckInCompound.Checked = theArrival.IsTruckInCompound;
txtDriverName.Text = theArrival.DriverName;
txtLicenseNo.Text = theArrival.LicenseNumber;
txtPlaceIssued.Text = theArrival.LicenseIssuedPlace;
txtPlateNo.Text = theArrival.TruckPlateNumber;
txtTrailerPlateNo.Text = theArrival.TrailerPlateNumber;
txtNoPlomps.Text = theArrival.VoucherNumberOfPlomps.ToString() == "0" ? "" : theArrival.VoucherNumberOfPlomps.ToString();
txtTrailerNoPlomps.Text = theArrival.VoucherNumberOfPlompsTrailer.ToString() == "0" ? "" : theArrival.VoucherNumberOfPlompsTrailer.ToString();
}
txtVoucherNo.Text = theArrival.VoucherNumber;
hdnHasVoucher.Value = theArrival.HasVoucher.ToString();
//chkIsBiProduct.Checked = theArrival.IsBiProduct;
if (Guid.Empty == theArrival.VoucherCommodityTypeID || string.IsNullOrEmpty(theArrival.VoucherCommodityTypeID.ToString()))
{
cboCommodityType.SelectedIndex = 0;
cboCommodityType.Enabled = false;
}
else
{
cboCommodityType.SelectedValue = theArrival.VoucherCommodityTypeID.ToString();
}
}
catch (Exception ex)
{
//lblMessage.Text = "Failed to populate existing data!";
Messages.SetMessage("Existing data cannot be retrieved. Please try again.", WarehouseApplication.Messages.MessageType.Error);
}
}
protected override void Execute(CodeActivityContext context)
{
DataTable dataTable = DataTable.Get(context);
string lookupValue = LookupValue.Get(context);
DataColumn dataColumn = DataColumn.Get(context);
DataColumn targetDataColumn = TargetDataColumn.Get(context);
Int32 columnIndex = ColumnIndex.Get(context);
Int32 targetColumnIndex = ColumnIndex.Get(context);
string columnName = ColumnName.Get(context);
string targetColumnName = TargetColumnName.Get(context);
object cellValue = null;
Int32 rowIndex = 0;
try
{
int beginIndex = 0, endInex = 0;
DataColumn beginColumn = new DataColumn();
if (dataColumn != null)
{
beginIndex = dataTable.Columns.IndexOf(dataColumn);
}
else if (columnName != null && columnName != "")
{
beginIndex = dataTable.Columns.IndexOf(columnName);
}
else
{
beginIndex = columnIndex;
}
if (targetDataColumn != null)
{
endInex = dataTable.Columns.IndexOf(targetDataColumn);
}
else if (targetColumnName != null && targetColumnName != "")
{
endInex = dataTable.Columns.IndexOf(targetColumnName);
}
else
{
endInex = targetColumnIndex;
}
if (beginIndex < 0 || endInex < 0 || beginIndex > endInex)
{
SharedObject.Instance.Output(SharedObject.enOutputType.Error, "数据表列索引有误,请检查开始列与结束列");
return;
}
DataRowCollection dataRows = dataTable.Rows;
for (int index = beginIndex; index < endInex; index++)
{
foreach (DataRow datarow in dataRows)
{
object data = datarow[index];
string dataStr = data as string;
if (dataStr.Equals(lookupValue))
{
rowIndex = dataRows.IndexOf(datarow);
cellValue = data;
break;
}
}
}
if (CellValue != null)
{
CellValue.Set(context, cellValue);
}
if (RowIndex != null)
{
RowIndex.Set(context, rowIndex);
}
}
catch (Exception e)
{
SharedObject.Instance.Output(SharedObject.enOutputType.Error, "查找数据表失败", e.Message);
}
}
public bool TryGet(Type sagaType, out LookupValue value)
{
return(entries.TryGetValue(sagaType, out value));
}
