public static List <CollectionDMCMHeader> GetCollection(string criteria)
{
var dbUtil = new DatabaseManager();
var collection = new List <CollectionDMCMHeader>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spGetCollectionDMCMDateRange";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@criteria", criteria);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var col = new CollectionDMCMHeader
{
ID = ReferenceEquals(reader["id"], DBNull.Value) ? 0 : Convert.ToInt32(reader["id"]),
dateprocessFrom = ReferenceEquals(reader["dateprocessFrom"], DBNull.Value) ? "" : Convert.ToString(reader["dateprocessFrom"]),
dateprocessTo = ReferenceEquals(reader["dateprocessTo"], DBNull.Value) ? "" : Convert.ToString(reader["dateprocessTo"]),
};
collection.Add(col);
}
return(collection);
}
}
}
}
public static string SaveCollectionDMCM(NameValueCollection querystring, NameValueCollection formdata)
{
string isInsert = querystring.Get("act");
int ID = int.TryParse(querystring.Get("id"), out ID) ? ID : 0;
UserProfile userprofile = WebCommon.GetUserProfile();
var collectionDetails = new List <CollectionDMCMDetail>();
if (formdata["DMCMData"] != "error")
{
collectionDetails = (List <CollectionDMCMDetail>)collectionDetails.ToClass(formdata["DMCMData"]);
}
var collectionHeaders = new CollectionDMCMHeader
{
ID = ID,
dateprocessFrom = querystring.Get("dfDMCMColDateGen"),
dateprocessTo = querystring.Get("dtDMCMColDateGen"),
CollectionDMCMDetails = collectionDetails
};
string param = WebCommon.ToXML(collectionHeaders);
return(CollectionDMCMDAL.SaveDMCMDetail(param, isInsert));
}
