public RMS.Common.ObjectModel.CResult AddParentCat(RMS.Common.ObjectModel.CParentCategory inUser)
{
CResult oResult = new CResult();
try
{
bool bTempFlag = CheckParentCat(inUser);
if (bTempFlag)
{
oResult.Message = "Parent category exists with this name.";
}
else
{
this.OpenConnection();
string sSql = String.Format(SqlQueries.GetQuery(Query.AddParentCategory), inUser.ParentCatName);
this.ExecuteNonQuery(sSql);
oResult.IsSuccess = true;
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemInsert() in CUserInfoDAO class", LogLevel.Error, "Database");
//throw new Exception("Exception occure at ItemInsert()", ex);
}
finally
{
this.CloseConnection();
}
return(oResult);
}
public RMS.Common.ObjectModel.CResult ParentCatDelete(RMS.Common.ObjectModel.CParentCategory oCat)
{
CResult oResult = new CResult();
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.DeleteParentCategory), oCat.ParentCatID);
this.ExecuteNonQuery(sSql);
oResult.IsSuccess = true;
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
//throw new Exception("Exception occure at ItemDelete()", ex);
oResult.IsException = true;
oResult.Message = ex.Message;
}
finally
{
this.CloseConnection();
}
return(oResult);
}
public RMS.Common.ObjectModel.CResult GetParentCategory(RMS.Common.ObjectModel.CParentCategory inCat)
{
CResult oResult = new CResult();
try
{
this.OpenConnection();
string sSql = String.Format(SqlQueries.GetQuery(Query.GetParentCatByID), inCat.ParentCatID);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
if (oReader.Read())
{
CParentCategory oCat = ReaderToParentCategory(oReader);
oResult.Data = oCat;
oResult.IsSuccess = true;
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemGetById()", LogLevel.Error, "Database");
oResult.IsException = true;
}
finally
{
this.CloseConnection();
}
return(oResult);
}
public CResult GetParentCategory(CParentCategory inCat)
{
CResult oResult = null;
try
{
//this.OpenConnection();
//string sSql = string.Format(SqlQueries.GetQuery(Query.ItemGetById), gItemId);
//IDataReader oReader = this.ExecuteReader(sSql);
//if (oReader != null)
//{
// if (oReader.Read())
// oItem = ReaderToCategory1(oReader);
//}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemGetById()", LogLevel.Error, "Database");
oResult.IsException = true;
}
finally
{
this.CloseConnection();
}
return oResult;
}
public RMS.Common.ObjectModel.CResult ParentCatUpdate(RMS.Common.ObjectModel.CParentCategory oCat)
{
CResult oResult = new CResult();
try
{
bool bTempFlag = CheckParentCatUpdate(oCat);
if (bTempFlag)
{
oResult.Message = "Parent category exists with this name.";
}
else
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.UpdateParentCategory), oCat.ParentCatName, oCat.ParentCatID);
this.ExecuteNonQuery(sSql);
oResult.IsSuccess = true;
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
throw new Exception("Exception occure at ItemDelete()", ex);
}
finally
{
this.CloseConnection();
}
return(oResult);
}
private CParentCategory ReaderToParentCategory(IDataReader inReader)
{
CParentCategory tempParentCategory = new CParentCategory();
if (inReader["parent_cat_id"] != null)
tempParentCategory.ParentCategoryID = int.Parse(inReader["parent_cat_id"].ToString());
if (inReader["parent_cat_name"] != null)
tempParentCategory.ParentCategoryName = inReader["parent_cat_name"].ToString();
return tempParentCategory;
}
private void btnSave_Click(object sender, EventArgs e)
{
CResult oValidResult = ValidateForm();
if (oValidResult.IsSuccess)
{
String sTempStr = txtParentCategoryName.Text.Trim();
if (sTempStr.Equals(String.Empty))
{
lblSaveStatus.Text = " Write the name of the category.";
lblSaveStatus.Visible = true;
}
else
{
CParentCategory oTempParent = new CParentCategory();
oTempParent.ParentCatName = sTempStr;
CCategoryManager oManager = new CCategoryManager();
CResult oResult = oManager.AddParentCat(oTempParent);
if (oResult.IsSuccess)
{
lblSaveStatus.Text = " Parent category has been added successfully.";
lblSaveStatus.Visible = true;
}
else
{
lblSaveStatus.Text = oResult.Message;
lblSaveStatus.Visible = true;
}
}
}
else
{
lblSaveStatus.Text = oValidResult.Message;
lblSaveStatus.Visible = true;
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
CResult oResult = ValidateForm();
if (oResult.IsSuccess)
{
CParentCategory objParentCat = new CParentCategory();
objParentCat.ParentCatName = txtParentCategoryName.Text.Trim();
objParentCat.ParentCatID = m_iParentCat;
CCategoryManager oManager = new CCategoryManager();
CResult oResult2 = oManager.UpdateParentCat(objParentCat);
if (oResult2.IsSuccess)
{
lblSaveStatus.Text = "Parent category information has been updated successfully. ";
lblSaveStatus.Visible = true;
}
else
{
lblSaveStatus.Text = oResult2.Message;
lblSaveStatus.Visible = true;
}
}
else
{
lblSaveStatus.Text = oResult.Message;
lblSaveStatus.Visible = true;
}
}
public CResult AddParentCat(CParentCategory inUser)
{
CResult oResult = new CResult();
try
{
bool bTempFlag = CheckParentCat(inUser);
if (bTempFlag)
{
oResult.Message = "Parent category exists with this name.";
}
else
{
this.OpenConnection();
string sSql = String.Format(SqlQueries.GetQuery(Query.AddParentCategory), inUser.ParentCatName);
this.ExecuteNonQuery(sSql);
oResult.IsSuccess = true;
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemInsert() in CUserInfoDAO class", LogLevel.Error, "Database");
//throw new Exception("Exception occure at ItemInsert()", ex);
}
finally
{
this.CloseConnection();
}
return oResult;
}
private void LoadParentCategory()
{
List<CParentCategory> tempParentCategoryList = new List<CParentCategory>();
CParentCategoryDAO aCParentCategoryDao=new CParentCategoryDAO();
tempParentCategoryList = aCParentCategoryDao.GetAllParentCategory();
CParentCategory aCategory=new CParentCategory();
aCategory.ParentCategoryName = "ALL";
aCategory.ParentCategoryID = 0;
tempParentCategoryList.Add(aCategory);
cmbparentcategory.DataSource = tempParentCategoryList;
cmbparentcategory.DisplayMember = "ParentCategoryName";
cmbparentcategory.ValueMember = "ParentCategoryID";
}
private void btnSave_Click(object sender, EventArgs e)
{
//To Get parent catagory Order Number
String queryStr = SqlQueries.GetQuery(Query.GetMaxParentCategoryNumber);
CDalConfig oTempDal = ConfigManager.GetConfig<CDalConfig>();
String tempConnStr = oTempDal.ConnectionString;
// Create a new data adapter based on the specified query.
SqlDataAdapter dataAdapter = new SqlDataAdapter(queryStr, tempConnStr);
// Populate a new data table and bind it to the BindingSource.
DataTable table = new DataTable();
//table.Locale = System.Globalization.CultureInfo.InvariantCulture;
dataAdapter.Fill(table);
int lastMaxParentValue = Convert.ToInt32(table.Rows[0]["Column1"].ToString());
CResult oValidResult = ValidateForm();
if (oValidResult.IsSuccess)
{
String sTempStr = txtParentCategoryName.Text.Trim();
if (sTempStr.Equals(String.Empty))
{
lblSaveStatus.Text = " Write the name of the category.";
lblSaveStatus.Visible = true;
}
else
{
CParentCategory oTempParent = new CParentCategory();
oTempParent.ParentCatName = sTempStr;
oTempParent.ParentCatID = lastMaxParentValue+1;
CCategoryManager oManager = new CCategoryManager();
CResult oResult = oManager.AddParentCat(oTempParent);
if (oResult.IsSuccess)
{
lblSaveStatus.Text = " Parent category has been added successfully.";
lblSaveStatus.Visible = true;
}
else
{
lblSaveStatus.Text = oResult.Message;
lblSaveStatus.Visible = true;
}
}
}
else
{
lblSaveStatus.Text = oValidResult.Message;
lblSaveStatus.Visible = true;
}
}
public CResult UpdateParentCat(CParentCategory inUser)
{
try
{
m_oResult = RMS.DataAccess.Database.Instance.ParentCat.ParentCatUpdate(inUser);
}
catch (Exception ex)
{
System.Console.WriteLine("Exception occuer at DeleteItem() : " + ex.Message);
m_oResult.IsException = true;
m_oResult.Action = EERRORNAME.EXCEPTION_OCCURE;
m_oResult.SetParams(ex.Message);
m_oResult.Message = ex.Message;
Logger.Write("Exception : " + ex + " in DeleteItem()", LogLevel.Error, "CItemManager");
}
return m_oResult;
}
public CResult ParentCatDelete(CParentCategory oCat)
{
CResult oResult = new CResult();
try
{
this.OpenConnection();
string sSql = string.Format(SqlQueries.GetQuery(Query.DeleteParentCategory), oCat.ParentCatID);
this.ExecuteNonQuery(sSql);
oResult.IsSuccess = true;
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
throw new Exception("Exception occure at ItemDelete()", ex);
}
finally
{
this.CloseConnection();
}
return oResult;
}
public void ParentCategoryInsert(CParentCategory inParentCategory)
{
}
private CParentCategory ReaderToParentCategory(IDataReader oReader)
{
CParentCategory oItem = new CParentCategory();
if (oReader["parent_cat_id"] != null)
oItem.ParentCatID = Int32.Parse(oReader["parent_cat_id"].ToString());
if (oReader["parent_cat_name"] != null)
oItem.ParentCatName = oReader["parent_cat_name"].ToString();
if (oReader["parent_cat_order"] != null)
oItem.Order = Int32.Parse(oReader["parent_cat_order"].ToString());
return oItem;
}
private bool CheckParentCat(CParentCategory inUser)
{
CResult oResult = new CResult();
try
{
this.OpenConnection();
string sSql = String.Format(SqlQueries.GetQuery(Query.CheckDupParentCat), inUser.ParentCatName);
IDataReader oReader = this.ExecuteReader(sSql);
if (oReader != null)
{
if (oReader.Read())
{
if (oReader["parent_cat_id"] != null)
{
int iTemp = Int32.Parse(oReader["parent_cat_id"].ToString());
return true;
}
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemInsert() in CUserInfoDAO class", LogLevel.Error, "Database");
//throw new Exception("Exception occure at ItemInsert()", ex);
}
finally
{
this.CloseConnection();
}
return false;
}
private void dgvParentCategory_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
try
{
if (e.ColumnIndex == 2)
{
Int32 parentCatId = Convert.ToInt32("0"+dgvParentCategory.Rows[e.RowIndex].Cells[0].Value);
string parentCatName=Convert.ToString(dgvParentCategory.Rows[e.RowIndex].Cells[1].Value);
UpdateParentCtl objUpdate = new UpdateParentCtl(parentCatId, parentCatName);
objUpdate.Parent = this.ParentForm;
UserControlManager.UserControls.Push(this);
Panel pnl =(Panel)this.ParentForm.Controls["pnlContext"];
string s = pnl.Name;
objUpdate.ParentForm.Controls[s].Controls.Clear();
objUpdate.ParentForm.Controls[s].Controls.Add(objUpdate);
}
else if (e.ColumnIndex == 3)
{
if (MessageBox.Show("Are you sure you want to delete the selected parent category?", RMSGlobal.MessageBoxTitle, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int parentCatId=0;
bool bTempBool = Int32.TryParse(dgvParentCategory.Rows[e.RowIndex].Cells[0].Value.ToString(), out parentCatId);
if (bTempBool)
{
CParentCategory oCat = new CParentCategory();
oCat.ParentCatID = parentCatId;
CCategoryManager oManager = new CCategoryManager();
CResult oResult = oManager.DeleteParentCat(oCat);
if (oResult.IsSuccess)
{
dgvParentCategory.Rows.RemoveAt(e.RowIndex);
}
}
}
}
}
catch (Exception exp)
{
throw exp;
}
}
public void ParentCategoryDelete(CParentCategory inParentCategory)
{
}
public void ParentCategoryUpdate(CParentCategory inParentCategory)
{
}
