public static DBgl_WorkflowCollection GetAllItem()
{
string key = SETTINGS_ALL_KEY;
object obj2 = dtpCache.Get(key);
if ((obj2 != null))
{
return((DBgl_WorkflowCollection)obj2);
}
DBgl_WorkflowCollection ItemCollection = new DBgl_WorkflowCollection();
Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection);
DbCommand dbCommand = db.GetStoredProcCommand("gl_Workflow_GetAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBgl_Workflow item = GetItemFromReader(dataReader);
ItemCollection.Add(item);
}
}
dtpCache.Max(key, ItemCollection);
return(ItemCollection);
}
public static DBgl_WorkflowCollection GetAllItemByCreatedUser(string createdUser)
{
string key = String.Format(SETTINGS_CreatedUser_KEY, createdUser);
object obj2 = dtpCache.Get(key);
if ((obj2 != null))
{
return((DBgl_WorkflowCollection)obj2);
}
DBgl_WorkflowCollection ItemCollection = new DBgl_WorkflowCollection();
Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection);
DbCommand dbCommand = db.GetStoredProcCommand("gl_Workflow_GetAllByCreatedUser");
db.AddInParameter(dbCommand, "CreatedUser", DbType.String, createdUser);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBgl_Workflow item = GetItemFromReader(dataReader);
ItemCollection.Add(item);
}
}
dtpCache.Max(key, ItemCollection);
return(ItemCollection);
}
public static DBgl_WorkflowCollection GetItemPagging(int page, int rec, string strSearch, out int TotalRecords)
{
TotalRecords = 0;
DBgl_WorkflowCollection ItemCollection = new DBgl_WorkflowCollection();
Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection);
DbCommand dbCommand = db.GetStoredProcCommand("gl_Workflow_Paging");
db.AddInParameter(dbCommand, "Page", DbType.Int32, page);
db.AddInParameter(dbCommand, "RecsPerPage", DbType.Int32, rec);
db.AddInParameter(dbCommand, "SearchValue", DbType.String, strSearch);
db.AddOutParameter(dbCommand, "TotalRecords", DbType.Int32, 0);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBgl_Workflow item = GetItemFromReader(dataReader);
ItemCollection.Add(item);
}
}
TotalRecords = Convert.ToInt32(db.GetParameterValue(dbCommand, "@TotalRecords"));
return(ItemCollection);
}
public static string GetJson(DBgl_WorkflowCollection itemCollection, bool showAmount)
{
System.Text.StringBuilder builder = new System.Text.StringBuilder();
if (itemCollection.Count > 0)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(sb);
using (JsonWriter jsonWriter = new JsonTextWriter(sw))
{
jsonWriter.Formatting = Formatting.Indented;
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName("results");
jsonWriter.WriteStartArray();
itemCollection.ForEach(delegate(DBgl_Workflow objItem)
{
jsonWriter.WriteStartObject();
jsonWriter.WritePropertyName("WorkflowID");
jsonWriter.WriteValue(objItem.WorkflowID.ToString());
jsonWriter.WritePropertyName("WStatus");
jsonWriter.WriteValue(objItem.WStatus.ToString());
jsonWriter.WritePropertyName("CreatedDate");
jsonWriter.WriteValue(objItem.CreatedDate.ToString());
jsonWriter.WritePropertyName("CreatedUser");
jsonWriter.WriteValue(objItem.CreatedUser.ToString());
jsonWriter.WritePropertyName("Published");
jsonWriter.WriteValue(objItem.Published.ToString());
jsonWriter.WritePropertyName("WorkflowName");
jsonWriter.WriteValue(objItem.WorkflowName.ToString());
jsonWriter.WritePropertyName("Linkname");
jsonWriter.WriteValue(HtmlTag.FilterVietkey(objItem.WorkflowName.ToString().Replace(" ", "").Replace(":", "")));
jsonWriter.WritePropertyName("SmallDesc");
jsonWriter.WriteValue(objItem.SmallDesc.ToString());
jsonWriter.WritePropertyName("FromDate");
jsonWriter.WriteValue(objItem.FromDate.ToShortDateString());
jsonWriter.WritePropertyName("ToDate");
jsonWriter.WriteValue(objItem.ToDate.ToShortDateString());
//jsonWriter.WritePropertyName("DFromDate");
//jsonWriter.WriteValue(MainFunction.ShowDayTime(objItem.FromDate));
//jsonWriter.WritePropertyName("DToDate");
//jsonWriter.WriteValue(MainFunction.ShowDayTime(objItem.ToDate));
if (showAmount)
{
jsonWriter.WritePropertyName("BudgetAmt");
jsonWriter.WriteValue(objItem.BudgetAmt.ToString());
jsonWriter.WritePropertyName("ReceiveAmt");
jsonWriter.WriteValue(objItem.ReceiveAmt.ToString());
jsonWriter.WritePropertyName("PaymentAmnt");
jsonWriter.WriteValue(objItem.PaymentAmnt.ToString());
jsonWriter.WritePropertyName("CashOnHandAmt");
jsonWriter.WriteValue(objItem.CashOnHandAmt.ToString());
}
jsonWriter.WritePropertyName("Members");
jsonWriter.WriteValue(objItem.Members.ToString());
jsonWriter.WritePropertyName("isClose");
jsonWriter.WriteValue(objItem.isClose.ToString());
jsonWriter.WritePropertyName("Ratting");
jsonWriter.WriteValue(objItem.Ratting.ToString());
jsonWriter.WritePropertyName("ImgUrl");
jsonWriter.WriteValue(objItem.ImgUrl.ToString());
jsonWriter.WritePropertyName("SharingType");
jsonWriter.WriteValue(objItem.SharingType.ToString());
jsonWriter.WriteEndObject();
});
jsonWriter.WriteEndArray();
jsonWriter.WriteEndObject();
builder.AppendLine(sw.ToString());
}
}
else
{
//builder.AppendLine(@"{""results"":[{""id"":""-1"",""myvalue"":""" + MainFunction.ngonngu("gl.nodata") + @"""}]}");
}
return(builder.ToString());
}
