public bool SaveTdsCategory(TdsModel objtdsmod)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Name", objtdsmod.TdsCategoryName));
paramCollection.Add(new DBParameter("@Selectcode", objtdsmod.Selectcode));
Query = Query = "INSERT INTO TbdsCategory (`Name`,`Selectcode`) " +
"VALUES (@Name,@Selectcode)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
private void FillAccountInfo()
{
TdsModel objTds = objtdsmodbl.GetListofTDSById(TdsId);
tbxTdsName.Text = objTds.TdsCategoryName;
tbxSelectcode.Text = objTds.Selectcode;
}
//Update Tds category
public bool UpdateTdsModel(TdsModel objtds)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@TdsCategoryName", objtds.TdsCategoryName));
paramCollection.Add(new DBParameter("@SelectCode", objtds.Selectcode));
paramCollection.Add(new DBParameter("@Tds_ID", objtds.Tds_Id));
Query = "UPDATE tdscategory SET TdsCategoryName=@TdsCategoryName,SelectCode=@SelectCode " +
"WHERE Tds_ID=@Tds_ID";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
private void btnSave_Click(object sender, EventArgs e)
{
TdsModel objtds = new TdsModel();
objtds.TdsCategoryName = tbxTdsName.Text.Trim();
objtds.Selectcode = tbxSelectcode.Text.Trim();
bool isSuccess = objtdsmodbl.SaveTdsModel(objtds);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
}
}
//Get List Of Details By Id
public TdsModel GetListofTDSById(int id)
{
TdsModel objTds = new TdsModel();
string Query = "SELECT * FROM `tdscategory` WHERE Tds_Id=" + id + "";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objTds.Tds_Id = Convert.ToInt32(dr["Tds_Id"]);
objTds.TdsCategoryName = dr["TdsCategoryName"].ToString();
objTds.Selectcode = dr["SelectCode"].ToString();
}
return(objTds);
}
public List <TdsModel> GetListofTDS()
{
List <TdsModel> lstTdsCategory = new List <TdsModel>();
TdsModel objTds;
string Query = "SELECT * FROM `tdscategory`";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objTds = new TdsModel();
objTds.Tds_Id = Convert.ToInt32(dr["Tds_Id"]);
objTds.TdsCategoryName = dr["TdsCategoryName"].ToString();
objTds.Selectcode = dr["SelectCode"].ToString();
lstTdsCategory.Add(objTds);
}
return(lstTdsCategory);
}
