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();
}
}
