public object GetAllModelNameForSearch(string modelName, string brandID)
{
long brID = 0;
List <GetModelNameForSearchResult> list = null;
try
{
if (!brandID.IsNullOrWhiteSpace())
{
brID = Convert.ToInt64(brandID);
}
list = new ModelRT().GetModelNameForSearch(modelName, brID);
var modelList = from mod in list
select new { mod.IID, mod.Name };
return(modelList);
}
catch (Exception ex)
{
}
finally
{
if (list != null && list.Count > 0)
{
list = list.Take(25).ToList();
}
}
return(null);
}
protected void lvModel_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "EditModel")
{
try
{
labelMessage.Text = string.Empty;
btnSave.Visible = false;
btnUpdate.Visible = true;
btnDelete.Visible = true;
btnCancel.Visible = true;
int modelID = Convert.ToInt32(e.CommandArgument);
hdModelID.Value = modelID.ToString();
using (ModelRT receiverTransfer = new ModelRT())
{
Model model = receiverTransfer.GetModelByID(modelID);
FillModelForEdit(model);
}
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
labelMessage.Text = string.Empty;
using (ModelRT receiverTransfer = new ModelRT())
{
hdIsDelete.Value = "true";
hdIsEdit.Value = "true";
Model model = CreateModel();
if (model != null)
{
receiverTransfer.UpdateModel(model);
labelMessage.Text = "Data successfully deleted...";
labelMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
labelMessage.Text = "Data not deleted...";
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
LoadModelListView();
SetButton();
ClearField();
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
private void LoadModelListView()
{
try
{
using (ModelRT receiverTransfer = new ModelRT())
{
lvModel.DataSource = receiverTransfer.GetAllModelForListView();
lvModel.DataBind();
}
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
labelMessage.Text = string.Empty;
using (ModelRT receiverTransfer = new ModelRT())
{
hdIsEdit.Value = "true";
Model model = CreateModel();
if (model != null)
{
if (receiverTransfer.IsModelNameExistInOterRows(model.IID, model.Name, model.BrandID))
{
labelMessage.Text = "Model Name " + txtModelName.Text + " Already Exist !";
labelMessage.ForeColor = System.Drawing.Color.Red;
return;
}
receiverTransfer.UpdateModel(model);
labelMessage.Text = "Data successfully updated...";
labelMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
labelMessage.Text = "Data not updated...";
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
ClearField();
SetButton();
LoadModelListView();
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
labelMessage.Text = string.Empty;
using (ModelRT receiverTransfer = new ModelRT())
{
int brandID = int.Parse(txtBrandID.Text);
if (receiverTransfer.IsModelNameExists(txtModelName.Text, brandID))
{
labelMessage.Text = "Model Name " + txtModelName.Text + " Already Exists !";
labelMessage.ForeColor = System.Drawing.Color.Red;
return;
}
Model model = CreateModel();
receiverTransfer.AddModel(model);
if (model.IID > 0)
{
labelMessage.Text = "Data successfully saved...";
labelMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
labelMessage.Text = "Data not saved...";
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
ClearField();
LoadModelListView();
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
private void FillMaterialFormForEdit(Int64 materialIID)
{
try
{
using (MaterialRT rt = new MaterialRT())
{
hdMaterialID.Value = materialIID.ToString();
Material material = rt.GetMaterialByIID(materialIID);
if (material == null)
{
Response.Redirect("~/ManageYourAds.aspx");
}
if (!(material.BrandID == 0 || material.BrandID == null))
{
txtBrandID.Text = material.BrandID.ToString();
using (BrandRT brandRt = new BrandRT())
{
txtBrand.Text = brandRt.GetBrandByID((long)material.BrandID).Name;
}
}
if (!(material.ModelID != 0 || material.ModelID != null))
{
using (ModelRT aModelRt = new ModelRT())
{
txtModel.Text = aModelRt.GetModelByID((int)material.ModelID).Name;
}
}
if (!(material.ColorID != 0 || material.ColorID != null))
{
using (ColorRT aColorRt = new ColorRT())
{
txtModel.Text = aColorRt.GetColorByID((int)material.ColorID).Name;
}
}
using (AdGiverRT adGiverRt = new AdGiverRT())
{
txtUserID.Text = material.AdGiverID != 0 ? adGiverRt.GetAdGiverByIID((long)material.AdGiverID).EmailID : string.Empty;
}
txtTitleName.Text = material.TitleName;
txtPrice.Text = material.Price.ToString();
txtDescription.Text = material.Description;
txtCode.Text = material.Code;
txtWeburl.Text = material.WebSiteUrl;
txtYoutubeUrl.Text = material.YoutubeUrl;
txtPhoneNumber.Text = material.UserPhoneNumber;
chkNegotiable.Checked = material.IsNegotiablePrice;
dropDownCategory.SelectedValue = material.CategoryID.ToString();
using (LocationRT aLocationRt = new LocationRT())
{
txtLocationID.Text = material.LocationID.ToString();
long districtID = 0, policeStationID = 0;
string districtName = string.Empty, polStationName = string.Empty, locationName = string.Empty;
bool isReceiveInfo = aLocationRt.GetLocationInfoByIID(material.LocationID, ref districtID, ref districtName, ref policeStationID, ref polStationName, ref locationName);
if (isReceiveInfo)
{
txtDistrictID.Text = districtID.ToString();
txtDistrict.Text = districtName.ToString();
txtPoliceStationID.Text = policeStationID.ToString();
txtPoliceStation.Text = polStationName.ToString();
txtLocation.Text = locationName.ToString();
}
}
DateTime addDate = material.AdDate;
DateTime adDisplayLastDate = (DateTime)(material.AdDisplayLastDate ?? material.AdDate);
int adDisplayTotalDate = (int)(adDisplayLastDate - addDate).TotalDays;
txtPostVisibilityDay.Text = adDisplayTotalDate.ToString();
List <ControlAdmin.MaterialWF.ImageUrl> matPicTempFileUrlList = new List <ControlAdmin.MaterialWF.ImageUrl>();
using (PictureRT aPictureRt = new PictureRT())
{
List <Picture> picList = new List <Picture>();
picList = aPictureRt.GetPictureByMaterialIID(Convert.ToInt64(materialIID));
if (picList.Count > 0)
{
foreach (var picture in picList)
{
ControlAdmin.MaterialWF.ImageUrl aImageUrl = new ControlAdmin.MaterialWF.ImageUrl();
aImageUrl.ImageUrlTemp = picture.UrlAddress;
matPicTempFileUrlList.Add(aImageUrl);
}
}
}
Session["seMatPicTempFileName"] = matPicTempFileUrlList;
datalistMatPic.DataSource = matPicTempFileUrlList;
datalistMatPic.DataBind();
Session[sessMaterial] = material;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
