private Company ReceiveHtml() { Company company = new Company(); company.CompanyID = (hddCompanyID.Value != "") ? Convert.ToInt32(hddCompanyID.Value) : 0; company.Categories = Convert.ToInt32(ddlCategories.SelectedValue); company.Title = txtTitle.Text; company.Description = txtRadDescription.Html; company.Author = txtAuthor.Text; company.IsNormal = Convert.ToBoolean(rdbIsNormal.SelectedValue); company.IsHot = Convert.ToBoolean(rdbIsHot.SelectedValue); company.Language = Language.language; company.IsComment = Convert.ToBoolean(rdbComment.SelectedValue); company.IsDefault = Convert.ToBoolean(rdbIsDefault.SelectedValue); company.VisitTotal = (hddVisitTotal.Value != "") ? Convert.ToInt32(hddVisitTotal.Value) : 0; company.CommentTotal = (hddCommentTotal.Value != "") ? Convert.ToInt32(hddCommentTotal.Value) : 0; company.CreatedUserName = (hddCreateUserName.Value != "") ? hddCreateUserName.Value : Session["Admin_UserName"].ToString(); company.CreatedDate = (hddCreatedDate.Value != "") ? Convert.ToDateTime(hddCreatedDate.Value) : DateTime.Now; company.GroupCate = Convert.ToInt32(hddGroupCate.Value); company.IsApproval = Convert.ToBoolean(rdbApproval.SelectedValue); if (hddApprovalUserName.Value != "") { company.ApprovalUserName = hddApprovalUserName.Value; company.ApprovalDate = Convert.ToDateTime(hddApprovalDate.Value); } else if (Convert.ToBoolean(rdbApproval.SelectedValue)) { company.ApprovalUserName = Session["Admin_UserName"].ToString(); company.ApprovalDate = DateTime.Now; } else { company.ApprovalUserName = ""; company.ApprovalDate = DateTime.Now; } return company; }
public void UpdateCompany(Company company) { new CompanyDAO().UpdateCompany(company); }
public void CreateCompany(Company company) { new CompanyDAO().CreateCompany(company); }
public void UpdateCompany(Company company) { using (SqlConnection connection = base.GetConnection()) { SqlCommand command = new SqlCommand("_CompanyUpdate", connection) { CommandType = CommandType.StoredProcedure }; command.Parameters.AddWithValue("@Type", 1); command.Parameters.AddWithValue("@CompanyID", company.CompanyID); command.Parameters.AddWithValue("@Categories", company.Categories); command.Parameters.AddWithValue("@Title", company.Title); command.Parameters.AddWithValue("@Description", company.Description); command.Parameters.AddWithValue("@Author", company.Author); command.Parameters.AddWithValue("@IsNormal", company.IsNormal); command.Parameters.AddWithValue("@IsHot", company.IsHot); command.Parameters.AddWithValue("@IsDefault", company.IsDefault); command.Parameters.AddWithValue("@Language", company.Language); command.Parameters.AddWithValue("@IsComment", company.IsComment); command.Parameters.AddWithValue("@ApprovalDate", company.ApprovalDate); command.Parameters.AddWithValue("@ApprovalUserName", company.ApprovalUserName); command.Parameters.AddWithValue("@IsApproval", company.IsApproval); command.Parameters.AddWithValue("@CreatedUserName", company.CreatedUserName); command.Parameters.AddWithValue("@CommentTotal", company.CommentTotal); command.Parameters.AddWithValue("@VisitTotal", company.VisitTotal); command.Parameters.AddWithValue("@CreatedDate", company.CreatedDate); command.Parameters.AddWithValue("@GroupCate", company.GroupCate); connection.Open(); if (command.ExecuteNonQuery() <= 0) { throw new DataAccessException("Khong cap nhat duoc company"); } command.Dispose(); } }