public FrequencyModel GetFrequencyByID(int id)
{
FrequencyModel obj = new FrequencyModel();
obj.Id = id;
return((FrequencyModel)ManageFrequency(ManageFrequencyAction.GetbyID, obj));
}
public ActionResult FrequencyUpdate(FrequencyModel obj1)
{
if (ModelState.IsValid)
{
fm.Frequency_Nm = obj1.Frequency_Nm;
fm.Status = obj1.Status;
fm.Id = obj1.Id;
new FrequencyDataRepository().UpdateFrequency(fm);
return(RedirectToAction("Frequencylist"));
}
return(View());
}
public PrecisionMinPriorityTree(params string[] strs)
{
TripCache = new Dictionary <string, FrequencyModel>();
//寻找最大字符串长度
for (int i = 0; i < strs.Length; i += 1)
{
if (MaxLength < strs[i].Length)
{
MaxLength = strs[i].Length;
}
//创建字符串的字符频次缓存
TripCache[strs[i]] = new FrequencyModel(strs[i]);
}
}
public int DeleteFrequency(int id)
{
try
{
FrequencyModel obj1 = new FrequencyModel();
obj1.Id = id;
var result = ManageFrequency(ManageFrequencyAction.Delete, obj1);
return(1);
}
catch (Exception)
{
//logging
return(-1);
}
}
public ActionResult AddFrequency(FrequencyModel obj)
{
if (ModelState.IsValid)
{
fm.Id = obj.Id;
fm.Frequency_Nm = obj.Frequency_Nm;
fm.Status = obj.Status;
if (fm.Id == 0)
{
new FrequencyDataRepository().InsertFrequency(fm);
}
ViewData.Model = fm;
return(RedirectToAction("Frequencylist"));
}
return(View());
}
void SetIdAndLabelForCategory(string categoryValue, Variable variable, FrequencyModel freqModel)
{
if (variable.CodeRepresentation == null ||
variable.CodeRepresentation.Codes == null)
{
return;
}
var category = variable.CodeRepresentation.Codes.Codes
.Where(x => x.Value == categoryValue)
.Select(x => x.Category)
.FirstOrDefault();
if (category != null)
{
freqModel.CategoryId = category.Identifier;
freqModel.CategoryLabel = category.Label.Best;
}
}
public List <FrequencyModel> GetAllFrequencies()
{
List <FrequencyModel> frequencies = new List <FrequencyModel>();
try
{
SqlDataProvider db = new SqlDataProvider();
string query = "SELECT * FROM [dbo].[Frequency];";
using (SqlConnection connection = (SqlConnection)db.GetConnection())
{
connection.Open();
SqlCommand command = db.CreateCommand(query, connection);
SqlDataReader reader = db.ExecuteReader(command);
while (reader.Read())
{
FrequencyModel frequency = new FrequencyModel()
{
ID = Utilities.ParseInt(reader["ID"].ToString()),
Frequency = reader["Frequency"].ToString()
};
frequencies.Add(frequency);
}
reader.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(frequencies);
}
public FrequencyModel GetFrequencyByBudgetUID(string UID)
{
FrequencyModel frequency = new FrequencyModel();
try
{
SqlDataProvider db = new SqlDataProvider();
string query = "SELECT * FROM [dbo].[Frequency] Fr LEFT JOIN [dbo].[Budget] B ON Fr.ID WHERE Fr.ID = B.Frequency_ID WHERE B.ID = " + UID + ";";
using (SqlConnection connection = (SqlConnection)db.GetConnection())
{
connection.Open();
SqlCommand command = db.CreateCommand(query, connection);
SqlDataReader reader = db.ExecuteReader(command);
while (reader.Read())
{
frequency = new FrequencyModel()
{
ID = Utilities.ParseInt(reader["ID"].ToString()),
Frequency = reader["Frequency"].ToString()
};
}
reader.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(frequency);
}
private object ManageFrequency(ManageFrequencyAction dbAction, FrequencyModel entity)
{
try
{
object Id = System.DBNull.Value;
object FrequencyNm = System.DBNull.Value;
object Status = System.DBNull.Value;
object Action = System.DBNull.Value;
object Result = System.DBNull.Value;
switch (dbAction)
{
case ManageFrequencyAction.Selectall:
break;
case ManageFrequencyAction.GetbyID:
Id = entity.Id;
break;
case ManageFrequencyAction.Insert:
FrequencyNm = entity.Frequency_Nm;
Status = entity.Status;
break;
case ManageFrequencyAction.Delete:
Id = entity.Id;
break;
case ManageFrequencyAction.Update:
Id = entity.Id;
FrequencyNm = entity.Frequency_Nm;
Status = entity.Status;
break;
case ManageFrequencyAction.FrequencyName:
break;
default:
break;
}
var conn = new SqlConnection(Conectionstring);
conn.Open();
cmd = new SqlCommand("Frequency", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.Add("@Frequency_Id", SqlDbType.Int).Value = Id;
cmd.Parameters.Add("@Frequency_Nm", SqlDbType.VarChar).Value = FrequencyNm;
cmd.Parameters.Add("@Frequency_Status", SqlDbType.VarChar).Value = Status;
cmd.Parameters.Add("@Action", SqlDbType.VarChar).Value = dbAction.ToString();
switch (dbAction)
{
case ManageFrequencyAction.Selectall:
List <FrequencyModel> lstdata = new List <FrequencyModel>();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
lstdata.Add(new FrequencyModel
{
Id = (int)reader["Id"],
Frequency_Nm = (string)reader["Frequency_Name"],
Status = (string)reader["Status"],
});
}
}
Result = lstdata;
conn.Close();
}
break;
case ManageFrequencyAction.GetbyID:
FrequencyModel data = new FrequencyModel();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
data.Id = (int)reader["Id"];
data.Frequency_Nm = (string)reader["Frequency_Name"];
data.Status = (string)reader["Status"];
}
;
}
}
Result = data;
conn.Close();
break;
case ManageFrequencyAction.FrequencyName:
List <FrequencyModel> data1 = new List <FrequencyModel>();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
data1.Add(new FrequencyModel
{
Id = (int)reader["Value"],
Frequency_Nm = (string)reader["text"],
});
}
}
Result = data1;
conn.Close();
}
break;
case ManageFrequencyAction.Insert:
try
{
cmd.ExecuteNonQuery();
Result = 1;
}
catch (Exception ex)
{
Result = -1;
}
break;
case ManageFrequencyAction.Delete:
try
{
cmd.ExecuteNonQuery();
Result = 1;
}
catch (Exception ex)
{
Result = -1;
}
break;
case ManageFrequencyAction.Update:
try
{
cmd.ExecuteNonQuery();
Result = 1;
}
catch (Exception ex)
{
Result = -1;
}
break;
default:
break;
}
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertFrequency(FrequencyModel frequency)
{
return((int)ManageFrequency(ManageFrequencyAction.Insert, frequency));
}
public int UpdateFrequency(FrequencyModel frequency)
{
return((int)ManageFrequency(ManageFrequencyAction.Update, frequency));
}
public List <FrequencyModel> GetAllFrequencyname()
{
FrequencyModel list = new FrequencyModel();
return((List <FrequencyModel>)ManageFrequency(ManageFrequencyAction.FrequencyName, list));
}
public List <FrequencyModel> GetAllFrequency()
{
FrequencyModel list = new FrequencyModel();
return((List <FrequencyModel>)ManageFrequency(ManageFrequencyAction.Selectall, list));
}
public ActionResult Details(Guid id, string agency, Guid fileId)
{
var client = RepositoryHelper.GetClient();
// Basic variable details.
var variable = client.GetLatestItem(id, agency) as Variable;
if (variable.CodeRepresentation != null &&
variable.CodeRepresentation.Codes != null)
{
client.PopulateItem(variable.CodeRepresentation.Codes, false, ChildReferenceProcessing.PopulateLatest);
}
var model = new VariableModel()
{
Id = variable.Identifier.ToString(),
Agency = variable.AgencyId,
Name = variable.ItemName.Current,
Label = variable.Label.Current,
Description = variable.Description.Current,
ResponseUnit = variable.ResponseUnit,
AnalysisUnit = variable.AnalysisUnit,
ClassificationLevel = variable.ActiveRepresentation != null?variable.ActiveRepresentation.ClassificationLevel.ToString() : string.Empty,
Version = variable.Version,
LastUpdated = variable.VersionDate.ToShortDateString()
};
if (variable.RepresentationType == RepresentationType.Text)
{
model.RepresentationType = "Text";
}
else if (variable.RepresentationType == RepresentationType.Numeric)
{
model.RepresentationType = "Numeric";
}
else if (variable.RepresentationType == RepresentationType.Code)
{
model.RepresentationType = "Code";
}
// Summary statistics.
var facet = new GraphSearchFacet();
facet.TargetItem = variable.CompositeId;
facet.UseDistinctTargetItem = true;
facet.ItemTypes.Add(DdiItemType.VariableStatistic);
var statsId = client.GetRelationshipByObject(facet).FirstOrDefault();
if (statsId != null)
{
var stats = client.GetItem(statsId.CompositeId, ChildReferenceProcessing.Populate) as VariableStatistic;
model.Valid = stats.Valid;
model.Invalid = stats.Invalid;
model.Minimum = stats.Minimum;
model.Maximum = stats.Maximum;
model.Mean = Round(variable, stats.Mean);
model.StandardDeviation = Round(variable, stats.StandardDeviation);
foreach (var catStat in stats.UnfilteredCategoryStatistics)
{
var freqModel = new FrequencyModel();
freqModel.CategoryValue = catStat.CategoryValue;
freqModel.Frequency = catStat.Frequency;
SetIdAndLabelForCategory(catStat.CategoryValue, variable, freqModel);
model.Frequencies.Add(freqModel);
}
// Calculate bar widths.
double maxWidth = 200;
if (model.Frequencies.Count > 0)
{
double maxFrequency = model.Frequencies.Select(x => x.Frequency).Max();
foreach (var freq in model.Frequencies)
{
double w = freq.Frequency * maxWidth / maxFrequency;
freq.NormalizedWidth = ((int)w).ToString() + "px";
}
}
}
// Comments
using (var db = ApplicationDbContext.Create())
{
var comments = db.Notes.Where(x => x.File.Id == fileId &&
x.VariableAgency == agency &&
x.VariableId == id)
.Include(x => x.User);
foreach (var comment in comments)
{
model.Comments.Add(new CommentModel
{
UserName = comment.User.UserName,
Date = comment.Timestamp.ToShortDateString(),
Comment = comment.Text
});
}
}
string json = System.Web.Helpers.Json.Encode(model);
return(Content(json));
}
