protected void lvMapCategoryList_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "EditMappinCategoryList")
{
try
{
// ClearField();
btnSave.Visible = false;
btnUpdate.Visible = true;
btnDelete.Visible = true;
int mappingCategoryID = Convert.ToInt32(e.CommandArgument);
hdMappingCategoryID.Value = mappingCategoryID.ToString();
using (MappingCategoryRT receiverTransfer = new MappingCategoryRT())
{
MappingCategory mappingCategory = receiverTransfer.GetMappingCategoryByID(mappingCategoryID);
FillMappingCategoryForEdit(mappingCategory);
}
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
hdIsEdit.Value = "true";
using (MappingCategoryRT receiverTransfer = new MappingCategoryRT())
{
List <MappingCategory> mappingCategoryList = new List <MappingCategory>();
MappingCategory mappingCategory = new MappingCategory();
if (!string.IsNullOrEmpty(txtParentID.Text))
{
mappingCategoryList = receiverTransfer.GetMappingCategoryByTableID(Convert.ToInt32(txtParentID.Text));
if (mappingCategoryList != null && mappingCategoryList.Count > 0)
{
foreach (MappingCategory mappCategory in mappingCategoryList)
{
mappCategory.IsRemoved = true;
receiverTransfer.UpdateMappingCategory(mappCategory);
}
}
for (int rowCounter = 0; rowCounter < lvMappingCategory.Items.Count(); rowCounter++)
{
CheckBox checkBox = (CheckBox)lvMappingCategory.Items[rowCounter].FindControl("chkModel");
Label lblMappingTableIID = (Label)lvMappingCategory.Items[rowCounter].FindControl("lblMappingTableIID");
if (checkBox.Checked)
{
mappingCategory = CreateMappingCategory(Convert.ToInt32(txtParentID.Text), Convert.ToInt32(lblMappingTableIID.Text));
receiverTransfer.AddMappingCategory(mappingCategory);
}
}
labelMessage.Text = "Data successfully Updated...";
labelMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
labelMessage.Text = "Data not Updated...";
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
ClearField();
LoadMappingCategoryList();
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
private void LoadMappingCategoryList()
{
try
{
using (MappingCategoryRT receiverTransfer = new MappingCategoryRT())
{
lvMapCategoryList.DataSource = receiverTransfer.GetAllMappingCategoryTableForListView();;
lvMapCategoryList.DataBind();
}
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
protected void btnCategoryID_Click(object sender, EventArgs e)
{
try
{
long categoryID = Convert.ToInt64(txtCategoryID.Text);
using (MappingCategoryRT rt = new MappingCategoryRT())
{
var mapCat = rt.GetCategoryMapByCategoryID(categoryID);
bool isColorExist = false;
bool isBrandExist = false;
bool isModelExist = false;
foreach (var map in mapCat)
{
switch (map.MapName)
{
case "Brand":
isBrandExist = true;
break;
case "Color":
isColorExist = true;
break;
case "Model":
isModelExist = true;
break;
}
}
divColor.Visible = isColorExist;
divModel.Visible = isModelExist;
divBrand.Visible = isBrandExist;
}
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
using (MappingCategoryRT receiverTransfer = new MappingCategoryRT())
{
hdIsDelete.Value = "true";
hdIsEdit.Value = "true";
if (!string.IsNullOrEmpty(txtParentID.Text))
{
List <MappingCategory> mappingCategoryList = new List <MappingCategory>();
mappingCategoryList = receiverTransfer.GetMappingCategoryByTableID(Convert.ToInt32(txtParentID.Text));
if (mappingCategoryList != null && mappingCategoryList.Count > 0)
{
foreach (MappingCategory mappCategory in mappingCategoryList)
{
mappCategory.IsRemoved = true;
receiverTransfer.UpdateMappingCategory(mappCategory);
}
labelMessage.Text = "Data successfully deleted...";
labelMessage.ForeColor = System.Drawing.Color.Green;
}
}
else
{
labelMessage.Text = "Data not deleted...";
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
LoadMappingCategoryList();
ClearField();
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
MappingCategory mappingCategory = new MappingCategory();
using (MappingCategoryRT receiverTransfer = new MappingCategoryRT())
{
List <MappingCategory> mappingCategoryList = new List <MappingCategory>();
for (int rowCounter = 0; rowCounter < lvMappingCategory.Items.Count(); rowCounter++)
{
CheckBox checkBox = (CheckBox)lvMappingCategory.Items[rowCounter].FindControl("chkModel");
Label lblMappingTableIID = (Label)lvMappingCategory.Items[rowCounter].FindControl("lblMappingTableIID");
if (checkBox.Checked)
{
mappingCategory = CreateMappingCategory(Convert.ToInt32(txtParentID.Text), Convert.ToInt32(lblMappingTableIID.Text));
receiverTransfer.AddMappingCategory(mappingCategory);
}
}
if (mappingCategory.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();
LoadMappingCategoryList();
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
private void FillMappingCategoryForEdit(MappingCategory mappingCategory)
{
try
{
MappingCategoryRT receiverTransfer = new MappingCategoryRT();
if (mappingCategory != null)
{
txtParentID.Text = Convert.ToString(mappingCategory.CategoryID);
string catName = receiverTransfer.GetMappingCategoryByName(Convert.ToInt32(mappingCategory.CategoryID));
txtCategoryID.Text = Convert.ToString(catName);
List <MappingCategory> mappingCategoryList = new List <MappingCategory>();
mappingCategoryList = receiverTransfer.GetMappingCategoryByTableID(Convert.ToInt32(mappingCategory.CategoryID));
if (mappingCategoryList != null && mappingCategoryList.Count > 0)
{
foreach (MappingCategory mappCategory in mappingCategoryList)
{
for (int rowCounter = 0; rowCounter < lvMappingCategory.Items.Count(); rowCounter++)
{
CheckBox checkBox = (CheckBox)lvMappingCategory.Items[rowCounter].FindControl("chkModel");
Label lblMappingTableIID = (Label)lvMappingCategory.Items[rowCounter].FindControl("lblMappingTableIID");
if (Convert.ToInt32(lblMappingTableIID.Text) == mappCategory.MappingTableID)
{
checkBox.Checked = true;
}
}
}
}
Session[sessMappingCategory] = mappingCategory;
}
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
