private List <Curricula> getTempSelect()
{
List <Curricula> tmp = new List <Curricula>();
foreach (GridViewRow row in gridComments.Rows)
{
try
{
CheckBox cbx = (CheckBox)row.FindControl("chkSelect");
if (cbx != null && cbx.Checked)
{
Curricula crl = Curriculas.Find(
delegate(Curricula c)
{
return(c.Id == (Guid)gridComments.DataKeys[row.RowIndex].Value);
});
if (crl != null)
{
tmp.Add(crl);
}
}
}
catch (Exception e)
{
Utils.Log(string.Format("Error processing selected row in comments data grid: {0}", e.Message));
}
}
return(tmp);
}
/// <summary>
/// Deletes a curricula from the database
/// </summary>
/// <param name="curricula">curricula to be deleted</param>
public override void DeleteCurricula(Curricula curricula)
{
string connString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
string providerName = ConfigurationManager.ConnectionStrings[connStringName].ProviderName;
DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);
using (DbConnection conn = provider.CreateConnection())
{
conn.ConnectionString = connString;
conn.Open();
using (DbCommand cmd = conn.CreateCommand())
{
string sqlQuery = "DELETE FROM " + tablePrefix + "Tags WHERE ParentID = @id and ParentType=0;" +
"DELETE FROM " + tablePrefix + "CurriculaCategorie WHERE CurriculaID = @id;" +
"DELETE FROM " + tablePrefix + "CurriculaField WHERE CurriculaID = @id;" +
"DELETE FROM " + tablePrefix + "Comments WHERE ParentID = @id and ParentType=0;" +
"DELETE FROM " + tablePrefix + "CurriculaInfo WHERE CurriculaID = @id;" +
"DELETE FROM " + tablePrefix + "Curriculas WHERE CurriculaID = @id;";
cmd.CommandText = sqlQuery;
cmd.CommandType = CommandType.Text;
DbParameter dpID = provider.CreateParameter();
dpID.ParameterName = parmPrefix + "id";
dpID.Value = curricula.Id.ToString();
cmd.Parameters.Add(dpID);
cmd.ExecuteNonQuery();
}
}
}
public static string GetAppInfo(Guid id)
{
string msg = Curricula.GetCurricula(id).IsPublished ? "已发布" : "未发布";
msg += Curricula.GetCurricula(id).IsGold ? " 金牌" : "";
return(msg);
}
private void chkMateria2_CheckedChanged(object sender, EventArgs e)
{
bool aux = HabilitarRdb(chkMateria2, rdbCursada2, rdbAprobada2);
Materia spd = new Materia(chkMateria1.Text, "95-1122", rdbCursada2.Text);
if (spd.estado == "Cursada" && aux == true)
{
/*strBld.AppendLine("Sistemas Operativos");
*
* lstMaterias.Items.Add(strBld.ToString());*/
curricula += spd;
lstMaterias.Items.Add(curricula);
}
else
{
curricula -= spd;
lstMaterias.Items.Clear();
lstMaterias.Items.Add(curricula);
/*int indexOf = lstMaterias.Items.IndexOf(strBld);
* lstMaterias.Items.RemoveAt(indexOf);
* lstMaterias.Items.Clear();
* lstMaterias.Items.Add();*/
}
}
public IActionResult DetailEdit(EditCurriculaViewModel ecvm)
{
IActionResult result = null;
// Are there errors
if (!ModelState.IsValid)
{
result = View("DetailEdit", new { id = ecvm.Id });
}
else
{
try
{
Curricula cur = new Curricula()
{
CourseId = ecvm.CourseId,
CourseSession = ecvm.CourseSession,
Description = ecvm.Description,
Id = ecvm.Id
};
_currDAL.UpdateCurricula(cur);
result = RedirectToAction("Details", "Course", new { id = cur.CourseId });
}
catch (Exception ex)
{
result = View();
}
}
return(result);
}
public Curricula ReadCurriculum()
{
Curricula curricula = ReadCurriculaID();
if (connect.State == ConnectionState.Open)
{
int k = 0;
foreach (var item in curricula.curriculum)
{
command = new SqlCommand("Select * from Curriculum where curriculum_id='" + item.id + "'", connect);
reader = command.ExecuteReader();
while (reader.Read())
{
Course1 course1 = new Course1();
course1.@ref = reader[1].ToString();
//ose
//item.course.Add(course1);
curricula.curriculum[k].course.Add(course1); //ose item.course.Add(course1);
}
reader.Close();
k++;
}
}
return(curricula);
}
private Curricula ReadCurriculaID()
{
Curricula curricula = new Curricula();
if (connect.State == ConnectionState.Open)
{
command = new SqlCommand("Select * from Curricula", connect);
try
{
reader = command.ExecuteReader();
while (reader.Read())
{
Curriculum curriculum = new Curriculum();
curriculum.id = reader[0].ToString();
curricula.curriculum.Add(curriculum);
}
reader.Close();
}
catch (Exception)
{
reader.Close();
}
}
return(curricula);
}
public Curricula GetCurricula(int id)
{
Curricula curr = new Curricula();
using (SqlConnection conn = new SqlConnection(connectionString))
{
string SQL = "SELECT c.id, c.CourseId, c.CourseSession, c.Description ";
SQL += "FROM curricula c ";
SQL += "WHERE c.id = @id ";
conn.Open();
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.Parameters.AddWithValue("@id", id);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
curr.Id = Convert.ToInt32(reader["Id"]);
curr.CourseId = Convert.ToInt32(reader["CourseId"]);
curr.CourseSession = Convert.ToInt32(reader["CourseSession"]);
curr.Description = Convert.ToString(reader["Description"]);
}
}
return(curr);
}
public IList <Curricula> GetCurriculas(int courseId)
{
IList <Curricula> currs = new List <Curricula>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
string SQL = "SELECT c.id, c.CourseId, c.CourseSession, c.Description ";
SQL += "FROM curricula c ";
SQL += "WHERE CourseId = @id ";
conn.Open();
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.Parameters.AddWithValue("@id", courseId);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var curr = new Curricula()
{
Id = Convert.ToInt32(reader["Id"]),
CourseId = Convert.ToInt32(reader["CourseId"]),
CourseSession = Convert.ToInt32(reader["CourseSession"]),
Description = Convert.ToString(reader["Description"]),
};
currs.Add(curr);
}
}
return(currs);
}
private void SetGoldCurricula(Curricula cm)
{
bool found = false;
for (int i = 0; i < Curricula.Curriculas.Count; i++)
{
if (Curricula.Curriculas[i].Id == cm.Id)
{
if (!cm.IsGold)
{
Curricula.Curriculas[i].IsGold = true;
}
else
{
Curricula.Curriculas[i].IsGold = false;
}
Curricula.Curriculas[i].DateModified = DateTime.Now;
Curricula.Curriculas[i].Save();
found = true;
break;
}
if (found)
{
break;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
_id = HttpContext.Current.Request.QueryString["id"];
if (_id != null && _id != string.Empty)
{
_curricula = Curricula.GetCurricula(new Guid(_id));
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
HtmlAnchor aPages = e.Row.Cells[0].FindControl("aPages") as HtmlAnchor;
Curricula crl = ((Curricula)e.Row.DataItem) as Curricula;
aPages.HRef = GetEditHtml(crl.Id.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
_id = HttpContext.Current.Request.QueryString["id"];
if (_id != null && _id != string.Empty)
{
_curricula = Curricula.GetCurricula(new Guid(_id));
}
}
private static void RewriteCurricula(HttpContext context, string url)
{
string slug = ExtractTitle(context, url);
Curricula page = Curricula.Curriculas.Find(p => slug.Equals(Utils.RemoveIllegalCharacters(p.Title), StringComparison.OrdinalIgnoreCase));
if (page != null)
{
context.RewritePath(Utils.RelativeWebRoot + "Curricula.aspx?id=" + page.Id + GetQueryString(context), false);
}
}
public static bool HasNoChildrenAndApped(Guid comId)
{
Curricula p = Curricula.GetCurricula(comId);
if (p.IsPublished)
{
return(false);
}
return(true);
}
private void DeleteInfo(Guid id)
{
CurriculaInfo crlinfo = CurriculaInfo.GetCurriculaInfo(id);
Curricula crl = Curricula.GetCurriculaByCurriculaInfo(id);
crl.RemoveCurriculaInfo(crlinfo);
int i = HttpContext.Current.Request.RawUrl.IndexOf('?');
Response.Redirect(HttpContext.Current.Request.RawUrl.Substring(0, i));
}
//
// GET: /VerCurricula/
public ActionResult Index(string key)
{
Curricula curricula = null;
if (!string.IsNullOrWhiteSpace(key))
{
curricula = GestionPedagogica.ObtenerCurricula(int.Parse(key));
}
return(View("Index", curricula));
}
public ActionResult Listar(string codigo, int inicio, int fin, int estado)
{
Curricula curriculaFiltro = new Curricula()
{
Codigo = codigo,
Estado = estado
};
List <Curricula> objLista = GestionPedagogica.BuscarCurricula(curriculaFiltro, inicio, fin);
return(PartialView("_Lista", objLista));
}
/// <summary>
/// Создает План занятий с объединением планов групп и количеством пар которые можно изменить
/// </summary>
/// <param name="unionGroups"> Возможные объедиения групп</param>
/// <returns>Объединенный план занятий</returns>
private CurriculaWithAmountPair[] CurriculaWithUnionGroupsAndNumberOfPairs(List <Group[]> unionGroups)
{
//Произведена группировка по предметам. Каждый Предмет включает План для нескольких групп по нему
var SubjectIncludePlans = Curricula.OrderByDescending(x => x.Number).GroupBy(x => x.Subject).Select(g => g.ToList()).ToList();
// Можно сразу выкинуть из объединенного плана если количество элементов в предмете =1 так как не с чем объединять
//Добавляем эти одиночные предметы в объединенный план
List <CurriculaWithAmountPair> CurriculaAndNumPairs = SubjectIncludePlans.Where(x => x.Count == 1).Select(c => new CurriculaWithAmountPair(c[0])).ToList();
//Убираем из группировки по предметам одиночные предметы
SubjectIncludePlans = SubjectIncludePlans.Where(x => x.Count > 1).ToList();
// Подбираются планы из группировки по предметам (там теперь нет одиночных) и пытаюсь объединить
//TODO: Просто просто делаю
//прохожу по предметам с планами
foreach (var plansInSubject in SubjectIncludePlans)
{
//прохожу по объединению групп где объединение >1
foreach (var groups in unionGroups.Where(x => x.Length > 1))
{
//если план по предмету содержит все объединенные группы то объединяем по этому предмету эти группы
// правда ли что для всех групп -> хотябы один план содежит группу
bool ContainsAllGroups = groups.All(x => plansInSubject.Any(y => y.Group == x));
if (ContainsAllGroups)
{
//Выбираю планы, только для объединенных групп
Curriculum[] curriculaUnionGroup = plansInSubject.Where(x => groups.Contains(x.Group)).ToArray();
//Проверям что у всех кто объединитсь одинаковое количество пар
if (curriculaUnionGroup.All(x => x.Number == curriculaUnionGroup[0].Number))
{
//Создаем план с возможностью изменения кол-во пар только для первой группы
CurriculaWithAmountPair tempCurriculaWithAmountPair = new CurriculaWithAmountPair(curriculaUnionGroup[0]);
//добавляем в этот объединенный план все остальные группы и если удалось то add->true
bool add = tempCurriculaWithAmountPair.AddCurriculum(curriculaUnionGroup.Skip(1).ToArray());
//Если удалось добавить
if (add)
{
//Добавляем этот план в объединенный план
CurriculaAndNumPairs.Add(tempCurriculaWithAmountPair);
//Удаляем из плана добавления в предмете что уже добавили тоесть все группы объединенные удаляем.
plansInSubject.RemoveAll(x => curriculaUnionGroup.Contains(x));
}
}
}
}
//Добавляю оставшиеся планы в Главный план
CurriculaAndNumPairs.AddRange(plansInSubject.Select(x => new CurriculaWithAmountPair(x)).ToArray());
}
//План занятий с объединенными планами и кол-вом пар
return(CurriculaAndNumPairs.ToArray());
}
public IActionResult CurriculaAdd(AddCurriculaViewModel acvm)
{
Curricula curr = new Curricula()
{
CourseId = acvm.CourseId,
CourseSession = acvm.CourseSession,
Description = acvm.Description
};
_currDAL.SaveCurricula(curr);
return(RedirectToAction("Details", new { id = curr.CourseId }));
}
public IActionResult DetailEdit(int id)
{
Curricula cur = _currDAL.GetCurricula(id);
EditCurriculaViewModel ecvm = new EditCurriculaViewModel()
{
CourseId = cur.CourseId,
CourseSession = cur.CourseSession,
Description = cur.Description,
Id = cur.Id
};
return(View(ecvm));
}
public IActionResult CurriculaDetail(int id)
{
Curricula curr = new Curricula();
CurriculaDetailViewModel cdvm = new CurriculaDetailViewModel();
curr = _currDAL.GetCurricula(id);
cdvm.CourseId = curr.CourseId;
cdvm.CourseSession = curr.CourseSession;
cdvm.Description = curr.Description;
cdvm.Details = (List <CurriculaLineItem>)_currDAL.GetCurriculaLineItems(id);
cdvm.Id = curr.Id;
return(View(cdvm));
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (_curricula == null)
{
_curricula = new Curricula();
_curricula.Author = Page.User.Identity.Name;
_curricula.DateCreated = DateTime.Now.AddHours(-TrainSettings.Instance.Timezone);
}
_curricula.Title = txtTitle.Text;
_curricula.ObjectDes = txtObj.Text;
_curricula.Content = txtContent.Text;
_curricula.Tags.Clear();
_curricula.Categories.Clear();
_curricula.Fields.Clear();
_curricula.Points = Convert.ToInt32(txtPoints.Text);
_curricula.Scores = Convert.ToInt32(txtScores.Text);
foreach (ListItem item in cblCategories.Items)
{
if (item.Selected)
{
_curricula.Categories.Add(Category.GetCategory(new Guid(item.Value)));
}
}
foreach (ListItem item in cblField.Items)
{
if (item.Selected)
{
_curricula.Fields.Add(Field.GetField(new Guid(item.Value)));
}
}
if (txtTags.Text.Trim().Length > 0)
{
string[] tags = txtTags.Text.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
foreach (string tag in tags)
{
if (string.IsNullOrEmpty(_curricula.Tags.Find(delegate(string t) { return(t.Equals(tag.Trim(), StringComparison.OrdinalIgnoreCase)); })))
{
_curricula.Tags.Add(tag.Trim());
}
}
}
_curricula.Save();
Reload();
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (_curricula == null)
{
_curricula = new Curricula();
_curricula.Author = Page.User.Identity.Name;
_curricula.DateCreated = DateTime.Now.AddHours(-TrainSettings.Instance.Timezone);
}
_curricula.Title = txtTitle.Text;
_curricula.ObjectDes = txtObj.Text;
_curricula.Content = txtContent.Text;
_curricula.Tags.Clear();
_curricula.Categories.Clear();
_curricula.Fields.Clear();
_curricula.Points = Convert.ToInt32(txtPoints.Text);
_curricula.Scores = Convert.ToInt32(txtScores.Text);
foreach (ListItem item in cblCategories.Items)
{
if (item.Selected)
_curricula.Categories.Add(Category.GetCategory(new Guid(item.Value)));
}
foreach (ListItem item in cblField.Items)
{
if (item.Selected)
_curricula.Fields.Add(Field.GetField(new Guid(item.Value)));
}
if (txtTags.Text.Trim().Length > 0)
{
string[] tags = txtTags.Text.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
foreach (string tag in tags)
{
if (string.IsNullOrEmpty(_curricula.Tags.Find(delegate(string t) { return t.Equals(tag.Trim(), StringComparison.OrdinalIgnoreCase); })))
{
_curricula.Tags.Add(tag.Trim());
}
}
}
_curricula.Save();
Reload();
}
protected void gridComments_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[e.Row.Cells.Count - 2].Text = string.Format("{0} : {1} {2}", labels.total, Curriculas.Count, "课程");
}
else if (e.Row.RowType == DataControlRowType.DataRow)
{
HtmlGenericControl ulPages = e.Row.Cells[4].FindControl("ulPages") as HtmlGenericControl;
HtmlGenericControl divPages = e.Row.Cells[4].FindControl("divPages") as HtmlGenericControl;
HtmlAnchor aPages = e.Row.Cells[4].FindControl("aPages") as HtmlAnchor;
HtmlAnchor aNew = e.Row.Cells[4].FindControl("aNew") as HtmlAnchor;
aPages.HRef = "javascript:void(ToggleVisibility('" + ulPages.ClientID + "'));";
Curricula crl = ((Curricula)e.Row.DataItem) as Curricula;
aNew.HRef = "javascript:void(0)";
aNew.Attributes.Add("onClick", GetEditHtml(crl.Id.ToString(), "CurriculaInfo.aspx", 600, 260));
BindPageList(crl, ulPages, divPages, aPages);
}
}
public object GuardarEstado(int curricula, string codigo, int estado, string motivo)
{
object objRespuesta = null;
try
{
string estadoText = (estado == 4 ? "aprobada" : "rechazado");
Curricula curriculaEstado = new Curricula()
{
IdCurricula = curricula,
Estado = estado,
MotivoRechazo = motivo
};
GestionPedagogica.RegistrarCurriculaEstado(curriculaEstado);
/*ENVIO DE CORREO*/
Persona coordinador = GestionPedagogica.ListarPersonaPuesto(1).FirstOrDefault();
bool boEnvioCorreo = false;
if (coordinador != null)
{
if (!string.IsNullOrWhiteSpace(coordinador.correoElectronico))
{
string para = "*****@*****.**";
string asunto = "Curricula con codigo [" + codigo + "] " + estadoText;
string mensaje = "Correo informativo indicando que la Curricula con Codigo: [" + codigo + "] fue " + estadoText +
(estado != 4 ? ("<br>Motivo: " + motivo) : "");
boEnvioCorreo = Utilidad.EnviarCorreo(para, asunto, mensaje);
}
}
objRespuesta = new { Exito = string.Format("Curricula {0} exitosamente. {1}", estadoText, (!boEnvioCorreo ? " No se pudo enviar correo" : "")) };
}
catch (Exception ex)
{
objRespuesta = new { Error = ex.Message };
}
return(new JavaScriptSerializer().Serialize(objRespuesta));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack && !Page.IsCallback)
{
txtTitle.Focus();
BindTags();
BindCategories();
BindFields();
_id = HttpContext.Current.Request.QueryString["id"];
_urlReferrer = HttpContext.Current.Request.UrlReferrer.ToString();
if (_id != null && _id != string.Empty)
{
_curricula = Curricula.GetCurricula(new Guid(_id));
}
if (_curricula != null)
{
BindCurricula();
}
}
}
//相关公开课数据控件
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Params["id"] == null)
{
return;
}
strID = Request.Params["id"];
if (Request.Params["FieldID"] != null)
{
FieldID = Request.Params["FieldID"];
}
else
{
Curricula cl = Curricula.GetCurricula(new Guid(strID));
Field fd = cl.Fields[0];
FieldID = fd.Id.ToString();
}
BindGrid();
}
private void RemoveCurricula(Curricula cm)
{
bool found = false;
for (int i = 0; i < Curricula.Curriculas.Count; i++)
{
if (Curricula.Curriculas[i].Id == cm.Id)
{
Curricula.Curriculas[i].Delete();
Curricula.Curriculas[i].Save();
found = true;
break;
}
if (found)
{
break;
}
}
}
public void SaveCurricula(Curricula curr)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
string SQL = "INSERT INTO Curricula(CourseId, CourseSession, Description) ";
SQL += "VALUES (@CourseId, @CourseSession, @Description);";
conn.Open();
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.Parameters.AddWithValue("@CourseId", curr.CourseId);
cmd.Parameters.AddWithValue("@CourseSession", curr.CourseSession);
cmd.Parameters.AddWithValue("@Description", curr.Description);
if (cmd.ExecuteNonQuery() == 0)
{
throw new Exception("Failed to insert curricula.");
}
}
}
public void UpdateCurricula(Curricula curr)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
string SQL = "UPDATE Curricula Set Description = @description, ";
SQL += "CourseSession = @CourseSession ";
SQL += "WHERE id = @id ";
conn.Open();
SqlCommand cmd = new SqlCommand(SQL, conn);
cmd.Parameters.AddWithValue("@description", curr.Description);
cmd.Parameters.AddWithValue("@CourseSession", curr.CourseSession);
cmd.Parameters.AddWithValue("@id", curr.Id);
if (cmd.ExecuteNonQuery() == 0)
{
throw new Exception("Failed to update curricula.");
}
}
}
public object GuardarAprobacion(int curricula)
{
object objRespuesta = null;
try
{
Curricula curriculaEstado = new Curricula()
{
IdCurricula = curricula,
Estado = 3,
MotivoRechazo = string.Empty
};
GestionPedagogica.RegistrarCurriculaEstado(curriculaEstado);
/*ENVIO DE CORREO*/
Persona director = GestionPedagogica.ListarPersonaPuesto(5).FirstOrDefault();
bool boEnvioCorreo = false;
if (director != null)
{
if (!string.IsNullOrWhiteSpace(director.correoElectronico))
{
string para = "*****@*****.**";
string asunto = "Revision de Nueva Curricula";
string mensaje = "Correo informativo para la aprobación de un nueva Curricula";
boEnvioCorreo = Utilidad.EnviarCorreo(para, asunto, mensaje);
}
}
objRespuesta = new { Exito = "Curricula enviado para su aprobación exitosamente." + (!boEnvioCorreo ? " No se pudo enviar correo" : "") };
}
catch (Exception ex)
{
objRespuesta = new { Error = ex.Message };
}
return(new JavaScriptSerializer().Serialize(objRespuesta));
}
public bool InsertCurricula(Curricula curricula, out string message)
{
bool rez = false;
message = "";
if (connect.State == ConnectionState.Open)
{
//fillimisht kemi me i rujt te gjitha id e curriculumeve
//se dyti id se bashku me kurset kan me u rujt ne curriculum
List <bool> IdsInCurricula = InsertIdsInCurricula(curricula.curriculum);
if (AreIDsRegistred(IdsInCurricula) == true)
{
if (AreIDsRegistred(InsertCurriculums(curricula.curriculum)) == true)
{
rez = true;
}
}
}
return(rez);
}
/// <summary> /// Inserts a new Curricula into the data store specified by the provider. /// </summary> public abstract void InsertCurricula(Curricula page);
/// <summary> /// Updates an existing Curricula in the data store specified by the provider. /// </summary> public abstract void UpdateCurricula(Curricula page);
/// <summary>
/// Deletes the specified Page from the current provider.
/// </summary>
public static void DeleteCurricula(Curricula curricula)
{
LoadProviders();
_provider.DeleteCurricula(curricula);
}
/// <summary>
/// Adds a Curricula to the database
/// </summary>
/// <param name="curricula">Curricula to be added</param>
public override void InsertCurricula(Curricula curricula)
{
string connString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
string providerName = ConfigurationManager.ConnectionStrings[connStringName].ProviderName;
DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);
using (DbConnection conn = provider.CreateConnection())
{
conn.ConnectionString = connString;
conn.Open();
using (DbCommand cmd = conn.CreateCommand())
{
string sqlQuery = "INSERT INTO " + tablePrefix + "Curriculas (CurriculaID,Title,ObjectDes,CurriculaContent, DateCreated, " +
"DateModified,Author,IsPublished,Points,Scores,IsGold,ViewCount) " +
"VALUES (@cid, @title, @objectdes, @content, @created, @modified, @author, @ispublished, @points, @scores,@IsGold,@ViewCount)";
if (parmPrefix != "@")
sqlQuery = sqlQuery.Replace("@", parmPrefix);
cmd.CommandText = sqlQuery;
cmd.CommandType = CommandType.Text;
DbParameter dpID = provider.CreateParameter();
dpID.ParameterName = parmPrefix + "cid";
dpID.Value = curricula.Id.ToString();
cmd.Parameters.Add(dpID);
DbParameter dpTitle = provider.CreateParameter();
dpTitle.ParameterName = parmPrefix + "title";
dpTitle.Value = curricula.Title;
cmd.Parameters.Add(dpTitle);
DbParameter dpObjectDes = provider.CreateParameter();
dpObjectDes.ParameterName = parmPrefix + "objectdes";
dpObjectDes.Value = curricula.ObjectDes;
cmd.Parameters.Add(dpObjectDes);
DbParameter dpContent = provider.CreateParameter();
dpContent.ParameterName = parmPrefix + "content";
dpContent.Value = curricula.Content;
cmd.Parameters.Add(dpContent);
DbParameter dpCreated = provider.CreateParameter();
dpCreated.ParameterName = parmPrefix + "created";
dpCreated.Value = curricula.DateCreated.AddHours(-TrainSettings.Instance.Timezone);
cmd.Parameters.Add(dpCreated);
DbParameter dpModified = provider.CreateParameter();
dpModified.ParameterName = parmPrefix + "modified";
if (curricula.DateModified == new DateTime())
dpModified.Value = DateTime.Now;
else
dpModified.Value = curricula.DateModified.AddHours(-TrainSettings.Instance.Timezone);
cmd.Parameters.Add(dpModified);
DbParameter dpAuthor = provider.CreateParameter();
dpAuthor.ParameterName = parmPrefix + "author";
dpAuthor.Value = curricula.Author;
cmd.Parameters.Add(dpAuthor);
DbParameter dpPublished = provider.CreateParameter();
dpPublished.ParameterName = parmPrefix + "ispublished";
dpPublished.Value = curricula.IsPublished;
cmd.Parameters.Add(dpPublished);
DbParameter dpPoints = provider.CreateParameter();
dpPoints.ParameterName = parmPrefix + "points";
dpPoints.Value = curricula.Points;
cmd.Parameters.Add(dpPoints);
DbParameter dpScores = provider.CreateParameter();
dpScores.ParameterName = parmPrefix + "scores";
dpScores.Value = curricula.Scores;
cmd.Parameters.Add(dpScores);
DbParameter dpIsGold = provider.CreateParameter();
dpIsGold.ParameterName = parmPrefix + "IsGold";
dpIsGold.Value = curricula.IsGold;
cmd.Parameters.Add(dpIsGold);
DbParameter dpViewCount = provider.CreateParameter();
dpViewCount.ParameterName = parmPrefix + "ViewCount";
dpViewCount.Value = curricula.ViewCount;
cmd.Parameters.Add(dpViewCount);
cmd.ExecuteNonQuery();
}
// Tags
UpdateTags(curricula, conn, provider);
// Categories
UpdateCategories(curricula, conn, provider);
//Fields
UpdateFields(curricula, conn, provider);
// Comments
UpdateComments(curricula, conn, provider);
}
}
private void SetGoldCurricula(Curricula cm)
{
bool found = false;
for (int i = 0; i < Curricula.Curriculas.Count; i++)
{
if (Curricula.Curriculas[i].Id == cm.Id)
{
if (!cm.IsGold)
{
Curricula.Curriculas[i].IsGold = true;
}
else
{
Curricula.Curriculas[i].IsGold = false;
}
Curricula.Curriculas[i].DateModified = DateTime.Now;
Curricula.Curriculas[i].Save();
found = true;
break;
}
if (found) { break; }
}
}
private void BindPageList(Curricula crl, HtmlGenericControl ulPages, HtmlGenericControl divPages, HtmlAnchor aPages)
{
foreach (CurriculaInfo info in crl.CurriculaInfos)
{
HtmlGenericControl li = new HtmlGenericControl("li");
HtmlGenericControl span = new HtmlGenericControl("span");
//HtmlAnchor a = new HtmlAnchor();
//a.HRef = "?infoid=" + info.Id.ToString();
//a.InnerHtml = info.StartDate.ToString("yyyy年MM月dd") + "-" + info.EndDate.ToString("dd日");
span.InnerText = info.StartDate.ToString("yyyy年MM月dd日") + "-" + info.EndDate.ToString("MM月dd日") +
" (" + info.CityTown + " ￥" + info.Cast + ") ";
span.Attributes.CssStyle.Add("color", "#F3660E");
//span.Attributes.CssStyle.Add("",)
//System.Web.UI.LiteralControl text = new System.Web.UI.LiteralControl
//(" (<span style='color:#F3660E;'>" + info.CityTown + " ￥" + info.Cast + "<span>) ");
string deleteText = string.Format(labels.areYouSure, labels.delete.ToLower(), "课程安排"); ;
HtmlAnchor delete = new HtmlAnchor();
delete.InnerText = Resources.labels.delete;
delete.Attributes["onclick"] = "if (confirm('" + deleteText + "')){location.href='?delete=" + info.Id + "'}";
delete.HRef = "javascript:void(0);";
delete.Style.Add(System.Web.UI.HtmlTextWriterStyle.FontWeight, "normal");
li.Controls.Add(span);
//li.Controls.Add(text);
li.Controls.Add(delete);
li.Attributes.CssStyle.Remove("font-weight");
ulPages.Controls.Add(li);
}
divPages.Visible = true;
aPages.InnerHtml = crl.CurriculaInfos.Count + " 课程安排";
}
/// <summary>
/// Returns a Curricula for given ID
/// </summary>
/// <param name="id">ID of page to return</param>
/// <returns>selected page</returns>
public override Curricula SelectCurricula(Guid id)
{
Curricula curricula = new Curricula();
string connString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
string providerName = ConfigurationManager.ConnectionStrings[connStringName].ProviderName;
DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);
using (DbConnection conn = provider.CreateConnection())
{
conn.ConnectionString = connString;
using (DbCommand cmd = conn.CreateCommand())
{
string sqlQuery = "SELECT CurriculaID,Title,ObjectDes,CurriculaContent, DateCreated, " +
"DateModified,Author,IsPublished,Points,Scores,IsGold,ViewCount " +
"FROM " + tablePrefix + "Curriculas " +
"WHERE CurriculaID = " + parmPrefix + "id";
cmd.CommandText = sqlQuery;
cmd.CommandType = CommandType.Text;
DbParameter dpID = provider.CreateParameter();
dpID.ParameterName = parmPrefix + "id";
dpID.Value = id.ToString();
cmd.Parameters.Add(dpID);
conn.Open();
using (DbDataReader rdr = cmd.ExecuteReader())
{
if (rdr.HasRows)
{
rdr.Read();
curricula.Id = rdr.GetGuid(0);
curricula.Title = rdr.IsDBNull(1) ? String.Empty : rdr.GetString(1);
curricula.ObjectDes = rdr.IsDBNull(2) ? String.Empty : rdr.GetString(2);
curricula.Content = rdr.IsDBNull(3) ? String.Empty : rdr.GetString(3);
if (!rdr.IsDBNull(4))
curricula.DateCreated = rdr.GetDateTime(4);
if (!rdr.IsDBNull(5))
curricula.DateModified = rdr.GetDateTime(5);
if (!rdr.IsDBNull(6))
curricula.Author = rdr.GetString(6);
if (!rdr.IsDBNull(7))
curricula.IsPublished = rdr.GetBoolean(7);
if (!rdr.IsDBNull(8))
curricula.Points = rdr.GetInt32(8);
if (!rdr.IsDBNull(9))
curricula.Scores = rdr.GetInt32(9);
if (!rdr.IsDBNull(10))
curricula.IsGold = rdr.GetBoolean(10);
if (!rdr.IsDBNull(11))
curricula.ViewCount = rdr.GetInt32(11);
}
}
//Tags
sqlQuery = "SELECT Tag " +
"FROM " + tablePrefix + "Tags " +
"WHERE ParentID = " + parmPrefix + "id and ParentType=0";
cmd.CommandText = sqlQuery;
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
if (!rdr.IsDBNull(0))
curricula.Tags.Add(rdr.GetString(0));
}
}
curricula.Tags.MarkOld();
// CurriculaInfo
sqlQuery = "SELECT InfoID " +
"FROM " + tablePrefix + "CurriculaInfo " +
"WHERE CurriculaID = " + parmPrefix + "id";
cmd.CommandText = sqlQuery;
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
Guid key = rdr.GetGuid(0);
curricula.CurriculaInfos.Add(CurriculaInfo.GetCurriculaInfo(key));
}
}
// Categories
sqlQuery = "SELECT CategorieID " +
"FROM " + tablePrefix + "CurriculaCategorie " +
"WHERE CurriculaID = " + parmPrefix + "id";
cmd.CommandText = sqlQuery;
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
Guid key = rdr.GetGuid(0);
if (Category.GetCategory(key) != null)
curricula.Categories.Add(Category.GetCategory(key));
}
}
// Fields
sqlQuery = "SELECT FieldID " +
"FROM " + tablePrefix + "CurriculaField " +
"WHERE CurriculaID = " + parmPrefix + "id";
cmd.CommandText = sqlQuery;
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
Guid key = rdr.GetGuid(0);
if (Field.GetField(key) != null)
curricula.Fields.Add(Field.GetField(key));
}
}
// Comments
sqlQuery = "SELECT CommentID,CommentDate,Author,Count,Sex,Phone,Mobile,Email, " +
"Company,QQ_msn,Comment,IsDispose,DisposeBy,Country,IP " +
"FROM " + tablePrefix + "Comments " +
"WHERE ParentID = " + parmPrefix + "id and ParentType = 0";
cmd.CommandText = sqlQuery;
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
Comment comment = new Comment();
comment.Id = rdr.GetGuid(0);
comment.IsApproved = false;
comment.DateCreated = rdr.GetDateTime(1);
comment.Author = rdr.GetString(2);
comment.Count = rdr.GetInt32(3);
comment.Sex = rdr.GetBoolean(4);
if (!rdr.IsDBNull(5))
comment.Phone = rdr.GetString(5);
comment.Mobile = rdr.GetString(6);
if (!rdr.IsDBNull(7))
comment.Email = rdr.GetString(7);
comment.Company = rdr.GetString(8);
if (!rdr.IsDBNull(9))
comment.QQ_msn = rdr.GetString(9);
comment.Content = rdr.GetString(10);
if (!rdr.IsDBNull(11))
comment.IsApproved = rdr.GetBoolean(11);
if (!rdr.IsDBNull(10))
comment.ModeratedBy = rdr.GetString(12);
if (!rdr.IsDBNull(6))
comment.Country = rdr.GetString(6);
if (!rdr.IsDBNull(7))
comment.IP = rdr.GetString(7);
comment.ParentId = id;
comment.ParentType = 0;
comment.Parent = curricula;
curricula.Comments.Add(comment);
}
}
curricula.Comments.Sort();
}
}
return curricula;
}
/// <summary> /// Deletes a Curricula from the data store specified by the provider. /// </summary> public abstract void DeleteCurricula(Curricula page);
/// <summary>
/// Persists a new Page in the current provider.
/// </summary>
public static void InsertCurricula(Curricula curricula)
{
LoadProviders();
_provider.InsertCurricula(curricula);
}
private void RemoveCurricula(Curricula cm)
{
bool found = false;
for (int i = 0; i < Curricula.Curriculas.Count; i++)
{
if (Curricula.Curriculas[i].Id == cm.Id)
{
Curricula.Curriculas[i].Delete();
Curricula.Curriculas[i].Save();
found = true;
break;
}
if (found) { break; }
}
}
/// <summary>
/// Updates an exsiting Page.
/// </summary>
public static void UpdateCurricula(Curricula curricula)
{
LoadProviders();
_provider.UpdateCurricula(curricula);
}
private void UpdateCurriculaInfos(Curricula parent, DbConnection conn, DbProviderFactory provider)
{
string table = "CurriculaInfo";
string key = "CurriculaID";
string sqlQuery = "DELETE FROM " + tablePrefix + table + " WHERE " + key + " = " + parmPrefix + "id";
using (DbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sqlQuery;
cmd.CommandType = CommandType.Text;
DbParameter dpID = provider.CreateParameter();
dpID.ParameterName = parmPrefix + "id";
dpID.Value = parent.Id.ToString();
cmd.Parameters.Add(dpID);
cmd.ExecuteNonQuery();
foreach (CurriculaInfo info in parent.CurriculaInfos)
{
cmd.CommandText = "INSERT INTO " + tablePrefix + table + " (" + key + ", InfoID,StartDate,EndDate,Cast,CityTown,IsPublished) " +
"VALUES (" + parmPrefix + "pid, " + parmPrefix + "InfoID, " + parmPrefix + "StartDate, " + parmPrefix + "EndDate, " + parmPrefix + "Cast, " + parmPrefix + "CityTown, " + parmPrefix + "IsPublished)";
cmd.Parameters.Clear();
DbParameter dpcID = provider.CreateParameter();
dpcID.ParameterName = parmPrefix + "pid";
dpcID.Value = parent.Id.ToString();
cmd.Parameters.Add(dpcID);
DbParameter dpInfoID = provider.CreateParameter();
dpInfoID.ParameterName = parmPrefix + "InfoID";
dpInfoID.Value = info.Id.ToString();
cmd.Parameters.Add(dpInfoID);
DbParameter dpStartDate = provider.CreateParameter();
dpStartDate.ParameterName = parmPrefix + "StartDate";
dpStartDate.Value = info.StartDate;
cmd.Parameters.Add(dpStartDate);
DbParameter dpEndDate = provider.CreateParameter();
dpEndDate.ParameterName = parmPrefix + "EndDate";
dpEndDate.Value = info.EndDate;
cmd.Parameters.Add(dpEndDate);
DbParameter dpCast = provider.CreateParameter();
dpCast.ParameterName = parmPrefix + "Cast";
dpCast.Value = info.Cast;
cmd.Parameters.Add(dpCast);
DbParameter dpCityTown = provider.CreateParameter();
dpCityTown.ParameterName = parmPrefix + "CityTown";
dpCityTown.Value = info.CityTown;
cmd.Parameters.Add(dpCityTown);
DbParameter dpIsPublished = provider.CreateParameter();
dpIsPublished.ParameterName = parmPrefix + "IsPublished";
dpIsPublished.Value = info.IsPublished;
cmd.Parameters.Add(dpIsPublished);
cmd.ExecuteNonQuery();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack && !Page.IsCallback)
{
txtTitle.Focus();
BindTags();
BindCategories();
BindFields();
_id = HttpContext.Current.Request.QueryString["id"];
_urlReferrer = HttpContext.Current.Request.UrlReferrer.ToString();
if (_id!=null && _id!= string.Empty )
{
_curricula = Curricula.GetCurricula(new Guid(_id));
}
if (_curricula!=null)
{
BindCurricula();
}
}
}
