protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e)
{
ObjectDataSource1.DataBind();
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["ProductLengthName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string ProductLengthID, Priority, IsAvailable;
var oProductLength = new ProductLength();
foreach (GridDataItem item in RadGrid1.Items)
{
ProductLengthID = item.GetDataKeyValue("ProductLengthID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oProductLength.ProductLengthQuickUpdate(
ProductLengthID,
IsAvailable,
Priority
);
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string ProductLengthNameEn = "";
string ProductID = string.IsNullOrEmpty(Request.QueryString["pi"]) ? "" : Request.QueryString["pi"];
if (e.CommandName == "PerformInsert")
{
ObjectDataSource1.InsertParameters["IsAvailable"].DefaultValue = strIsAvailable;
ObjectDataSource1.InsertParameters["ProductLengthNameEn"].DefaultValue = ProductLengthNameEn;
ObjectDataSource1.InsertParameters["ProductID"].DefaultValue = ProductID;
}
else
{
ObjectDataSource1.UpdateParameters["IsAvailable"].DefaultValue = strIsAvailable;
ObjectDataSource1.UpdateParameters["ProductLengthNameEn"].DefaultValue = ProductLengthNameEn;
ObjectDataSource1.UpdateParameters["ProductID"].DefaultValue = ProductID;
}
}
else if (e.CommandName == "DeleteSelected")
{
var oProductLength = new ProductLength();
string errorList = "", ProductLengthName = "";
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
try
{
var ProductLengthID = item.GetDataKeyValue("ProductLengthID").ToString();
ProductLengthName = item["ProductLengthName"].Text;
oProductLength.ProductLengthDelete(ProductLengthID);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString())
{
errorList += ", " + ProductLengthName;
}
}
}
if (!string.IsNullOrEmpty(errorList))
{
e.Canceled = true;
string strAlertMessage = "Tỉnh/Thành <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang chứa Quận/Huyện.<br /> Xin xóa Quận/Huyện trong Tỉnh/Thành này hoặc thiết lập hiển thị = \"không\".";
lblError.Text = strAlertMessage;
}
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["ProductStoneColorName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string ProductStoneColorID, Priority, IsAvailable;
var oProductStoneColor = new ProductStoneColor();
foreach (GridDataItem item in RadGrid1.Items)
{
ProductStoneColorID = item.GetDataKeyValue("ProductStoneColorID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oProductStoneColor.ProductStoneColorQuickUpdate(
ProductStoneColorID,
IsAvailable,
Priority
);
}
}
else if (e.CommandName == "DeleteSelected")
{
var oProductStoneColor = new ProductStoneColor();
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
string strProductStoneColorImage = ((HiddenField)item.FindControl("hdnProductStoneColorImage")).Value;
if (!string.IsNullOrEmpty(strProductStoneColorImage))
{
string strSavePath = Server.MapPath("~/res/ProductStoneColor/" + strProductStoneColorImage);
if (File.Exists(strSavePath))
{
File.Delete(strSavePath);
}
}
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileProductStoneColorImage = (RadUpload)row.FindControl("FileProductStoneColorImage");
string strProductStoneColorName = ((TextBox)row.FindControl("txtProductStoneColorName")).Text.Trim();
string strProductStoneColorNameEn = ((TextBox)row.FindControl("txtProductStoneColorNameEn")).Text.Trim();
string strConvertedProductStoneColorName = Common.ConvertTitle(strProductStoneColorName);
string strProductStoneColorImage = FileProductStoneColorImage.UploadedFiles.Count > 0 ? FileProductStoneColorImage.UploadedFiles[0].GetName() : "";
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string strPriority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
string strProductID = string.IsNullOrEmpty(Request.QueryString["pi"]) ? "" : Request.QueryString["pi"];
//string strContent = FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContent")).Content.Trim());
//string strContentEn = FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContentEn")).Content.Trim());
var oProductStoneColor = new ProductStoneColor();
if (e.CommandName == "PerformInsert")
{
strProductStoneColorImage = oProductStoneColor.ProductStoneColorInsert(
strProductStoneColorName,
strProductStoneColorNameEn,
strConvertedProductStoneColorName,
strProductStoneColorImage,
strIsAvailable,
strPriority,
strProductID
);
string strFullPath = "~/res/ProductStoneColor/" + strProductStoneColorImage;
if (!string.IsNullOrEmpty(strProductStoneColorImage))
{
FileProductStoneColorImage.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
//string bgColor = "#ffffff";
//ResizeCropImage.ResizeWithBackGroundColor(strFullPath, 190, 120, bgColor);
//ResizeCropImage.ResizeByWidth(strFullPath, 180);
ResizeCropImage.ResizeByCondition(strFullPath, 200, 200);
}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strProductStoneColorID = row.GetDataKeyValue("ProductStoneColorID").ToString();
var strOldProductStoneColorImage = ((HiddenField)row.FindControl("hdnProductStoneColorImage")).Value;
var strOldImagePath = Server.MapPath("~/res/ProductStoneColor/" + strOldProductStoneColorImage);
dsUpdateParam["ProductStoneColorName"].DefaultValue = strProductStoneColorName;
dsUpdateParam["ProductStoneColorNameEn"].DefaultValue = strProductStoneColorNameEn;
dsUpdateParam["ConvertedProductStoneColorName"].DefaultValue = strConvertedProductStoneColorName;
dsUpdateParam["ProductStoneColorImage"].DefaultValue = strProductStoneColorImage;
dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable;
dsUpdateParam["ProductID"].DefaultValue = strProductID;
if (!string.IsNullOrEmpty(strProductStoneColorImage))
{
var strFullPath = "~/res/ProductStoneColor/" + strConvertedProductStoneColorName + "-" + strProductStoneColorID + strProductStoneColorImage.Substring(strProductStoneColorImage.LastIndexOf('.'));
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
FileProductStoneColorImage.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
//string bgColor = "#ffffff";
//ResizeCropImage.ResizeWithBackGroundColor(strFullPath, 180, 120, bgColor);
ResizeCropImage.ResizeByCondition(strFullPath, 200, 200);
//ResizeCropImage.ResizeByWidth(strFullPath, 180);
}
}
}
if (e.CommandName == "DeleteImage")
{
var oProductStoneColor = new ProductStoneColor();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strProductStoneColorID = s[0];
var strProductStoneColorImage = s[1];
oProductStoneColor.ProductStoneColorImageDelete(strProductStoneColorID);
DeleteImage(strProductStoneColorImage);
RadGrid1.Rebind();
}
}
protected void ASPxCallbackPanel1_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
if (e.Parameter.Trim() == "quick")
{
if (tbQuick.Text.Trim() != "")
{
ObjectDataSource1.SelectParameters["strWhere"].DefaultValue = " and H_CONTENT like '%" + tbQuick.Text.Trim() + "%'";
}
else
{
ObjectDataSource1.SelectParameters["strWhere"].DefaultValue = " and 1=1";
}
ASPxGridView1.DataSourceID = "ObjectDataSource1";
ObjectDataSource1.DataBind();
}
if (e.Parameter.Trim() == "base")
{
string strwhere = "";
if (deBegin.Date <= deEnd.Date)
{
strwhere += " and to_char(HAZARDS.OPENINGTIME,'yyyy-mm-dd') between '" + deBegin.Date.ToString("yyyy-MM-dd") + "' and '" + deEnd.Date.ToString("yyyy-MM-dd") + "'";
}
if (cbbZY.Text.Trim() != "")
{
strwhere += " and a.infoid=" + ASPxHiddenField1.Get("ZYkey").ToString();
}
if (cbbDW.SelectedIndex > -1)
{
//strwhere+=" and "
}
if (cbbFXkind.SelectedIndex > -1)
{
strwhere += " and HAZARDS.Risk_Typesnumber=" + cbbFXkind.SelectedItem.Value.ToString();
}
if (cbbFXlevel.SelectedIndex > -1)
{
strwhere += " and c.infoid=" + cbbFXlevel.SelectedItem.Value.ToString();
}
if (cbbSG.SelectedIndex > -1)
{
strwhere += " and HAZARDS.Accident_Typenumber=" + cbbSG.SelectedItem.Value.ToString();
}
if (tbGZ.Text.Trim() != "")
{
strwhere += " and b.WORKTASK" + (cbbGZway.SelectedIndex == 0 ? "='" : " like '%") + tbGZ.Text.Trim() + (cbbGZway.SelectedIndex == 0 ? "'" : "%'");
}
if (tbGX.Text.Trim() != "")
{
strwhere += " and PROCESS.NAME" + (cbbGXway.SelectedIndex == 0 ? "='" : " like '%") + tbGX.Text.Trim() + (cbbGXway.SelectedIndex == 0 ? "'" : "%'");
}
if (tbBM.Text.Trim() != "" && tbBMchild.Text.Trim() != "")
{
strwhere += " and (HAZARDS.H_NUMBER like '%" + tbBM.Text.Trim() + "%'" + (cbbBMchild.SelectedIndex == 0 ? " and" : " or") + " HAZARDS.H_NUMBER like '%" + tbBMchild.Text.Trim() + "%')";
}
if (tbBM.Text.Trim() != "" && tbBMchild.Text.Trim() == "")
{
strwhere += " and HAZARDS.H_NUMBER like '%" + tbBM.Text.Trim() + "%'";
}
if (tbBM.Text.Trim() == "" && tbBMchild.Text.Trim() != "")
{
strwhere += " and HAZARDS.H_NUMBER like '%" + tbBMchild.Text.Trim() + "%'";
}
if (tbWXY.Text.Trim() != "" && tbWXYchild.Text.Trim() != "")
{
strwhere += " and (H_CONTENT like '%" + tbWXY.Text.Trim() + "%'" + (cbbWXYchild.SelectedIndex == 0 ? " and" : " or") + " H_CONTENT like '%" + tbWXYchild.Text.Trim() + "%')";
}
if (tbWXY.Text.Trim() != "" && tbWXYchild.Text.Trim() == "")
{
strwhere += " and H_CONTENT like '%" + tbWXY.Text.Trim() + "%'";
}
if (tbWXY.Text.Trim() == "" && tbWXYchild.Text.Trim() != "")
{
strwhere += " and H_CONTENT like '%" + tbWXYchild.Text.Trim() + "%'";
}
if (tbHG.Text.Trim() != "" && tbHGchild.Text.Trim() != "")
{
strwhere += " and (H_CONSEQUENCES like '%" + tbHG.Text.Trim() + "%'" + (cbbHGchild.SelectedIndex == 0 ? " and" : " or") + " H_CONSEQUENCES like '%" + tbHGchild.Text.Trim() + "%')";
}
if (tbHG.Text.Trim() != "" && tbHGchild.Text.Trim() == "")
{
strwhere += " and H_CONSEQUENCES like '%" + tbHG.Text.Trim() + "%'";
}
if (tbHG.Text.Trim() == "" && tbHGchild.Text.Trim() != "")
{
strwhere += " and H_CONSEQUENCES like '%" + tbHGchild.Text.Trim() + "%'";
}
ObjectDataSource1.SelectParameters["strWhere"].DefaultValue = strwhere;
ASPxGridView1.DataSourceID = "ObjectDataSource1";
ObjectDataSource1.DataBind();
}
if (e.Parameter.Trim() == "cs")
{
ObjectDataSource1.SelectParameters["strWhere"].DefaultValue = " and M_STANDARDS like '%" + tbCSsearch.Text.Trim() + "%' or M_MEASURES like '%" + tbCSsearch.Text.Trim() + "%'";
ASPxGridView1.DataSourceID = "ObjectDataSource1";
ObjectDataSource1.DataBind();
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["ProductName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string ProductID, Priority, InStock, IsHot, IsNew, IsBestSeller, IsSaleOff, IsShowOnHomePage, IsAvailable;
var oProduct = new Product();
foreach (GridDataItem item in RadGrid1.Items)
{
ProductID = item.GetDataKeyValue("ProductID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
InStock = ((CheckBox)item.FindControl("chkInStock")).Checked.ToString();
IsHot = ((CheckBox)item.FindControl("chkIsHot")).Checked.ToString();
IsNew = ((CheckBox)item.FindControl("chkIsNew")).Checked.ToString();
IsBestSeller = ((CheckBox)item.FindControl("chkIsBestSeller")).Checked.ToString();
IsSaleOff = ((CheckBox)item.FindControl("chkIsSaleOff")).Checked.ToString();
IsShowOnHomePage = ((CheckBox)item.FindControl("chkIsShowOnHomePage")).Checked.ToString();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oProduct.ProductQuickUpdate(
ProductID,
InStock,
IsHot,
IsNew,
IsBestSeller,
IsSaleOff,
IsShowOnHomePage,
Priority,
IsAvailable
);
}
}
else if (e.CommandName == "DeleteSelected")
{
string OldImageName;
var oProduct = new Product();
var oProductImage = new ProductImage();
var oProductDownload = new ProductDownload();
string errorList = "", ProductName = "";
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
try
{
var ProductID = item.GetDataKeyValue("ProductID").ToString();
ProductName = item["ProductName"].Text;
oProductImage.ProductImageDeleteByProduct(ProductID);
oProductDownload.ProductDownloadDeleteByProduct(ProductID);
oProduct.ProductDelete(ProductID);
OldImageName = ((HiddenField)item.FindControl("hdnImageName")).Value;
DeleteImage(OldImageName);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString())
{
errorList += ", " + ProductName;
}
}
}
if (!string.IsNullOrEmpty(errorList))
{
e.Canceled = true;
string strAlertMessage = "Sản phẩm <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang chứa thư viện ảnh hoặc file download .<br /> Xin xóa ảnh hoặc file trong sản phẩm này hoặc thiết lập hiển thị = \"không\".";
lblError.Text = strAlertMessage;
}
RadGrid1.Rebind();
}
else if (e.CommandName == "InitInsert" || e.CommandName == "EditSelected" || e.CommandName == "Edit")
{
TempImage.Rows.Clear();
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileImageName = (RadUpload)row.FindControl("FileImageName");
string ProductID = ((HiddenField)row.FindControl("hdnProductID")).Value;
string OldImageName = ((HiddenField)row.FindControl("hdnOldImageName")).Value;
string ImageName = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : "";
string Priority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
string MetaTittle = ((RadTextBox)row.FindControl("txtMetaTittle")).Text.Trim();
string MetaDescription = ((RadTextBox)row.FindControl("txtMetaDescription")).Text.Trim();
string ProductName = ((RadTextBox)row.FindControl("txtProductName")).Text.Trim();
string ConvertedProductName = Common.ConvertTitle(ProductName);
string Description = ((RadTextBox)row.FindControl("txtDescription")).Text.Trim();//HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescription")).Content.Trim()));
string Content = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContent")).Content.Trim()));
string Price = ((RadNumericTextBox)row.FindControl("txtPrice")).Text.Trim();
string OtherPrice = ((RadTextBox)row.FindControl("txtOtherPrice")).Text.Trim();
string SavePrice = ((RadNumericTextBox)row.FindControl("txtSavePrice")).Text.Trim();
string Discount = ((RadNumericTextBox)row.FindControl("txtDiscount")).Text.Trim();
string Tag = ((RadTextBox)row.FindControl("txtTag")).Text.Trim();
string CategoryID = ((RadComboBox)row.FindControl("ddlCategory")).SelectedValue;
if ("".Equals(CategoryID))
{
CategoryID = "2";
}
string ManufacturerID = ((RadComboBox)row.FindControl("ddlManufacturer")).SelectedValue;
string OriginID = ((RadComboBox)row.FindControl("ddlOrigin")).SelectedValue;
string InStock = ((CheckBox)row.FindControl("chkInStock")).Checked.ToString();
string IsHot = ((CheckBox)row.FindControl("chkIsHot")).Checked.ToString();
string IsNew = ((CheckBox)row.FindControl("chkIsNew")).Checked.ToString();
string IsBestSeller = ((CheckBox)row.FindControl("chkIsBestSeller")).Checked.ToString();
string IsSaleOff = ((CheckBox)row.FindControl("chkIsSaleOff")).Checked.ToString();
string IsShowOnHomePage = ((CheckBox)row.FindControl("chkIsShowOnHomePage")).Checked.ToString();
string IsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string MetaTittleEn = ((RadTextBox)row.FindControl("txtMetaTittleEn")).Text.Trim();
string MetaDescriptionEn = ((RadTextBox)row.FindControl("txtMetaDescriptionEn")).Text.Trim();
string ProductNameEn = ((RadTextBox)row.FindControl("txtProductNameEn")).Text.Trim();
string DescriptionEn = ((RadTextBox)row.FindControl("txtDescriptionEn")).Text.Trim();//HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescriptionEn")).Content.Trim()));
string ContentEn = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContentEn")).Content.Trim()));
string TagEn = ((RadTextBox)row.FindControl("txtTagEn")).Text.Trim();
string DienTichKhuDat = ((RadTextBox)row.FindControl("txtDienTichKhuDat")).Text.Trim();
string MatDoXayDung = ((RadTextBox)row.FindControl("txtMatDoXayDung")).Text.Trim();
string KhongGianXanh = ((RadTextBox)row.FindControl("txtKhongGianXanh")).Text.Trim();
string DienTichXayDung = ((RadTextBox)row.FindControl("txtDienTichXayDung")).Text.Trim();
string SoBlock = ((RadTextBox)row.FindControl("txtSoBlock")).Text.Trim();
string SoTang = ((RadTextBox)row.FindControl("txtSoTang")).Text.Trim();
if (e.CommandName == "PerformInsert")
{
var oProduct = new Product();
ImageName = oProduct.ProductInsert2(
ImageName,
MetaTittle,
MetaDescription,
ProductName,
ConvertedProductName,
Description,
Content,
Tag,
MetaTittleEn,
MetaDescriptionEn,
ProductNameEn,
DescriptionEn,
ContentEn,
TagEn,
Price,
OtherPrice,
SavePrice,
Discount,
CategoryID,
ManufacturerID,
OriginID,
InStock,
IsHot,
IsNew,
IsBestSeller,
IsSaleOff,
IsShowOnHomePage,
Priority,
IsAvailable,
DienTichKhuDat,
MatDoXayDung,
KhongGianXanh,
DienTichXayDung,
SoBlock,
SoTang
);
ProductID = oProduct.ProductID;
string strFullPath = "~/res/product/" + ImageName;
if (!string.IsNullOrEmpty(ImageName))
{
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
//ResizeCropImage.ResizeByCondition(strFullPath, 277, 230);
ResizeCropImage.CreateThumbNailByCondition("~/res/product/", "~/res/product/thumbs/", ImageName, 120, 120);
}
if (TempImage.Rows.Count > 0)
{
var oProductImage = new ProductImage();
foreach (DataRow dr in TempImage.Rows)
{
oProductImage.ProductImageInsert(dr["ImageName"].ToString(), "", "", "", "", "", ProductID, "True", "");
}
}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strOldImagePath = Server.MapPath("~/res/product/" + OldImageName);
var strOldThumbImagePath = Server.MapPath("~/res/product/thumbs/" + OldImageName);
dsUpdateParam["ConvertedProductName"].DefaultValue = ConvertedProductName;
dsUpdateParam["ImageName"].DefaultValue = ImageName;
dsUpdateParam["CategoryID"].DefaultValue = CategoryID;
dsUpdateParam["ManufacturerID"].DefaultValue = ManufacturerID;
dsUpdateParam["OriginID"].DefaultValue = OriginID;
dsUpdateParam["InStock"].DefaultValue = InStock;
dsUpdateParam["IsHot"].DefaultValue = IsHot;
dsUpdateParam["IsNew"].DefaultValue = IsNew;
dsUpdateParam["IsBestSeller"].DefaultValue = IsBestSeller;
dsUpdateParam["IsSaleOff"].DefaultValue = IsSaleOff;
dsUpdateParam["IsShowOnHomePage"].DefaultValue = IsShowOnHomePage;
dsUpdateParam["IsAvailable"].DefaultValue = IsAvailable;
if (!string.IsNullOrEmpty(ImageName))
{
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
if (File.Exists(strOldThumbImagePath))
{
File.Delete(strOldThumbImagePath);
}
ImageName = (string.IsNullOrEmpty(ConvertedProductName) ? "" : ConvertedProductName + "-") + ProductID + ImageName.Substring(ImageName.LastIndexOf('.'));
string strFullPath = "~/res/product/" + ImageName;
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
//ResizeCropImage.ResizeByCondition(strFullPath, 277, 230);
ResizeCropImage.CreateThumbNailByCondition("~/res/product/", "~/res/product/thumbs/", ImageName, 120, 120);
}
}
}
else if (e.CommandName == "Cancel")
{
if (TempImage.Rows.Count > 0)
{
foreach (DataRow row in TempImage.Rows)
{
DeletePhotoAlbum(row["ImageName"].ToString());
}
TempImage.Rows.Clear();
}
}
else if (e.CommandName == "DeleteImage")
{
var oProduct = new Product();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strProductID = s[0];
var ImageName = s[1];
oProduct.ProductImageDelete(strProductID);
DeleteImage(ImageName);
RadGrid1.Rebind();
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["ManufacturerName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string ManufacturerID, Priority, IsAvailable;
var oManufacturer = new Manufacturer();
foreach (GridDataItem item in RadGrid1.Items)
{
ManufacturerID = item.GetDataKeyValue("ManufacturerID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oManufacturer.ManufacturerQuickUpdate(
ManufacturerID,
IsAvailable,
Priority
);
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileImageName = (RadUpload)row.FindControl("FileImageName");
string ManufacturerID = ((HiddenField)row.FindControl("hdnManufacturerID")).Value;
string OldImageName = ((HiddenField)row.FindControl("hdnOldImageName")).Value;
string ImageName = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : "";
string ManufacturerName = ((RadTextBox)row.FindControl("txtManufacturerName")).Text.Trim();
string ConvertedManufacturerName = Common.ConvertTitle(ManufacturerName);
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string ManufacturerNameEn = "";
string Priority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
if (e.CommandName == "PerformInsert")
{
Manufacturer oManufacturer = new Manufacturer();
ImageName = oManufacturer.ManufacturerInsert(ImageName, ConvertedManufacturerName, ManufacturerName, ManufacturerNameEn, strIsAvailable, Priority);
ManufacturerID = oManufacturer.ManufacturerID;
string strFullPath = "~/res/manufacturer/" + ImageName;
if (!string.IsNullOrEmpty(ImageName))
{
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
//ResizeCropImage.ResizeByCondition(strFullPath, 277, 230);
ResizeCropImage.CreateThumbNailByCondition("~/res/manufacturer/", "~/res/manufacturer/thumbs/", ImageName, 120, 120);
}
//ObjectDataSource1.InsertParameters["IsAvailable"].DefaultValue = strIsAvailable;
//ObjectDataSource1.InsertParameters["ManufacturerNameEn"].DefaultValue = ManufacturerNameEn;
}
else
{
var strOldImagePath = Server.MapPath("~/res/manufacturer/" + OldImageName);
var strOldThumbImagePath = Server.MapPath("~/res/manufacturer/thumbs/" + OldImageName);
ObjectDataSource1.UpdateParameters["ConvertedProductName"].DefaultValue = ConvertedManufacturerName;
ObjectDataSource1.UpdateParameters["ImageName"].DefaultValue = ImageName;
ObjectDataSource1.UpdateParameters["ManufacturerName"].DefaultValue = ManufacturerName;
ObjectDataSource1.UpdateParameters["IsAvailable"].DefaultValue = strIsAvailable;
ObjectDataSource1.UpdateParameters["ManufacturerNameEn"].DefaultValue = ManufacturerNameEn;
if (!string.IsNullOrEmpty(ImageName))
{
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
if (File.Exists(strOldThumbImagePath))
{
File.Delete(strOldThumbImagePath);
}
ImageName = (string.IsNullOrEmpty(ConvertedManufacturerName) ? "" : ConvertedManufacturerName + "-") + ManufacturerID + ImageName.Substring(ImageName.LastIndexOf('.'));
string strFullPath = "~/res/manufacturer/" + ImageName;
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
//ResizeCropImage.ResizeByCondition(strFullPath, 277, 230);
ResizeCropImage.CreateThumbNailByCondition("~/res/manufacturer/", "~/res/manufacturer/thumbs/", ImageName, 120, 120);
}
}
}
else if (e.CommandName == "DeleteSelected")
{
string OldImageName;
var oManufacturer = new Manufacturer();
string errorList = "", ManufacturerName = "";
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
try
{
var ManufacturerID = item.GetDataKeyValue("ManufacturerID").ToString();
ManufacturerName = item["ManufacturerName"].Text;
oManufacturer.ManufacturerDelete(ManufacturerID);
OldImageName = ((HiddenField)item.FindControl("hdnImageName")).Value;
DeleteImage(OldImageName);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString())
{
errorList += ", " + ManufacturerName;
}
}
}
if (!string.IsNullOrEmpty(errorList))
{
e.Canceled = true;
string strAlertMessage = "Tỉnh/Thành <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang chứa Quận/Huyện.<br /> Xin xóa Quận/Huyện trong Tỉnh/Thành này hoặc thiết lập hiển thị = \"không\".";
lblError.Text = strAlertMessage;
}
}
else if (e.CommandName == "DeleteImage")
{
var oManufacturer = new Manufacturer();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strManufacturerID = s[0];
var ImageName = s[1];
oManufacturer.ManufacturerImageDelete(strManufacturerID);
DeleteImage(ImageName);
RadGrid1.Rebind();
}
}
protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridEditableItem && e.Item.IsInEditMode)
{
var itemtype = e.Item.ItemType;
var row = itemtype == GridItemType.EditFormItem ? (GridEditFormItem)e.Item : (GridEditFormInsertItem)e.Item;
var FileImageName = (RadUpload)row.FindControl("FileImageName");
var dv = (DataView)ObjectDataSource1.Select();
var ProductID = ((HiddenField)row.FindControl("hdnProductID")).Value;
var hdnFromDate = ((HiddenField)row.FindControl("hdnFromDate")).Value;
//var hdnToDate = ((HiddenField)row.FindControl("hdnToDate")).Value;
var ddlCategory = (RadComboBox)row.FindControl("ddlCategory");
var ddlManufacturer = (RadComboBox)row.FindControl("ddlManufacturer");
var ddlOrigin = (RadComboBox)row.FindControl("ddlOrigin");
var dpFromDate = (RadDatePicker)row.FindControl("dpFromDate");
//var dpToDate = (RadDatePicker)row.FindControl("dpToDate");
var dpStartFromDate = (RadTimePicker)row.FindControl("dpStartFromDate");
//var dpEndToDate = (RadTimePicker)row.FindControl("dpEndToDate");
if (!string.IsNullOrEmpty(ProductID))
{
dv.RowFilter = "ProductID = " + ProductID;
if (!string.IsNullOrEmpty(dv[0]["CategoryID"].ToString()))
{
ddlCategory.SelectedValue = dv[0]["CategoryID"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["ManufacturerID"].ToString()))
{
ddlManufacturer.SelectedValue = dv[0]["ManufacturerID"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["OriginID"].ToString()))
{
ddlOrigin.SelectedValue = dv[0]["OriginID"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["DateEvent"].ToString()))
{
var date = DateTime.Parse(dv[0]["DateEvent"].ToString());
dpFromDate.SelectedDate = date;
dpStartFromDate.SelectedDate = date;
}
//if (!string.IsNullOrEmpty(dv[0]["ToDate"].ToString()))
//{
// var edate = DateTime.Parse(dv[0]["ToDate"].ToString());
// dpToDate.SelectedDate = edate;
// dpEndToDate.SelectedDate = edate;
//}
}
else
{
ddlCategory.SelectedValue = ddlSearchCategory.SelectedValue;
ddlManufacturer.SelectedValue = ddlSearchManufacturer.SelectedValue;
ddlOrigin.SelectedValue = ddlSearchOrigin.SelectedValue;
}
RadAjaxPanel1.ResponseScripts.Add(string.Format("window['UploadId'] = '{0}';", FileImageName.ClientID));
}
else if (e.Item is GridDataItem)
{
var ContentRating1 = (Spaanjaars.Toolkit.ContentRating)e.Item.FindControl("ContentRating1");
var oRating = new Rating();
var ProductID = ((GridDataItem)e.Item).GetDataKeyValue("ProductID").ToString();
ContentRating1.ItemId = ProductID;
ContentRating1.DataSource = oRating.RatingSelectAll(ProductID);
ContentRating1.DataBind();
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["Company"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string AddressBookID, Priority, IsShowOnHomePage, IsHot, IsNew, IsAvailable;
var oAđdressBook = new AddressBook1();
foreach (GridDataItem item in RadGrid1.Items)
{
AddressBookID = item.GetDataKeyValue("AddressBookID").ToString();
//Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
//IsShowOnHomePage = ((CheckBox)item.FindControl("chkIsShowOnHomePage")).Checked.ToString();
//IsHot = ((CheckBox)item.FindControl("chkIsHot")).Checked.ToString();
//IsNew = ((CheckBox)item.FindControl("chkIsNew")).Checked.ToString();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oAđdressBook.AddressBook1QuickUpdate(
AddressBookID,
IsAvailable
);
}
}
//else if (e.CommandName == "DeleteSelected")
//{
// string OldImageName;
// var oArticle = new Article();
// foreach (GridDataItem item in RadGrid1.SelectedItems)
// {
// OldImageName = ((HiddenField)item.FindControl("hdnImageName")).Value;
// DeleteImage(OldImageName);
// }
//}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileImageName = (RadUpload)row.FindControl("FileImageName");
var oAddressBook = new AddressBook1();
string strAddressBookID = ((HiddenField)row.FindControl("hdnAddressBookID")).Value;
//string strOldImageName = ((HiddenField)row.FindControl("hdnOldImageName")).Value;
//string strImageName = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : "";
//string strPriority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
//string strMetaTittle = ((TextBox)row.FindControl("txtMetaTittle")).Text.Trim();
//string strMetaDescription = ((TextBox)row.FindControl("txtMetaDescription")).Text.Trim();
//string strArticleTitle = ((TextBox)row.FindControl("txtArticleTitle")).Text.Trim();
//string strConvertedArticleTitle = Common.ConvertTitle(strArticleTitle);
//string strDescription = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescription")).Content.Trim()));
//string strContent = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContent")).Content.Trim()));
//string strTag = ((TextBox)row.FindControl("txtTag")).Text.Trim();
//string strArticleCategoryID = ((RadComboBox)row.FindControl("ddlCategory")).SelectedValue;
//string strIsShowOnHomePage = ((CheckBox)row.FindControl("chkIsShowOnHomePage")).Checked.ToString();
//string strIsHot = ((CheckBox)row.FindControl("chkIsHot")).Checked.ToString();
//string strIsNew = ((CheckBox)row.FindControl("chkIsNew")).Checked.ToString();
string strThanhPho = ((RadComboBox)row.FindControl("ddlProvince")).SelectedValue;
string strQuan = ((RadComboBox)row.FindControl("ddlDistrict")).SelectedValue;
string strCompany = ((TextBox)row.FindControl("txtCompany")).Text.Trim();
string strCompanyEn = ((TextBox)row.FindControl("txtCompanyEn")).Text.Trim();
string strDiaChi = ((TextBox)row.FindControl("txtAddress")).Text.Trim();
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
//string strMetaTittleEn = ((TextBox)row.FindControl("txtMetaTittleEn")).Text.Trim();
//string strMetaDescriptionEn = ((TextBox)row.FindControl("txtMetaDescriptionEn")).Text.Trim();
//string strArticleTitleEn = ((TextBox)row.FindControl("txtArticleTitleEn")).Text.Trim();
//string strDescriptionEn = ((RadEditor)row.FindControl("txtDescriptionEn")).Content.Trim();
//string strContentEn = ((RadEditor)row.FindControl("txtContentEn")).Content.Trim();
//string strTagEn = ((TextBox)row.FindControl("txtTagEn")).Text.Trim();
if (e.CommandName == "PerformInsert")
{
oAddressBook.AddressBook1Insert(
"",
"",
"",
"",
"",
"",
"",
strCompany,
strCompanyEn,
strDiaChi,
"",
"",
"",
"1",
strThanhPho,
strQuan,
strIsAvailable,
"",
"",
""
);
//string strFullPath = "~/res/article/" + strImageName;
//if (!string.IsNullOrEmpty(strImageName))
//{
// FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
// ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
// ResizeCropImage.CreateThumbNailByCondition("~/res/article/", "~/res/article/thumbs/", strImageName, 120, 120);
//}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
//var strOldImagePath = Server.MapPath("~/res/article/" + strOldImageName);
//var strOldThumbImagePath = Server.MapPath("~/res/article/thumbs/" + strOldImageName);
dsUpdateParam["Company"].DefaultValue = strCompany;
dsUpdateParam["CompanyEn"].DefaultValue = strCompanyEn;
dsUpdateParam["Address1"].DefaultValue = strDiaChi;
dsUpdateParam["CountryID"].DefaultValue = "1";
dsUpdateParam["ProvinceID"].DefaultValue = strThanhPho;
dsUpdateParam["DistrictID"].DefaultValue = strQuan;
dsUpdateParam["IsPrimary"].DefaultValue = strIsAvailable;
//if (!string.IsNullOrEmpty(strImageName))
//{
// if (File.Exists(strOldImagePath))
// File.Delete(strOldImagePath);
// if (File.Exists(strOldThumbImagePath))
// File.Delete(strOldThumbImagePath);
// strImageName = (string.IsNullOrEmpty(strConvertedArticleTitle) ? "" : strConvertedArticleTitle + "-") + strArticleID + strImageName.Substring(strImageName.LastIndexOf('.'));
// string strFullPath = "~/res/article/" + strImageName;
// FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
// ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
// ResizeCropImage.CreateThumbNailByCondition("~/res/article/", "~/res/article/thumbs/", strImageName, 120, 120);
//}
}
}
//if (e.CommandName == "DeleteImage")
//{
// var oArticle = new Article();
// var lnkDeleteImage = (LinkButton)e.CommandSource;
// var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
// var strArticleID = s[0];
// var strImageName = s[1];
// oArticle.ArticleImageDelete(strArticleID);
// DeleteImage(strImageName);
// RadGrid1.Rebind();
//}
}
public void GridView1_RowUpdating(Object sender, GridViewUpdateEventArgs e)
{
try
{
Int64 discountID;
DateTime startDate;
DateTime expiryDate;
Int32 maxPrints;
int index = e.RowIndex;
GridViewRow row = GridView1.Rows[index];
gridErrorMessage.Text = " ";
//System.Windows.Forms.MessageBox.Show(e.NewValues[1].ToString());
//discountID = Convert.ToInt64(row.Cells[1].Text);
string discountText = ((Label)GridView1.Rows[e.RowIndex].FindControl("lblDisCntID")).Text;
if (!Int64.TryParse(discountText, out discountID))
{
gridErrorMessage.Text = "Invalid Discount Id";
e.Cancel = true;
}
//TextBox tb = (TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0];
string Header = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtHeader")).Text;
string Desc = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtDescription")).Text;
string Excep = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtExceptions")).Text;
if (string.IsNullOrEmpty(Header))
{
gridErrorMessage.Text = "Header cannot be empty";
e.Cancel = true;
}
// startDate = Convert.ToDateTime(((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtStartDate")).Text);
if (!DateTime.TryParse(((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtStartDate")).Text,
out startDate))
{
gridErrorMessage.Text = "Unknown format for start date. Reenter date in mm/dd/yyyy format. ";
e.Cancel = true;
}
//expiryDate = Convert.ToDateTime(((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtExpiryDate")).Text);
if (!DateTime.TryParse(((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtExpiryDate")).Text,
out expiryDate))
{
gridErrorMessage.Text = "Unknown format for Expiry date. Reenter date in mm/dd/yyyy format. ";
e.Cancel = true;
}
//maxPrints = Convert.ToInt32(((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtMaxNumberofPrints")).Text);
if (!Int32.TryParse(((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtMaxNumberofPrints")).Text,
out maxPrints))
{
gridErrorMessage.Text = "Maximum Prints should be a numeric number.";
e.Cancel = true;
}
//Int32 curPrints = Convert.ToInt32(((Label)GridView1.Rows[e.RowIndex].FindControl("txtMaxNumberofPrints")).Text);
//System.Windows.Forms.MessageBox.Show((Header + "<br>" + Desc + "<br>" + Excep + "<br>" + discountText);
if (!e.Cancel)
{
ObjectDataSource1.UpdateParameters.Clear();
ObjectDataSource1.UpdateParameters.Add("bizDiscountID", TypeCode.Int64, discountID.ToString());
ObjectDataSource1.UpdateParameters.Add("bizID", TypeCode.String, UserID.ToString());
ObjectDataSource1.UpdateParameters.Add("header", TypeCode.String, Header.ToString());
ObjectDataSource1.UpdateParameters.Add("description", TypeCode.String, Desc.ToString());
ObjectDataSource1.UpdateParameters.Add("exceptions", TypeCode.String, Excep.ToString());
ObjectDataSource1.UpdateParameters.Add("startDate", TypeCode.String, startDate.ToString());
ObjectDataSource1.UpdateParameters.Add("expiryDate", TypeCode.String, expiryDate.ToString());
ObjectDataSource1.UpdateParameters.Add("maxNumberofPrints", TypeCode.String, maxPrints.ToString());
//ObjectDataSource1.UpdateParameters.Add("currentPrints", TypeCode.String, curPrints.ToString());
//System.Windows.Forms.MessageBox.Show(Header + "<br>" + Desc + "<br>" + Excep + "<br>" + discountText);
ObjectDataSource1.Update();
// GridView1_Bind();
}
}
catch (Exception err)
{
//System.Windows.Forms.MessageBox.Show(err.InnerException.Message);
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["DownloadName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string DownloadID, Priority, IsAvailable;
var oDownload = new Download();
foreach (GridDataItem item in RadGrid1.Items)
{
DownloadID = item.GetDataKeyValue("DownloadID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oDownload.DownloadQuickUpdate(
DownloadID,
IsAvailable,
Priority
);
}
}
else if (e.CommandName == "DeleteSelected")
{
string OldImageName, OldFilePath;
var oDownload = new Download();
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
OldImageName = ((HiddenField)item.FindControl("hdnImageName")).Value;
OldFilePath = ((HiddenField)item.FindControl("hdnFilePath")).Value;
DeleteImage(OldImageName);
DeleteDownload(OldFilePath);
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileImageName = (RadUpload)row.FindControl("FileImageName");
var FileFilePath = (RadUpload)row.FindControl("FileFilePath");
var oDownload = new Download();
string DownloadID = ((HiddenField)row.FindControl("hdnDownloadID")).Value;
string OldImageName = ((HiddenField)row.FindControl("hdnOldImageName")).Value;
string OldFilePath = ((HiddenField)row.FindControl("hdnOldFilePath")).Value;
string ImageName = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : "";
string FilePath = FileFilePath.UploadedFiles.Count > 0 ? FileFilePath.UploadedFiles[0].GetName() : "";
string Priority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
string DownloadName = ((TextBox)row.FindControl("txtDownloadName")).Text.Trim();
string DownloadNameEn = ((TextBox)row.FindControl("txtDownloadNameEn")).Text.Trim();
string ConvertedDownloadName = Common.ConvertTitle(DownloadName);
string DownloadCategoryID = ((RadComboBox)row.FindControl("ddlCategory")).SelectedValue;
string IsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
if (e.CommandName == "PerformInsert")
{
DownloadID = oDownload.DownloadInsert(
DownloadName,
DownloadNameEn,
ConvertedDownloadName,
ImageName,
FilePath,
DownloadCategoryID,
IsAvailable,
Priority
).ToString();
ImageName = string.IsNullOrEmpty(ImageName) ? "" : (string.IsNullOrEmpty(ConvertedDownloadName) ? "" : ConvertedDownloadName + "-") + DownloadID + Path.GetExtension(FileImageName.UploadedFiles[0].GetName());
string strFullImagePath = "~/res/download/thumbs/" + ImageName;
string strFullFilePath = "~/res/download/" + FilePath;
if (FileFilePath.UploadedFiles.Count > 0)
{
FileFilePath.UploadedFiles[0].SaveAs(Server.MapPath(strFullFilePath));
}
if (FileImageName.UploadedFiles.Count > 0)
{
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullImagePath));
ResizeCropImage.ResizeByCondition(strFullImagePath, 120, 120);
}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strOldImagePath = Server.MapPath("~/res/download/thumbs/" + OldImageName);
var strOldFilePath = Server.MapPath("~/res/download/" + OldFilePath);
dsUpdateParam["ConvertedDownloadName"].DefaultValue = ConvertedDownloadName;
dsUpdateParam["ImageName"].DefaultValue = ImageName;
dsUpdateParam["FilePath"].DefaultValue = FilePath;
dsUpdateParam["DownloadCategoryID"].DefaultValue = DownloadCategoryID;
dsUpdateParam["IsAvailable"].DefaultValue = IsAvailable;
if (!string.IsNullOrEmpty(FilePath))
{
if (File.Exists(strOldFilePath))
{
File.Delete(strOldFilePath);
}
string strFullPath = "~/res/download/" + FilePath;
FileFilePath.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
}
if (!string.IsNullOrEmpty(ImageName))
{
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
ImageName = (string.IsNullOrEmpty(ConvertedDownloadName) ? "" : ConvertedDownloadName + "-") + DownloadID + ImageName.Substring(ImageName.LastIndexOf('.'));
string strFullPath = "~/res/download/thumbs/" + ImageName;
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
ResizeCropImage.ResizeByCondition(strFullPath, 120, 120);
}
}
}
if (e.CommandName == "DeleteImage")
{
var oDownload = new Download();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strDownloadID = s[0];
var ImageName = s[1];
oDownload.DownloadImageDelete(strDownloadID);
DeleteImage(ImageName);
RadGrid1.Rebind();
}
}
protected void DDDLphase_DataBinding(object sender, EventArgs e)
{
DataView dv = (DataView)ObjectDataSource1.Select();
DataRow dr = (DataRow)dv.Table.Rows[0];
string ls_fltr = dr.ItemArray[3].ToString();
initPhase = ls_fltr;
DropDownList ddl = sender as DropDownList;
HiddenField FilterArg1 = (HiddenField)ddl.Parent.FindControl("FilterArg1");
HiddenField FilterArg2 = (HiddenField)ddl.Parent.FindControl("FilterArg2");
HiddenField FilterArg3 = (HiddenField)ddl.Parent.FindControl("FilterArg3");
if (FormView1.CurrentMode == FormViewMode.Edit)
{
switch (ls_fltr)
{
case "IWOR":
FilterArg1.Value = "IWOR";
FilterArg2.Value = "SUSP";
FilterArg3.Value = "IWOR";
break;
case "WORA":
FilterArg1.Value = "WORR";
FilterArg2.Value = "SUSP";
FilterArg3.Value = "WORA";
// Logic needed to determine if PM is viewing page. Otherwise read-only.
break;
case "WORD":
FilterArg1.Value = "WORM";
FilterArg2.Value = "SUSP";
FilterArg3.Value = "WORD";
break;
case "WOTS":
FilterArg1.Value = "WOTS";
FilterArg2.Value = "SUSP";
FilterArg3.Value = "WORM";
break;
case "WDEV":
FilterArg1.Value = "WDEV";
FilterArg2.Value = "SUSP";
FilterArg3.Value = "WORM";
break;
case "WTST":
FilterArg1.Value = "WTST";
FilterArg2.Value = "SUSP";
FilterArg3.Value = "WORM";
break;
case "GONG":
FilterArg1.Value = "GONG";
FilterArg2.Value = "SUSP";
FilterArg3.Value = "WORM";
break;
case "IMPL":
FilterArg1.Value = "IMPL";
FilterArg2.Value = "SUSP";
FilterArg3.Value = "WORM";
break;
case "WORM":
FilterArg1.Value = "WORM";
FilterArg2.Value = "SUSP";
FilterArg3.Value = "WORM";
break;
case "WORR":
FilterArg1.Value = "WORR";
FilterArg2.Value = "SUSP";
FilterArg3.Value = "WORM";
break;
default:
FilterArg1.Value = "IWOR";
FilterArg2.Value = "SUSP";
FilterArg3.Value = "WORM";
break;
}
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["HoTen"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string DatLichKhamID, Priority, IsAvailable;
var oDatLichKham = new DatLichKham();
foreach (GridDataItem item in RadGrid1.Items)
{
DatLichKhamID = item.GetDataKeyValue("DatLichKhamID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oDatLichKham.DatLichKhamQuickUpdate(
DatLichKhamID,
IsAvailable,
Priority
);
}
}
//else if (e.CommandName == "DeleteSelected")
//{
// var oDatLichKham = new DatLichKham();
// foreach (GridDataItem item in RadGrid1.SelectedItems)
// {
// string strDatLichKhamImage = ((HiddenField)item.FindControl("hdnDatLichKhamImage")).Value;
// if (!string.IsNullOrEmpty(strDatLichKhamImage))
// {
// string strSavePath = Server.MapPath("~/res/DatLichKham/" + strDatLichKhamImage);
// if (File.Exists(strSavePath))
// File.Delete(strSavePath);
// }
// }
//}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
string strDatLich = ((RadioButtonList)row.FindControl("radioDatLich")).SelectedValue;
string strHoTen = ((TextBox)row.FindControl("txtHoTen")).Text.Trim();
var dpNgaySinh = (RadDatePicker)row.FindControl("dpNgaySinh");
string strNgaySinh = dpNgaySinh.SelectedDate.HasValue ? dpNgaySinh.SelectedDate.Value.ToShortDateString() : "";
string strGioiTinh = ((RadioButtonList)row.FindControl("radioGioiTinh")).SelectedValue;
string strDienThoai = ((TextBox)row.FindControl("txtDienThoai")).Text.Trim();
string strEmail = ((TextBox)row.FindControl("txtEmail")).Text.Trim();
string strChuyenKhoa = ((DropDownList)row.FindControl("dropChuyenKhoa")).SelectedValue;
string strBacSi = ((DropDownList)row.FindControl("dropBacSi")).SelectedValue;
string strMoTa = ((TextBox)row.FindControl("txtMoTa")).Text.Trim();
var dpNgayKham = (RadDatePicker)row.FindControl("dpNgayKham");
var dpGioKham = (RadTimePicker)row.FindControl("dpGioKham");
var strNgayKham = dpNgayKham.SelectedDate.HasValue ? dpNgayKham.SelectedDate.Value.ToShortDateString() : "";
var strGioKham = dpGioKham.SelectedDate.HasValue ? dpGioKham.SelectedDate.Value.ToShortTimeString() : "";
strNgayKham = string.IsNullOrEmpty(strNgayKham) ? "" : strNgayKham + " " + strGioKham;
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string strPriority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
var oDatLichKham = new DatLichKham();
if (e.CommandName == "PerformInsert")
{
oDatLichKham.DatLichKhamInsert(
strDatLich,
strHoTen,
strNgaySinh,
strGioiTinh,
strDienThoai,
strEmail,
strChuyenKhoa,
strBacSi,
strMoTa,
strNgayKham,
"",
strIsAvailable,
strPriority
);
RadGrid1.Rebind();
//var dsInsertParam = ObjectDataSource1.InsertParameters;
//dsInsertParam["DatLichCho"].DefaultValue = strDatLich;
//dsInsertParam["HoTen"].DefaultValue = strHoTen;
//dsInsertParam["NgaySinh"].DefaultValue = strNgaySinh;
//dsInsertParam["GioiTinh"].DefaultValue = strGioiTinh;
//dsInsertParam["DienThoai"].DefaultValue = strDienThoai;
//dsInsertParam["Email"].DefaultValue = strEmail;
//dsInsertParam["ProjectCategoryID"].DefaultValue = strChuyenKhoa;
//dsInsertParam["ProjectID"].DefaultValue = strBacSi;
//dsInsertParam["MoTa"].DefaultValue = strMoTa;
//dsInsertParam["NgayKham"].DefaultValue = strNgayKham;
//dsInsertParam["IsAvailable"].DefaultValue = strIsAvailable;
//dsInsertParam["Priority"].DefaultValue = strPriority;
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strDatLichKhamID = row.GetDataKeyValue("DatLichKhamID").ToString();
//var strOldDatLichKhamImage = ((HiddenField)row.FindControl("hdnDatLichKhamImage")).Value;
//var strOldImagePath = Server.MapPath("~/res/DatLichKham/" + strOldDatLichKhamImage);
dsUpdateParam["DatLichCho"].DefaultValue = strDatLich;
dsUpdateParam["HoTen"].DefaultValue = strHoTen;
dsUpdateParam["NgaySinh"].DefaultValue = strNgaySinh;
dsUpdateParam["GioiTinh"].DefaultValue = strGioiTinh;
dsUpdateParam["DienThoai"].DefaultValue = strDienThoai;
dsUpdateParam["Email"].DefaultValue = strEmail;
dsUpdateParam["ProjectCategoryID"].DefaultValue = strChuyenKhoa;
dsUpdateParam["ProjectID"].DefaultValue = strBacSi;
dsUpdateParam["MoTa"].DefaultValue = strMoTa;
dsUpdateParam["NgayKham"].DefaultValue = strNgayKham;
dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable;
dsUpdateParam["Priority"].DefaultValue = strPriority;
}
}
//if (e.CommandName == "DeleteImage")
//{
// var oDatLichKham = new DatLichKham();
// var lnkDeleteImage = (LinkButton)e.CommandSource;
// var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
// var strDatLichKhamID = s[0];
// var strDatLichKhamImage = s[1];
// oDatLichKham.DatLichKhamImageDelete(strDatLichKhamID);
// DeleteImage(strDatLichKhamImage);
// RadGrid1.Rebind();
//}
}
protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
lblTongSoDatHen.Text = ((DataView)ObjectDataSource1.Select()).Count.ToString();
if (e.Item is GridEditableItem && e.Item.IsInEditMode)
{
var itemtype = e.Item.ItemType;
var row = itemtype == GridItemType.EditFormItem ? (GridEditFormItem)e.Item : (GridEditFormInsertItem)e.Item;
//var FileDatLichKhamImage = (RadUpload)row.FindControl("FileDatLichKhamImage");
var dv = (DataView)ObjectDataSource1.Select();
var DatLichKhamID = ((HiddenField)row.FindControl("hdnDatLichKhamID")).Value;
var hdnNgaySinh = ((HiddenField)row.FindControl("hdnNgaySinh")).Value;
var hdnNgayKham = ((HiddenField)row.FindControl("hdnNgayKham")).Value;
var dpNgaySinh = (RadDatePicker)row.FindControl("dpNgaySinh");
var dpNgayKham = (RadDatePicker)row.FindControl("dpNgayKham");
var dpGioKham = (RadTimePicker)row.FindControl("dpGioKham");
var dropChuyenKhoa = (DropDownList)row.FindControl("dropChuyenKhoa");
var dropBacSi = (DropDownList)row.FindControl("dropBacSi");
var radioDatLich = (RadioButtonList)row.FindControl("radioDatLich");
var radioGioiTinh = (RadioButtonList)row.FindControl("radioGioiTinh");
if (!string.IsNullOrEmpty(DatLichKhamID))
{
dv.RowFilter = "DatLichKhamID = " + DatLichKhamID;
if (!string.IsNullOrEmpty(dv[0]["ProjectCategoryID"].ToString()))
{
dropChuyenKhoa.SelectedValue = dv[0]["ProjectCategoryID"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["ProjectID"].ToString()))
{
dropBacSi.SelectedValue = dv[0]["ProjectID"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["NgaySinh"].ToString()))
{
var date = DateTime.Parse(dv[0]["NgaySinh"].ToString());
dpNgaySinh.SelectedDate = date;
}
if (!string.IsNullOrEmpty(dv[0]["NgayKham"].ToString()))
{
var edate = DateTime.Parse(dv[0]["NgayKham"].ToString());
dpNgayKham.SelectedDate = edate;
dpGioKham.SelectedDate = edate;
}
if (!string.IsNullOrEmpty(dv[0]["DatLichCho"].ToString()))
{
radioDatLich.SelectedValue = dv[0]["DatLichCho"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["GioiTinh"].ToString()))
{
radioGioiTinh.SelectedValue = dv[0]["GioiTinh"].ToString();
}
}
//RadAjaxPanel1.ResponseScripts.Add(string.Format("window['UploadId'] = '{0}';", FileDatLichKhamImage.ClientID));
}
}
protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridEditableItem && e.Item.IsInEditMode)
{
var itemtype = e.Item.ItemType;
var row = itemtype == GridItemType.EditFormItem ? (GridEditFormItem)e.Item : (GridEditFormInsertItem)e.Item;
var FileImageName = (RadUpload)row.FindControl("FileImageName");
var dv = (DataView)ObjectDataSource1.Select();
var ProductID = ((HiddenField)row.FindControl("hdnProductID")).Value;
var ddlCategory = (RadComboBox)row.FindControl("ddlCategory");
var ddlManufacturer = (RadComboBox)row.FindControl("ddlManufacturer");
var ddlProductGender = ((RadComboBox)row.FindControl("ddlProductGender"));
var ddlProductNongDo = ((RadComboBox)row.FindControl("ddlProductNongDo"));
var ddlProductMuiHuong = ((RadComboBox)row.FindControl("ddlProductMuiHuong"));
var ddlProductDungTich = ((RadComboBox)row.FindControl("ddlProductDungTich"));
var ddlProductPhongCach = ((RadComboBox)row.FindControl("ddlProductPhongCach"));
var ddlProductHoanCanh = ((RadComboBox)row.FindControl("ddlProductHoanCanh"));
var ddlOrigin = (RadComboBox)row.FindControl("ddlOrigin");
if (!string.IsNullOrEmpty(ProductID))
{
dv.RowFilter = "ProductID = " + ProductID;
if (!string.IsNullOrEmpty(dv[0]["CategoryID"].ToString()))
{
ddlCategory.SelectedValue = dv[0]["CategoryID"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["ManufacturerID"].ToString()))
{
ddlManufacturer.SelectedValue = dv[0]["ManufacturerID"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["ProductGenderID"].ToString()))
{
ddlProductGender.SelectedValue = dv[0]["ProductGenderID"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["ProductNongDoID"].ToString()))
{
ddlProductNongDo.SelectedValue = dv[0]["ProductNongDoID"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["ProductMuiHuongID"].ToString()))
{
ddlProductMuiHuong.SelectedValue = dv[0]["ProductMuiHuongID"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["ProductDungTichID"].ToString()))
{
ddlProductDungTich.SelectedValue = dv[0]["ProductDungTichID"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["ProductPhongCachID"].ToString()))
{
ddlProductPhongCach.SelectedValue = dv[0]["ProductPhongCachID"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["ProductHoanCanhID"].ToString()))
{
ddlProductHoanCanh.SelectedValue = dv[0]["ProductHoanCanhID"].ToString();
}
if (!string.IsNullOrEmpty(dv[0]["OriginID"].ToString()))
{
ddlOrigin.SelectedValue = dv[0]["OriginID"].ToString();
}
}
else
{
ddlCategory.SelectedValue = ddlSearchCategory.SelectedValue;
ddlManufacturer.SelectedValue = ddlSearchManufacturer.SelectedValue;
ddlOrigin.SelectedValue = ddlSearchOrigin.SelectedValue;
}
RadAjaxPanel1.ResponseScripts.Add(string.Format("window['UploadId'] = '{0}';", FileImageName.ClientID));
}
else if (e.Item is GridDataItem)
{
var ContentRating1 = (Spaanjaars.Toolkit.ContentRating)e.Item.FindControl("ContentRating1");
var oRating = new Rating();
var ProductID = ((GridDataItem)e.Item).GetDataKeyValue("ProductID").ToString();
ContentRating1.ItemId = ProductID;
ContentRating1.DataSource = oRating.RatingSelectAll(ProductID);
ContentRating1.DataBind();
}
}
protected void FormView1_ItemInserted(object sender, FormViewInsertedEventArgs e)
{
int rws = e.AffectedRows;
woPhaseBLL woPhaseLogic = new woPhaseBLL();
WorkOrderBLL woLogic = new WorkOrderBLL();
int wonum = (woLogic.GetMaxWOnum(e.Values[3].ToString()) - 1);
bool lb_rtn;
//SmtpEmail mailMessage = new SmtpEmail();
//bool lb_rtn = mailMessage.Send(e.Values["word_Author"].ToString(), e.Values["word_PMorSME"].ToString(), "Work Order Creation - " + e.Values[3].ToString()
// + " WO# " + wonum + " - " + e.Values["word_Title"].ToString(),
// "WO# " + wonum + " - " + e.Values["word_Title"].ToString() + " requires your attention." +
// " Log into the EBS Work Order Module for details. Please do not respond to this email.", wonum, 0, e.Values["word_Proj"].ToString());
// Insert a WOphase record, update the WOrole table and update the WorkOrder table record as well.
WorkOrder.WorkOrderDataTable WrkOrds = woLogic.GetWorkOrdersByWOnumProj(wonum, e.Values["word_Proj"].ToString());
WorkOrder.WorkOrderRow WrkOrd = WrkOrds[0];
int PhaseNum = woPhaseLogic.InsertPhaseRecord(wonum, WrkOrd.word_Proj, 0, DateTime.Now,
"IWOR", 0, Convert.ToInt32(User.Identity.Name.Substring(User.Identity.Name.IndexOf("\\") + 1)));
RolesBLL roleLogic = new RolesBLL();
lb_rtn = roleLogic.InsertWOroles(wonum, Convert.ToInt32(WrkOrd.word_Author), WrkOrd.word_Proj, "AUTH", false, true);
lb_rtn = roleLogic.InsertWOroles(wonum, Convert.ToInt32(WrkOrd.word_BusnOwner), WrkOrd.word_Proj, "BOWN", false, true);
lb_rtn = roleLogic.InsertWOroles(wonum, Convert.ToInt32(WrkOrd.word_PMorSME), WrkOrd.word_Proj, "PM", false, true);
DataView dv = (DataView)ObjectDataSource1.Select();
DataRow dr = (DataRow)dv.Table.Rows[0];
FormView fv = sender as FormView;
if (fv.CurrentMode == FormViewMode.Insert)
{
DropDownList DropDownListPhaseStat = (DropDownList)fv.Row.FindControl("DropDownListPhaseStat");
int PhaseStat = Convert.ToInt32(DropDownListPhaseStat.SelectedValue);
if (PhaseStat == 1)
{
int PhaseNumb = woPhaseLogic.InsertPhaseRecord(wonum, WrkOrd.word_Proj, 0, DateTime.Now,
"WORA", 0, Convert.ToInt32(User.Identity.Name.Substring(User.Identity.Name.IndexOf("\\") + 1)));
WrkOrd.word_Status = "WORA";
WrkOrd.word_statFlag = 0;
WrkOrd.word_StatNum = PhaseNumb;
//DateTimePicker DTimePicker = (DateTimePicker)fv.Row.FindControl("CalendarExtender1");
//string ls_val = DTimePicker.Value.ToString();
//TextBox TxtBxReqDate = (TextBox)fv.Row.FindControl("word_reqDueDateTextBox");
//TxtBxReqDate.Text = ls_val;
//WrkOrd.word_reqDueDate = Convert.ToDateTime(DTimePicker.Value.ToString());
lb_rtn = woLogic.UpdateWorkOrder(WrkOrd.word_WOnum, WrkOrd.word_Proj, WrkOrd.word_StatNum,
WrkOrd.word_Status, WrkOrd.word_statFlag, WrkOrd.word_Date, WrkOrd.word_Author,
WrkOrd.word_Title, WrkOrd.word_Doc.ToString(), WrkOrd.word_DocVer.ToString(), WrkOrd.word_Priority,
WrkOrd.word_Descr, WrkOrd.word_Justify, WrkOrd.word_Cmnts, WrkOrd.word_PMorSME,
WrkOrd.word_BusnOwner, WrkOrd.word_reqDueDate, WrkOrd.word_WOnum, WrkOrd.word_Proj);
}
}
Response.Redirect("~/WorkOrder/Default.aspx?word_Proj=" + WrkOrd.word_Proj.ToString());
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//Row Deleting of emmployee
ObjectDataSource1.DeleteParameters["ECode"].DefaultValue = e.Values[0].ToString();
ObjectDataSource1.Delete();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//Depat row Deleting
ObjectDataSource1.DeleteParameters["Dno"].DefaultValue = e.Values[0].ToString();
ObjectDataSource1.Delete();
}
private void getData()
{
ObjectDataSource1.FilterExpression = "BorrowerNumber = " + txtBorrowerNumber.Text + " and returnedDate is NULL";
ObjectDataSource1.DataBind();
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["UserName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string UserName, Role;
var oUser = new User();
foreach (GridDataItem item in RadGrid1.Items)
{
UserName = item["UserName"].Text;
Role = ((RadComboBox)item.FindControl("ddlRole")).SelectedValue;
oUser.ChangeRole(UserName, Role);
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
try
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileAvatarImage = (RadUpload)row.FindControl("FileAvatarImage");
string strAvatarImage = FileAvatarImage.UploadedFiles.Count > 0 ? FileAvatarImage.UploadedFiles[0].FileName : "";
var strUserID = ((HiddenField)row.FindControl("hdnUserID")).Value;
//var oUser = new User();
var AddressBookID = ((HiddenField)row.FindControl("hdnAddressBookID")).Value.ToString().Trim();
var hdnUserName = ((HiddenField)row.FindControl("hdnUserName")).Value.ToString().Trim();
var hdnEmail = ((HiddenField)row.FindControl("hdnEmail")).Value.ToString().Trim();
var strUserName = ((TextBox)row.FindControl("txtUserName")).Text;
if (strUserName == "")
{
strUserName = hdnUserName;
}
string ConvertedFirstName = Common.ConvertTitle(strUserName);
var strEmail = ((TextBox)row.FindControl("txtEmail")).Text;
if (strEmail == "")
{
strEmail = hdnEmail;
}
var strPassword = ((TextBox)row.FindControl("txtPassword")).Text;
var strCompanyName = ((TextBox)row.FindControl("txtCompanyName")).Text;
var strAddress1 = ((TextBox)row.FindControl("txtAddress")).Text;
var strFullName = ((TextBox)row.FindControl("txtFullName")).Text;
var strCellPhone = ((TextBox)row.FindControl("txtCellPhone")).Text;
string strOldImageName = ((HiddenField)row.FindControl("hdnOldImageName")).Value;
if (e.CommandName == "PerformInsert")
{
var ListViewRoles = (ListView)row.FindControl("lvListViewRoles");
string[] dsRoles = Roles.GetRolesForUser(strUserName);
Membership.CreateUser(strUserName, strPassword, strEmail);
if (string.IsNullOrEmpty(strUserID))
{
strUserID = Membership.GetUser(strUserName).ProviderUserKey.ToString();
}
foreach (ListViewItem item in ListViewRoles.Items)
{
var check = (CheckBox)item.FindControl("chkRoles");
if (check.Checked == true)
{
Roles.AddUserToRole(strUserName, check.Text);
}
}
var oUserProfile = new AddressBook();
oUserProfile.AddressBookInsert2(
strFullName,
"",
strEmail,
strCellPhone,
"",
"",
strEmail,//strUserName,
strCompanyName,
strAddress1,
"",
"",
"",
"",
"",
"",
"",
"",
"",
"member",
"",
""
);
//var oUserProfile = new UserProfile();
//oUserProfile.UserProfileInsert(strUserID, strCompanyName, strFullName, "", "", strCellPhone, "", "", "true");
}
else
{
var UserName = ((HiddenField)row.FindControl("hdnUserName")).Value.ToString().Trim();
var ListViewRoles = (ListView)row.FindControl("lvListViewRoles");
string[] dsRoles = Roles.GetRolesForUser(UserName);
Roles.RemoveUserFromRoles(UserName, dsRoles);
foreach (ListViewItem item in ListViewRoles.Items)
{
var check = (CheckBox)item.FindControl("chkRoles");
if (check.Checked == true)
{
Roles.AddUserToRole(UserName, check.Text);
}
}
var oUserProfile = new AddressBook();
oUserProfile.AddressBookUpdate2(
AddressBookID,
strFullName,
"",
strEmail,
strCellPhone,
"",
"",
strEmail,//strUserName,
strCompanyName,
strAddress1,
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
""
);
//var oUserProfile = new UserProfile();
//oUserProfile.UserProfileUpdate(
// strUserID,
// strCompanyName,
// strFullName,
// "",
// "",
// strCellPhone,
// "",
// strAvatarImage,
// "true"
// );
}
var strOldImagePath = Server.MapPath("~/res/userprofile/" + strOldImageName);
if (!string.IsNullOrEmpty(strAvatarImage))
{
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
string strFullPath = "~/res/userprofile/" + (string.IsNullOrEmpty(ConvertedFirstName) ? "" : ConvertedFirstName) + strAvatarImage.Substring(strAvatarImage.LastIndexOf('.'));
FileAvatarImage.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
ResizeCropImage.ResizeByCondition(strFullPath, 100, 100);
}
RadGrid1.Rebind();
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
else if (e.CommandName == "DeleteSelected")
{
string OldAvatarImage;
var oUserProfile = new AddressBook();
var oUser = new User();
string errorList = "", UserName = "";
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
try
{
var UserID = item.GetDataKeyValue("UserID").ToString();
UserName = item["UserName"].Text;
oUserProfile.AddressBookDeleteByUserName(UserName);
oUser.UserDelete(UserName);
OldAvatarImage = ((HiddenField)item.FindControl("hdnAvatarImage")).Value;
DeleteImage(OldAvatarImage);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString())
{
errorList += ", " + UserName;
}
}
}
if (!string.IsNullOrEmpty(errorList))
{
e.Canceled = true;
string strAlertMessage = "Tài khoản <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang có tin đăng BĐS .<br /> Xin xóa tin đăng hoặc sử dụng chức năng khoá tài khoản.";
lblError.Text = strAlertMessage;
}
RadGrid1.Rebind();
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["ProductColorName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "DeleteSelected")
{
var oProductColor = new ProductColor();
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
string strProductColorImages = ((HiddenField)item.FindControl("hdnProductColorImages")).Value;
if (!string.IsNullOrEmpty(strProductColorImages))
{
string strSavePath = Server.MapPath("~/res/productcolor/" + strProductColorImages);
if (File.Exists(strSavePath))
{
File.Delete(strSavePath);
}
}
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileProductColorImages = (RadUpload)row.FindControl("FileProductColorImages");
string strProductColorName = ((TextBox)row.FindControl("txtProductColorName")).Text.Trim();
string strProductColorDescription = ((TextBox)row.FindControl("txtProductColorDescription")).Text.Trim();
string strConvertedProductColorName = Common.ConvertTitle(strProductColorName);
string strProductColorImages = FileProductColorImages.UploadedFiles.Count > 0 ? FileProductColorImages.UploadedFiles[0].GetName() : "";
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
var oProductColor = new ProductColor();
if (e.CommandName == "PerformInsert")
{
strProductColorImages = oProductColor.ProductColorInsert(
strProductColorName,
strProductColorImages,
strConvertedProductColorName,
strProductColorDescription,
strIsAvailable
);
string strFullPath = "~/res/productcolor/" + strProductColorImages;
if (!string.IsNullOrEmpty(strProductColorImages))
{
FileProductColorImages.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
//ResizeCropImage.ResizeByCondition(strFullPath, 200, 200);
}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strProductColorID = row.GetDataKeyValue("ProductColorID").ToString();
var strOldProductColorImages = ((HiddenField)row.FindControl("hdnProductColorImages")).Value;
var strOldImagePath = Server.MapPath("~/res/productcolor/" + strOldProductColorImages);
oProductColor.ProductColorUpdate(
strProductColorID,
strProductColorName,
strProductColorImages,
strConvertedProductColorName,
strProductColorDescription,
strIsAvailable
);
//dsUpdateParam["ProductColorName"].DefaultValue = strProductColorName;
//dsUpdateParam["ProductColorDescription"].DefaultValue = strProductColorDescription;
//dsUpdateParam["ConvertedProductColorName"].DefaultValue = strConvertedProductColorName;
//dsUpdateParam["ProductColorImages"].DefaultValue = strProductColorImages;
//dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable;
if (!string.IsNullOrEmpty(strProductColorImages))
{
var strFullPath = "~/res/productcolor/" + strConvertedProductColorName + "-" + strProductColorID + strProductColorImages.Substring(strProductColorImages.LastIndexOf('.'));
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
FileProductColorImages.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
//ResizeCropImage.ResizeByCondition(strFullPath, 200, 200);
}
}
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["UserName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string UserName, Role;
var oUser = new User();
foreach (GridDataItem item in RadGrid1.Items)
{
UserName = item["UserName"].Text;
Role = ((RadComboBox)item.FindControl("ddlRole")).SelectedValue;
oUser.ChangeRole(UserName, Role);
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
try
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileAvatarImage = (RadUpload)row.FindControl("FileAvatarImage");
string strAvatarImage = FileAvatarImage.UploadedFiles.Count > 0 ? FileAvatarImage.UploadedFiles[0].FileName : "";
var strUserID = ((HiddenField)row.FindControl("hdnUserID")).Value;
var oUser = new User();
if (e.CommandName == "PerformInsert")
{
var strUserName = ((TextBox)row.FindControl("txtUserName")).Text;
var strEmail = ((TextBox)row.FindControl("txtEmail")).Text;
var strRole = ((RadComboBox)row.FindControl("ddlRole")).SelectedValue;
var strPassword = ((TextBox)row.FindControl("txtPassword")).Text;
//oUser.UserInsert(strUserName, strEmail, strPassword, strRole);
oUser.UserInsert(strEmail, strEmail, strPassword, "member");
if (string.IsNullOrEmpty(strUserID))
{
strUserID = Membership.GetUser(strUserName).ProviderUserKey.ToString();
}
ObjectDataSource1.InsertParameters["UserID"].DefaultValue = strUserID;
ObjectDataSource1.InsertParameters["AvatarImage"].DefaultValue = strAvatarImage;
}
else
{
var strCompanyName = ((TextBox)row.FindControl("txtCompanyName")).Text;
var strFullName = ((TextBox)row.FindControl("txtFullName")).Text;
var strAddress = ((TextBox)row.FindControl("txtAddress")).Text;
var strHomePhone = ((TextBox)row.FindControl("txtHomePhone")).Text;
var strCellPhone = ((TextBox)row.FindControl("txtCellPhone")).Text;
var strFax = ((TextBox)row.FindControl("txtFax")).Text;
var oUserProfile = new UserProfile();
oUserProfile.UserProfileUpdate(
strUserID,
strCompanyName,
strFullName,
strAddress,
strHomePhone,
strCellPhone,
strFax,
strAvatarImage,
"true");
}
if (!string.IsNullOrEmpty(strAvatarImage))
{
string strFullPath = "~/res/userprofile/" + strUserID + strAvatarImage.Substring(strAvatarImage.LastIndexOf('.'));
FileAvatarImage.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
ResizeCropImage.ResizeByCondition(strFullPath, 100, 100);
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
else if (e.CommandName == "DeleteSelected")
{
string OldAvatarImage;
var oUserProfile = new UserProfile();
var oUser = new User();
string errorList = "", UserName = "";
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
try
{
var UserID = item.GetDataKeyValue("UserID").ToString();
UserName = item["UserName"].Text;
oUserProfile.UserProfileDelete(UserID);
oUser.UserDelete(UserName);
OldAvatarImage = ((HiddenField)item.FindControl("hdnAvatarImage")).Value;
DeleteImage(OldAvatarImage);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString())
{
errorList += ", " + UserName;
}
}
}
if (!string.IsNullOrEmpty(errorList))
{
e.Canceled = true;
string strAlertMessage = "Tài khoản <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang có tin đăng BĐS .<br /> Xin xóa tin đăng hoặc sử dụng chức năng khoá tài khoản.";
lblError.Text = strAlertMessage;
}
RadGrid1.Rebind();
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["OriginName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string OriginID, Priority, IsAvailable;
var oOrigin = new Origin();
foreach (GridDataItem item in RadGrid1.Items)
{
OriginID = item.GetDataKeyValue("OriginID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oOrigin.OriginQuickUpdate(
OriginID,
IsAvailable,
Priority
);
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string OriginNameEn = "";
if (e.CommandName == "PerformInsert")
{
ObjectDataSource1.InsertParameters["IsAvailable"].DefaultValue = strIsAvailable;
ObjectDataSource1.InsertParameters["OriginNameEn"].DefaultValue = OriginNameEn;
}
else
{
ObjectDataSource1.UpdateParameters["IsAvailable"].DefaultValue = strIsAvailable;
ObjectDataSource1.UpdateParameters["OriginNameEn"].DefaultValue = OriginNameEn;
}
}
else if (e.CommandName == "DeleteSelected")
{
var oOrigin = new Origin();
string errorList = "", OriginName = "";
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
try
{
var OriginID = item.GetDataKeyValue("OriginID").ToString();
OriginName = item["OriginName"].Text;
oOrigin.OriginDelete(OriginID);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString())
{
errorList += ", " + OriginName;
}
}
}
if (!string.IsNullOrEmpty(errorList))
{
e.Canceled = true;
string strAlertMessage = "Xuất Xứ <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang chứa Sản Phẩm.<br /> Xin xóa Sản phẩm trong Xuất Xứ này hoặc thiết lập hiển thị = \"không\".";
lblError.Text = strAlertMessage;
}
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["Title"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "DeleteSelected")
{
var oVideo = new Video();
string VideoID, OldImageName, OldVideoName;
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
VideoID = item.GetDataKeyValue("VideoID").ToString();
OldImageName = ((HiddenField)item.FindControl("hdnImagePath")).Value;
OldVideoName = ((HiddenField)item.FindControl("hdnVideoPath")).Value;
DeleteImage(OldImageName);
DeleteVideo(OldVideoName);
oVideo.VideoDelete(VideoID);
}
}
else if (e.CommandName == "QuickUpdate")
{
string VideoID, Priority, IsAvailable;
var oVideo = new Video();
foreach (GridDataItem item in RadGrid1.Items)
{
VideoID = item.GetDataKeyValue("VideoID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oVideo.VideoQuickUpdate(
VideoID,
IsAvailable,
Priority
);
}
}
else if (e.CommandName == "DeleteImage")
{
var oVideo = new Video();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strVideoID = s[0];
var strImageName = s[1];
oVideo.VideoImageDelete(strVideoID);
DeleteImage(strImageName);
RadGrid1.Rebind();
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileImagePath = (RadUpload)row.FindControl("FileImagePath");
var FileVideoPath = (RadUpload)row.FindControl("FileVideoPath");
var strVideoID = ((HiddenField)row.FindControl("hdnVideoID")).Value;
var strOldImagePath = ((HiddenField)row.FindControl("hdnOldImagePath")).Value;
var strOldVideoPath = ((HiddenField)row.FindControl("hdnOldVideoPath")).Value;
var strImagePath = FileImagePath.UploadedFiles.Count > 0 ? FileImagePath.UploadedFiles[0].GetName() : "";
var strVideoPath = FileVideoPath.UploadedFiles.Count > 0 ? FileVideoPath.UploadedFiles[0].GetName() : "";
var strTitle = ((TextBox)row.FindControl("txtTitle")).Text.Trim();
var strTitleEn = ((TextBox)row.FindControl("txtTitleEn")).Text.Trim();
var strConvertedTitle = Common.ConvertTitle(strTitle);
var strDescription = ((TextBox)row.FindControl("txtDescription")).Text.Trim();
var strDescriptionEn = ((TextBox)row.FindControl("txtDescriptionEn")).Text.Trim();
var strVideoCategoryID = ((RadComboBox)row.FindControl("ddlCategory")).SelectedValue;
var strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
var oVideo = new Video();
strVideoID = !string.IsNullOrEmpty(strVideoID) ? strVideoID : oVideo.VideoSelectMaxID();
strImagePath = string.IsNullOrEmpty(strImagePath) ? "" : (string.IsNullOrEmpty(strConvertedTitle) ? "" : strConvertedTitle + "-") + strVideoID + strImagePath.Substring(strImagePath.LastIndexOf('.'));
strVideoPath = string.IsNullOrEmpty(strVideoPath) ? "" : (string.IsNullOrEmpty(strConvertedTitle) ? "" : strConvertedTitle + "-") + strVideoID + strVideoPath.Substring(strVideoPath.LastIndexOf('.'));
if (e.CommandName == "PerformInsert")
{
var dsInsertParam = ObjectDataSource1.InsertParameters;
dsInsertParam["ImagePath"].DefaultValue = strImagePath;
dsInsertParam["VideoPath"].DefaultValue = strVideoPath;
dsInsertParam["ConvertedTitle"].DefaultValue = strConvertedTitle;
dsInsertParam["VideoCategoryID"].DefaultValue = strVideoCategoryID;
dsInsertParam["IsAvailable"].DefaultValue = strIsAvailable;
if (FileImagePath.UploadedFiles.Count > 0)
{
strImagePath = "~/res/video/thumbs/" + strImagePath;
FileImagePath.UploadedFiles[0].SaveAs(Server.MapPath(strImagePath));
}
if (FileVideoPath.UploadedFiles.Count > 0)
{
strVideoPath = "~/res/video/" + strVideoPath;
FileVideoPath.UploadedFiles[0].SaveAs(Server.MapPath(strVideoPath));
}
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
dsUpdateParam["ImagePath"].DefaultValue = strImagePath;
dsUpdateParam["VideoPath"].DefaultValue = strVideoPath;
dsUpdateParam["ConvertedTitle"].DefaultValue = strConvertedTitle;
dsUpdateParam["VideoCategoryID"].DefaultValue = strVideoCategoryID;
dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable;
if (FileImagePath.UploadedFiles.Count > 0)
{
strOldImagePath = Server.MapPath("~/res/video/thumbs/" + strOldImagePath);
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
strImagePath = "~/res/video/thumbs/" + strImagePath;
FileImagePath.UploadedFiles[0].SaveAs(Server.MapPath(strImagePath));
}
if (FileVideoPath.UploadedFiles.Count > 0)
{
strOldVideoPath = Server.MapPath("~/res/video/" + strOldVideoPath);
if (File.Exists(strOldVideoPath))
{
File.Delete(strOldVideoPath);
}
strVideoPath = "~/res/video/" + strVideoPath;
FileVideoPath.UploadedFiles[0].SaveAs(Server.MapPath(strVideoPath));
}
}
}
}
//*******************************************************************************************
//Textboxın içindeki değerin değişmeden önceki halini almak için tek yapılması gereken
//altına visible=false olan bir label ekleyip eval tagini sütundaki normal labelların
//Eval("") tagi ile aynı vermek.
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox marka = GridView1.Rows[e.RowIndex].FindControl("TextBox3") as TextBox;
TextBox model = GridView1.Rows[e.RowIndex].FindControl("TextBox4") as TextBox;
Label marka2 = GridView1.Rows[e.RowIndex].FindControl("Label6") as Label;
Label model2 = GridView1.Rows[e.RowIndex].FindControl("Label7") as Label;
string m1 = marka.Text;
string m2 = model.Text;
string m3 = marka2.Text;
string m4 = model2.Text;
otoservisdbEntities db = new otoservisdbEntities();
List <int> query1 = db.aracmarkas.ToList()
.Where(x => x.marka == m1)
.Select(x => x.markaID).ToList();
List <int> query2 = db.aracmodels.ToList()
.Where(x => x.model == m2)
.Select(x => x.modelID).ToList();
//int m1id = Convert.ToInt32(query1[0]);
//int m2id = Convert.ToInt32(query2[0]);
List <int> query5a = db.aracmarkas.ToList()
.Where(x => x.marka == m3)
.Select(x => x.markaID).ToList();
List <int> query5b = db.aracmodels.ToList()
.Where(x => x.model == m4)
.Select(x => x.modelID).ToList();
int m5id = Convert.ToInt32(query5a[0]);
int m6id = Convert.ToInt32(query5b[0]);
if (query2.Count != 0)
{
int m1id = Convert.ToInt32(query1[0]);
int m2id = Convert.ToInt32(query2[0]);
List <string> sorgu1 = db.aracmodels.ToList()
.Where(x => x.markaID == m1id & x.model.Contains(m2))
.Select(x => x.model).ToList();
if (sorgu1.Count != 0)
{
ShowMessageBox(Page, "" + m1 + " markasının " + m2 + " modeli zaten mevcut");
}
else
{
dbarac2.guncelleModel(m5id, m6id, m2);
}
}
else
{
dbarac2.guncelleModel(m5id, m6id, m2);
}
//LabelBilgi2.Text = "Satır bilgisi başarıyla güncellendi";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentSuccess('Satır bilgisi başarıyla güncellendi', 'İŞLEM BAŞARILI');", true);
GridView1.EditIndex = -1;
ObjectDataSource1.DataBind();
GridView1.DataSource = ObjectDataSource1;
GridView1.DataBind();
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["CompanyName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string AdsBannerID, Priority, IsAvailable;
var oAdsBanner = new AdsBanner();
foreach (GridDataItem item in RadGrid1.Items)
{
AdsBannerID = item.GetDataKeyValue("AdsBannerID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oAdsBanner.AdsBannerQuickUpdate(
AdsBannerID,
Priority,
IsAvailable
);
}
}
else if (e.CommandName == "DeleteSelected")
{
var oAdsBanner = new AdsBanner();
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
string strFileName = ((HiddenField)item.FindControl("hdnFileName")).Value;
if (!string.IsNullOrEmpty(strFileName))
{
string strSavePath = Server.MapPath("~/res/advertisement/" + strFileName);
if (File.Exists(strSavePath))
{
File.Delete(strSavePath);
}
}
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileFileName = (RadUpload)row.FindControl("FileFileName");
var dpFromDate = (RadDatePicker)row.FindControl("dpFromDate");
var dpToDate = (RadDatePicker)row.FindControl("dpToDate");
string strCompanyName = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtCompanyName")).Content.Trim()));//((TextBox)row.FindControl("txtCompanyName")).Text.Trim();
//string strTitle = ((TextBox)row.FindControl("txtTitle")).Text.Trim();
//string strDescription = ((TextBox)row.FindControl("txtDescription")).Text.Trim();
string strConvertedAdsBannerName = Common.ConvertTitle(strCompanyName);
string strFileName = FileFileName.UploadedFiles.Count > 0 ? FileFileName.UploadedFiles[0].GetName() : "";
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string strPriority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
string strFromDate = dpFromDate.SelectedDate.HasValue ? dpFromDate.SelectedDate.Value.ToString("MM/dd/yyyy") : "";
string strToDate = dpToDate.SelectedDate.HasValue ? dpToDate.SelectedDate.Value.ToString("MM/dd/yyyy") : "";
string strAdsCategoryID = "8";// ((RadComboBox)row.FindControl("ddlCategory")).SelectedValue;
string strWebsite = ((TextBox)row.FindControl("txtWebsite")).Text.Trim();
double ratio = 0;
if (!string.IsNullOrEmpty(strFileName))
{
string strTempPath = Server.MapPath(FileFileName.TargetFolder + strFileName);
if (IsImageFormat(strFileName))
{
System.Drawing.Image img = System.Drawing.Image.FromFile(strTempPath);
ratio = (double)img.Width / (img.Height == 0 ? 1 : img.Height);
img.Dispose();
}
else
{
SwfParser swfParser = new SwfParser();
Rectangle rectangle = swfParser.GetDimensions(strTempPath);
ratio = (double)rectangle.Width / (rectangle.Height == 0 ? 1 : rectangle.Height);
}
string[] files = Directory.GetFiles(Server.MapPath(FileFileName.TargetFolder));
foreach (string filePath in files)
{
File.Delete(filePath);
}
}
var oAdsBanner = new AdsBanner();
if (e.CommandName == "PerformInsert")
{
strFileName = oAdsBanner.AdsBannerInsert(
strFileName,
strConvertedAdsBannerName,
strAdsCategoryID,
strCompanyName,
strWebsite,
strFromDate,
strToDate,
strPriority,
strIsAvailable,
ratio == 0 ? "" : ratio.ToString().Replace(',', '.')
);
string strFullPath = "~/res/advertisement/" + strFileName;
if (!string.IsNullOrEmpty(strFileName))
{
FileFileName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
if (IsImageFormat(strFileName))
{
//ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
}
}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strAdsBannerID = row.GetDataKeyValue("AdsBannerID").ToString();
var strOldFileName = ((HiddenField)row.FindControl("hdnFileName")).Value;
var strOldImagePath = Server.MapPath("~/res/advertisement/" + strOldFileName);
dsUpdateParam["FileName"].DefaultValue = strFileName;
dsUpdateParam["ConvertedAdsBannerName"].DefaultValue = strConvertedAdsBannerName;
dsUpdateParam["AdsCategoryID"].DefaultValue = strAdsCategoryID;
dsUpdateParam["FromDate"].DefaultValue = strFromDate;
dsUpdateParam["ToDate"].DefaultValue = strToDate;
dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable;
dsUpdateParam["Ratio"].DefaultValue = ratio == 0 ? "" : ratio.ToString().Replace(',', '.');
if (!string.IsNullOrEmpty(strFileName))
{
var strFullPath = "~/res/advertisement/" + (string.IsNullOrEmpty(strConvertedAdsBannerName) ? "" : strConvertedAdsBannerName + "-") + strAdsBannerID + strFileName.Substring(strFileName.LastIndexOf('.'));
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
FileFileName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
if (IsImageFormat(strFileName))
{
//ResizeCropImage.ResizeByCondition(strFullPath, 654, 654);
}
}
}
}
if (e.CommandName == "DeleteImage")
{
var oAdsBanner = new AdsBanner();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strAdsBannerID = s[0];
var strFileName = s[1];
oAdsBanner.AdsBannerDelete(strAdsBannerID);
DeleteImage(strFileName);
RadGrid1.Rebind();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
// First check their LDAP Password . . .
ldapAuthentication ldapAuth = new ldapAuthentication();
try
{
ldapAuth.AuthenticateUser(User.Identity.Name.Substring(User.Identity.Name.IndexOf("\\") + 1).ToString(), txtBxPassword.Text);
}
catch (Exception ex)
{
lblText = Label1.Text;
Label1.Text = ex.Message.ToString();//"Your LDAP UID and/or password did not authenticate. Please try again.";
return;
}
lblText = Label1.Text;// = "Your LDAP UID and/or password did not authenticate. Please try again.";
DataView dv = (DataView)ObjectDataSource1.Select();
//string ls_val;
//string ls_val2;
woApprovalBLL apprvLogic = new woApprovalBLL();
bool lb_rtn = false;
foreach (DataRow dr in dv.Table.Rows)
{
if (Convert.ToInt32(dr["wapr_Approver"]) == Convert.ToInt32(User.Identity.Name.Substring(User.Identity.Name.IndexOf("\\") + 1)))
{
int li_val = Convert.ToInt32(dr["wapr_AprvNum"]);
int li_val1 = li_wonum;
string ls_val = ls_proj;
DateTime ldt_val = Convert.ToDateTime(dr["wapr_AprvDate"].ToString());
int li_val2 = Convert.ToInt32(dr["wapr_Approver"]);
bool lb_val = chkBxApproval.Checked; //Convert.ToBoolean(dr["wapr_AprvCode"]);
DateTime ldt_val2 = DateTime.Now;
string ls_val2 = txtBxComments.Text; // dr["wapr_comments"].ToString();
bool lb_val2 = Convert.ToBoolean(dr["wapr_required"]);
bool lb_val3 = Convert.ToBoolean(dr["wapr_emailFlag"]);
lb_rtn = apprvLogic.UpdateWOAprvlRecord(li_val, li_val1, ls_val, ldt_val, li_val2, lb_val, ldt_val2, ls_val2, lb_val2, lb_val3, li_val);
GridView1.DataBind();
btnUpdate.Visible = false;
btnApprove.Visible = false;
lnkBtnReturn.Visible = true;
Label2.Visible = false;
Label3.Visible = false;
Label4.Visible = false;
Label5.Visible = false;
chkBxApproval.Visible = false;
txtBxPassword.Visible = false;
txtBxComments.Visible = false;
txtBxUser.Visible = false;
Label1.Text = "Update was successful.";
}
}
WorkOrderBLL woLogic = new WorkOrderBLL();
WorkOrder.WorkOrderDataTable WrkOrds = woLogic.GetWorkOrdersByWOnumProj(li_wonum, ls_proj);
WorkOrder.WorkOrderRow WrkOrd = WrkOrds[0];
string host = Request.ServerVariables["SERVER_NAME"]; //HttpContext.Current.Request.Url.Host;
SmtpEmail mailMessage = new SmtpEmail();
string ls_to = "";
RolesBLL WOroleLogic = new RolesBLL();
WorkOrder.WOroleTextDisplayDataTable woRoleDT;
woRoleDT = WOroleLogic.GetWOrolesByWOnumProj(li_wonum, ls_proj);
foreach (WorkOrder.WOroleTextDisplayRow roleRow in woRoleDT)
{
if (Convert.ToBoolean(roleRow["worl_aprvl"]) == true)
{
ls_to = ls_to + "," + roleRow["worl_uid"].ToString();
}
}
ldapClient userObject = new ldapClient();
UserRecord ud;
ud = userObject.SearchUser(User.Identity.Name.Substring(User.Identity.Name.IndexOf("\\") + 1));
lb_rtn = mailMessage.Send(User.Identity.Name.Substring(User.Identity.Name.IndexOf("\\") + 1), ls_to, "GO/NoGO ACTION - " + WrkOrd.word_Proj.ToString()
+ " WO# " + li_wonum + " - " + WrkOrd.word_Title.ToString(),
"WO# " + li_wonum + " - " + WrkOrd.word_Title.ToString() + " has received a Go/NoGo action from " +
ud.FirstName.ToUpper() + " " + ud.LastName.ToUpper() + "." +
" Log into the EBS Work Order Module for details." +
Environment.NewLine + Environment.NewLine + "http://" + host + "/WorkOrder/EditWO.aspx?word_WOnum=" +
li_wonum.ToString() + "&word_Proj=" + WrkOrd.word_Proj.ToString() + Environment.NewLine + Environment.NewLine +
"The comment left on this Go/NoGo action is as follows:" +
Environment.NewLine + Environment.NewLine +
(Convert.ToBoolean(chkBxApproval.Checked) ? "GO! " : "NO Go! ") + Environment.NewLine + Environment.NewLine +
txtBxComments.Text + Environment.NewLine + Environment.NewLine +
Environment.NewLine + Environment.NewLine + "PLEASE DO NOT RESPOND TO THIS EMAIL!"
, li_wonum, 0, WrkOrd.word_Proj.ToString());
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["ArticleTitle"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string ArticleID, Priority, IsShowOnHomePage, IsHot, IsNew, IsAvailable;
var oArticle = new Article();
foreach (GridDataItem item in RadGrid1.Items)
{
ArticleID = item.GetDataKeyValue("ArticleID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsShowOnHomePage = ((CheckBox)item.FindControl("chkIsShowOnHomePage")).Checked.ToString();
IsHot = ((CheckBox)item.FindControl("chkIsHot")).Checked.ToString();
IsNew = ((CheckBox)item.FindControl("chkIsNew")).Checked.ToString();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oArticle.ArticleQuickUpdate(
ArticleID,
IsShowOnHomePage,
IsHot,
IsNew,
IsAvailable,
Priority
);
}
}
else if (e.CommandName == "DeleteSelected")
{
string OldImageName;
string OldIconName;
var oArticle = new Article();
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
OldImageName = ((HiddenField)item.FindControl("hdnImageName")).Value;
DeleteImage(OldImageName);
OldIconName = ((HiddenField)item.FindControl("hdnIconName")).Value;
DeleteIcon(OldIconName);
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileImageName = (RadUpload)row.FindControl("FileImageName");
var FileIconName = (RadUpload)row.FindControl("FileIconName");
var oArticle = new Article();
string strArticleID = ((HiddenField)row.FindControl("hdnArticleID")).Value;
string strOldImageName = ((HiddenField)row.FindControl("hdnOldImageName")).Value;
string strOldIconName = ((HiddenField)row.FindControl("hdnOldIconName")).Value;
string strImageName = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : "";
string strIconName = FileIconName.UploadedFiles.Count > 0 ? FileIconName.UploadedFiles[0].GetName() : "";
string strPriority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
string strMetaTittle = ((TextBox)row.FindControl("txtMetaTittle")).Text.Trim();
string strMetaDescription = ((TextBox)row.FindControl("txtMetaDescription")).Text.Trim();
string strArticleTitle = ((TextBox)row.FindControl("txtArticleTitle")).Text.Trim();
string strConvertedArticleTitle = Common.ConvertTitle(strArticleTitle);
string strDescription = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescription")).Content.Trim()));
string strContent = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContent")).Content.Trim()));
string strTag = ((TextBox)row.FindControl("txtTag")).Text.Trim();
string strArticleCategoryID = "7";//((RadComboBox)row.FindControl("ddlCategory")).SelectedValue;
string strIsShowOnHomePage = ((CheckBox)row.FindControl("chkIsShowOnHomePage")).Checked.ToString();
string strIsHot = ((CheckBox)row.FindControl("chkIsHot")).Checked.ToString();
string strIsNew = ((CheckBox)row.FindControl("chkIsNew")).Checked.ToString();
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string strMetaTittleEn = ((TextBox)row.FindControl("txtMetaTittleEn")).Text.Trim();
string strMetaDescriptionEn = ((TextBox)row.FindControl("txtMetaDescriptionEn")).Text.Trim();
string strArticleTitleEn = ((TextBox)row.FindControl("txtArticleTitleEn")).Text.Trim();
string strDescriptionEn = ((RadEditor)row.FindControl("txtDescriptionEn")).Content.Trim();
string strContentEn = ((RadEditor)row.FindControl("txtContentEn")).Content.Trim();
string strTagEn = ((TextBox)row.FindControl("txtTagEn")).Text.Trim();
string strTitle = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtTitle")).Content.Trim()));
string strTitle2 = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtTitle2")).Content.Trim()));
if (e.CommandName == "PerformInsert")
{
strImageName = oArticle.ArticleInsert(
strImageName,
strIconName,
strMetaTittle,
strMetaDescription,
strArticleTitle,
strConvertedArticleTitle,
strDescription,
strContent,
strTag,
strMetaTittleEn,
strMetaDescriptionEn,
strArticleTitleEn,
strDescriptionEn,
strContentEn,
strTagEn,
strArticleCategoryID,
strIsShowOnHomePage,
strIsHot,
strIsNew,
strIsAvailable,
strTitle,
strTitle2,
strPriority
);
strArticleID = oArticle.ArticleID;
string strFullPath = "~/res/article/" + strImageName;
if (!string.IsNullOrEmpty(strImageName))
{
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
//ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
ResizeCropImage.CreateThumbNailByCondition("~/res/article/", "~/res/article/thumbs/", strImageName, 120, 120);
}
strIconName = (string.IsNullOrEmpty(strConvertedArticleTitle) ? "" : strConvertedArticleTitle + "-") + strArticleID + strIconName.Substring(strIconName.LastIndexOf('.'));
string strFullPathIcon = "~/res/article/icon/" + strIconName;
if (!string.IsNullOrEmpty(strIconName))
{
FileIconName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPathIcon));
//ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strOldImagePath = Server.MapPath("~/res/article/" + strOldImageName);
var strOldThumbImagePath = Server.MapPath("~/res/article/thumbs/" + strOldImageName);
var strOldImagePathIcon = Server.MapPath("~/res/article/icon/" + strOldIconName);
dsUpdateParam["ArticleTitle"].DefaultValue = strArticleTitle;
dsUpdateParam["ConvertedArticleTitle"].DefaultValue = strConvertedArticleTitle;
dsUpdateParam["ImageName"].DefaultValue = strImageName;
dsUpdateParam["IconName"].DefaultValue = strIconName;
dsUpdateParam["ArticleCategoryID"].DefaultValue = strArticleCategoryID;
dsUpdateParam["IsShowOnHomePage"].DefaultValue = strIsShowOnHomePage;
dsUpdateParam["IsHot"].DefaultValue = strIsHot;
dsUpdateParam["IsNew"].DefaultValue = strIsNew;
dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable;
if (!string.IsNullOrEmpty(strImageName))
{
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
if (File.Exists(strOldThumbImagePath))
{
File.Delete(strOldThumbImagePath);
}
strImageName = (string.IsNullOrEmpty(strConvertedArticleTitle) ? "" : strConvertedArticleTitle + "-") + strArticleID + strImageName.Substring(strImageName.LastIndexOf('.'));
string strFullPath = "~/res/article/" + strImageName;
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
//ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
ResizeCropImage.CreateThumbNailByCondition("~/res/article/", "~/res/article/thumbs/", strImageName, 120, 120);
}
if (!string.IsNullOrEmpty(strIconName))
{
if (File.Exists(strOldImagePathIcon))
{
File.Delete(strOldImagePathIcon);
}
strIconName = (string.IsNullOrEmpty(strConvertedArticleTitle) ? "" : strConvertedArticleTitle + "-") + strArticleID + strIconName.Substring(strIconName.LastIndexOf('.'));
string strFullPathIcon = "~/res/article/icon/" + strIconName;
FileIconName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPathIcon));
//ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
}
}
}
if (e.CommandName == "DeleteImage")
{
var oArticle = new Article();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strArticleID = s[0];
var strImageName = s[1];
oArticle.ArticleImageDelete(strArticleID);
DeleteImage(strImageName);
RadGrid1.Rebind();
}
if (e.CommandName == "DeleteIcon")
{
var oArticle = new Article();
var lnkDeleteIcon = (LinkButton)e.CommandSource;
var s = lnkDeleteIcon.Attributes["rel"].ToString().Split('#');
var strArticleID = s[0];
var strIconName = s[1];
oArticle.ArticleIconDelete(strArticleID);
DeleteIcon(strIconName);
RadGrid1.Rebind();
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["LastName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string UserName, Role;
var oUser = new User();
foreach (GridDataItem item in RadGrid1.Items)
{
UserName = item.GetDataKeyValue("UserName").ToString();
Role = ((RadComboBox)item.FindControl("ddlRole")).SelectedValue;
oUser.ChangeRole(UserName, Role);
}
}
else if (e.CommandName == "DeleteSelected")
{
var oAddressBook1 = new AddressBook1();
var oUser = new User();
string errorList = "", UserName = "";
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
try
{
var AddressBookID = item.GetDataKeyValue("AddressBookID").ToString();
UserName = item["UserName"].Text;
oAddressBook1.AddressBook1Delete(AddressBookID);
oUser.UserDelete(UserName);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString())
{
errorList += ", " + UserName;
}
}
}
if (!string.IsNullOrEmpty(errorList))
{
e.Canceled = true;
string strAlertMessage = "Tài khoản <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang có đơn hàng .<br /> Xin xóa đơn hàng hoặc sử dụng chức năng khoá tài khoản.";
lblError.Text = strAlertMessage;
}
RadGrid1.Rebind();
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
try
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var DistrictID = ((RadComboBox)row.FindControl("ddlDistrict")).SelectedValue;
var ProvinceID = ((RadComboBox)row.FindControl("ddlProvince")).SelectedValue;
var RoleName = ((RadComboBox)row.FindControl("ddlRole")).SelectedValue;
var UserName = ((RadTextBox)row.FindControl("txtUserName")).Text;
var IsPrimary = "True";
var CountryID = "1";
var oUser = new User();
if (e.CommandName == "PerformInsert")
{
var insertParams = ObjectDataSource1.InsertParameters;
insertParams["CountryID"].DefaultValue = CountryID;
insertParams["ProvinceID"].DefaultValue = ProvinceID;
insertParams["DistrictID"].DefaultValue = DistrictID;
insertParams["RoleName"].DefaultValue = RoleName;
insertParams["IsPrimary"].DefaultValue = IsPrimary;
oUser.ChangeRole(UserName, RoleName);
}
else
{
var updateParams = ObjectDataSource1.UpdateParameters;
updateParams["CountryID"].DefaultValue = CountryID;
updateParams["ProvinceID"].DefaultValue = ProvinceID;
updateParams["DistrictID"].DefaultValue = DistrictID;
updateParams["RoleName"].DefaultValue = RoleName;
updateParams["IsPrimary"].DefaultValue = IsPrimary;
oUser.ChangeRole(UserName, RoleName);
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["ProjectTitle"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string ProjectID, Priority, IsHot, IsNew, IsShowOnHomePage, IsAvailable;
var oProject = new Project();
foreach (GridDataItem item in RadGrid1.Items)
{
ProjectID = item.GetDataKeyValue("ProjectID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsHot = ((CheckBox)item.FindControl("chkIsHot")).Checked.ToString();
IsNew = ((CheckBox)item.FindControl("chkIsNew")).Checked.ToString();
IsShowOnHomePage = ((CheckBox)item.FindControl("chkIsShowOnHomePage")).Checked.ToString();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oProject.ProjectQuickUpdate(
ProjectID,
IsHot,
IsNew,
IsShowOnHomePage,
IsAvailable,
Priority
);
}
}
else if (e.CommandName == "DeleteSelected")
{
string OldImageName;
var oProject = new Project();
string errorList = "", ProjectName = "";
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
try
{
var ProjectID = item.GetDataKeyValue("ProjectID").ToString();
ProjectName = item["ProjectTitle"].Text;
oProject.ProjectDelete(ProjectID);
OldImageName = ((HiddenField)item.FindControl("hdnImageName")).Value;
DeleteImage(OldImageName);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString())
{
errorList += ", " + ProjectName;
}
}
}
if (!string.IsNullOrEmpty(errorList))
{
e.Canceled = true;
string strAlertMessage = "Dự án <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang chứa thư viện ảnh, file download hoặc video .<br /> Xin xóa ảnh, file download hoặc video trong dự án này hoặc thiết lập hiển thị = \"không\".";
lblError.Text = strAlertMessage;
}
RadGrid1.Rebind();
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileImageName = (RadUpload)row.FindControl("FileImageName");
string ProjectID = ((HiddenField)row.FindControl("hdnProjectID")).Value;
string OldImageName = ((HiddenField)row.FindControl("hdnOldImageName")).Value;
string ImageName = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : "";
string Priority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
string MetaTittle = ((TextBox)row.FindControl("txtMetaTittle")).Text.Trim();
string MetaDescription = ((TextBox)row.FindControl("txtMetaDescription")).Text.Trim();
string ProjectTitle = ((TextBox)row.FindControl("txtProjectTitle")).Text.Trim();
string ConvertedProjectTitle = Common.ConvertTitle(ProjectTitle);
string Description = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescription")).Content.Trim()));
string Content = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContent")).Content.Trim()));
string Tag = ((TextBox)row.FindControl("txtTag")).Text.Trim();
string ProjectCategoryID = ((RadComboBox)row.FindControl("ddlProjectCategory")).SelectedValue;
if ("".Equals(ProjectCategoryID))
{
ProjectCategoryID = "4";
}
string IsHot = ((CheckBox)row.FindControl("chkIsHot")).Checked.ToString();
string IsNew = ((CheckBox)row.FindControl("chkIsNew")).Checked.ToString();
string IsShowOnHomePage = ((CheckBox)row.FindControl("chkIsShowOnHomePage")).Checked.ToString();
string IsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string MetaTittleEn = ((TextBox)row.FindControl("txtMetaTittleEn")).Text.Trim();
string MetaDescriptionEn = ((TextBox)row.FindControl("txtMetaDescriptionEn")).Text.Trim();
string ProjectTitleEn = ((TextBox)row.FindControl("txtProjectTitleEn")).Text.Trim();
string DescriptionEn = ((RadEditor)row.FindControl("txtDescriptionEn")).Content.Trim();
string ContentEn = ((RadEditor)row.FindControl("txtContentEn")).Content.Trim();
string TagEn = ((TextBox)row.FindControl("txtTagEn")).Text.Trim();
if (e.CommandName == "PerformInsert")
{
var oProject = new Project();
ImageName = oProject.ProjectInsert(
ImageName,
MetaTittle,
MetaDescription,
ProjectTitle,
ConvertedProjectTitle,
Description,
Content,
Tag,
MetaTittleEn,
MetaDescriptionEn,
ProjectTitleEn,
DescriptionEn,
ContentEn,
TagEn,
ProjectCategoryID,
IsHot,
IsNew,
IsShowOnHomePage,
IsAvailable,
Priority
);
string strFullPath = "~/res/project/" + ImageName;
if (!string.IsNullOrEmpty(ImageName))
{
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
ResizeCropImage.CreateThumbNailByCondition("~/res/project/", "~/res/project/thumbs/", ImageName, 120, 120);
}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strOldImagePath = Server.MapPath("~/res/project/" + OldImageName);
var strOldThumbImagePath = Server.MapPath("~/res/project/thumbs/" + OldImageName);
dsUpdateParam["ConvertedProjectTitle"].DefaultValue = ConvertedProjectTitle;
dsUpdateParam["ImageName"].DefaultValue = ImageName;
dsUpdateParam["ProjectCategoryID"].DefaultValue = ProjectCategoryID;
dsUpdateParam["IsHot"].DefaultValue = IsHot;
dsUpdateParam["IsNew"].DefaultValue = IsNew;
dsUpdateParam["IsShowOnHomePage"].DefaultValue = IsShowOnHomePage;
dsUpdateParam["IsAvailable"].DefaultValue = IsAvailable;
if (!string.IsNullOrEmpty(ImageName))
{
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
if (File.Exists(strOldThumbImagePath))
{
File.Delete(strOldThumbImagePath);
}
ImageName = (string.IsNullOrEmpty(ConvertedProjectTitle) ? "" : ConvertedProjectTitle + "-") + ProjectID + ImageName.Substring(ImageName.LastIndexOf('.'));
string strFullPath = "~/res/project/" + ImageName;
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
ResizeCropImage.CreateThumbNailByCondition("~/res/project/", "~/res/project/thumbs/", ImageName, 120, 120);
}
}
}
if (e.CommandName == "DeleteImage")
{
var oProject = new Project();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strProjectID = s[0];
var ImageName = s[1];
oProject.ProjectImageDelete(strProjectID);
DeleteImage(ImageName);
RadGrid1.Rebind();
}
}
private void Generate_Summary()
{
DataTable _dtoutput = new DataTable();
_dtoutput.Columns.Add("building", typeof(string));
_dtoutput.Columns.Add("tissued", typeof(string));
_dtoutput.Columns.Add("topen", typeof(string));
_dtoutput.Columns.Add("res1", typeof(string));
_dtoutput.Columns.Add("res2", typeof(string));
_dtoutput.Columns.Add("res3", typeof(string));
_dtoutput.Columns.Add("res4", typeof(string));
_dtoutput.Columns.Add("res5", typeof(string));
_dtoutput.Columns.Add("close", typeof(string));
_dtoutput.Columns.Add("open", typeof(string));
_dtoutput.Columns.Add("comment", typeof(string));
_dtoutput.Columns.Add("id", typeof(string));
var _dv = (DataView)ObjectDataSource1.Select();
DataTable _dtemp = _dv.ToTable();
BLL_Dml _objbll = new BLL_Dml();
_database _objdb = new _database();
_objdb.DBName = "DB_CCAD";
DataTable _dtbld = _objbll.Load_CX_Buildings(_objdb);
//var distinctRows = (from DataRow dRow in _dtemp.Rows
// select new { col1 = dRow["Location"] }).Distinct();
var distinctRows = from _bldg in _dtbld.AsEnumerable()
select _bldg;
foreach (var row in distinctRows)
{
//if (row.col1.ToString() != "N/A" && row.col1.ToString() != "")
//{
int _total_issued = 0;
int _total_closed = 0;
int _res1 = 0;
int _res2 = 0;
int _res3 = 0;
int _res4 = 0;
int _res5 = 0;
var _result = from _data in _dtemp.AsEnumerable()
where _data.Field <string>("Location") == row["cx_bldg_name"].ToString()
select _data;
foreach (var _row in _result)
{
_total_issued += 1;
if (_row["r_status"].ToString() == "OPEN")
{
_total_closed += 1;
if (_row["responsible"].ToString().Contains("AECOM") == true)
{
_res2 += 1;
}
else if (_row["responsible"].ToString().Contains("JCI") == true)
{
_res1 += 1;
}
else if (_row["responsible"].ToString().Contains("CML") == true)
{
_res3 += 1;
}
else if (_row["responsible"].ToString().Contains("CCAD") == true)
{
_res4 += 5;
}
else
{
_res4 += 1;
}
}
}
if (_total_issued != 0)
{
DataRow _drow = _dtoutput.NewRow();
_drow[0] = row["cx_bldg_name"].ToString();
_drow[1] = _total_issued.ToString();
_drow[2] = _total_closed.ToString();
_drow[3] = _res1.ToString();
_drow[4] = _res2.ToString();
_drow[5] = _res3.ToString();
_drow[6] = _res4.ToString();
_drow[7] = _res5.ToString();
_drow[8] = row["hi_p_closed"].ToString();
_drow[9] = row["hi_p_open"].ToString();
_drow[10] = row["comments"].ToString();
_drow[11] = row["cx_bldg_id"].ToString();
_dtoutput.Rows.Add(_drow);
}
//}
}
mygrid.DataSource = _dtoutput;
mygrid.DataBind();
}