public int InsertUpdate_Data(tbl_CasteProp Objtbl_CasteProp)
{
int _RetVal = 0;
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "InsertUpdate_tbl_Caste";
cmdToExecute.CommandType = CommandType.StoredProcedure;
// Use base class' connection object
cmdToExecute.Connection = objdb.objConnection;
try
{
objdb.GetConnStr();
cmdToExecute.Parameters.Add(new SqlParameter("@CasteCode", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_CasteProp.CasteCode));
cmdToExecute.Parameters.Add(new SqlParameter("@Caste", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Objtbl_CasteProp.Caste));
cmdToExecute.Parameters.Add(new SqlParameter("@RetVal", SqlDbType.Int, 18, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, _RetVal));
cmdToExecute.ExecuteNonQuery();
string ErrorCode = cmdToExecute.Parameters["@RetVal"].Value.ToString();
_RetVal = Convert.ToInt32(ErrorCode);
return(_RetVal);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objdb.CloseConnection();;
}
}
public int Delete_Data(tbl_CasteProp Objtbl_CasteProp)
{
try
{
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Delete_tbl_Caste");
//DB.AddInParameter(DBCmd, "@CasteCode", DbType.Int32, Objtbl_CasteProp.CasteCode);
//return DB.ExecuteNonQuery(DBCmd);
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet SelectCombo_Data(tbl_CasteProp Objtbl_CasteProp)
{
try
{
DataSet dsData = objdb.ExecuteDataset("SelectCombo_tbl_Caste", "");
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("SelectCombo_tbl_Caste");
//DB.AddInParameter(DBCmd, "@SearchText", DbType.String, Objtbl_CasteProp.Caste);
//return DB.ExecuteDataSet(DBCmd);
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Search_Data(tbl_CasteProp Objtbl_CasteProp)
{
try
{
//DataSet dsData = objdb.ExecuteDataset("Search_tbl_Caste", CasteCode, 1, 50, 0);
//Database DB = DatabaseFactory.CreateDatabase("AppConAnant");
//DbCommand DBCmd = DB.GetStoredProcCommand("Search_tbl_Caste");
//DB.AddInParameter(DBCmd, "@SearchBy", DbType.String, Objtbl_CasteProp.SearchBy);
//DB.AddInParameter(DBCmd, "@SearchVal", DbType.String, Objtbl_CasteProp.SearchVal);
//return DB.ExecuteDataSet(DBCmd);
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
private void GetCaste()
{
try
{
tbl_CasteProp objCaste = new tbl_CasteProp();
tbl_CasteBAL objBal = new tbl_CasteBAL();
DataSet ds = objBal.SelectCombo_Data(objCaste);
cmbCaste.DataSource = ds.Tables[0];
cmbCaste.DisplayMember = "Caste";
cmbCaste.ValueMember = "CasteCode";
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex.Message));
this.objEventLoging.AppErrlog("Error In AnantMatrimony.GetCaste.funSave() " + ex.ToString());
}
}
public DataSet Select_Data(tbl_CasteProp Objtbl_CasteProp, ref int TotalCount, int CasteCode)
{
try
{
DataSet dsData = objdb.ExecuteDataset("Select_tbl_Caste", CasteCode, 1, 50, 0);
//DbCommand DBCmd = DB.GetStoredProcCommand("Select_tbl_Caste");
//DB.AddInParameter(DBCmd, "@CasteCode", DbType.Int32, Objtbl_CasteProp.CasteCode);
//DB.AddInParameter(DBCmd, "@PageNo", DbType.Int32, Objtbl_CasteProp.PageNo);
//DB.AddInParameter(DBCmd, "@RecordCount", DbType.Int32, Objtbl_CasteProp.RecordCount);
//DB.AddOutParameter(DBCmd, "@TotalCount", DbType.Int32, 18);
//DataSet dsData = DB.ExecuteDataSet(DBCmd);
//TotalCount = Convert.ToInt32(DBCmd.Parameters["@TotalCount"].Value);
TotalCount = 100;
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetSaveList()
{
DataSet ds = new DataSet();
try
{
if (lblFrmName.Text == Global.fAnnualIncome)
{
tbl_AnnualIncomeBAL objbal = new tbl_AnnualIncomeBAL();
tbl_AnnualIncomeProp objtbl_tbl_AnnualIncome = new tbl_AnnualIncomeProp();
int PageCount = 0;
ds = objbal.Select_Data(objtbl_tbl_AnnualIncome, ref PageCount, 0);
}
else if (lblFrmName.Text == Global.fAnnualIncomeCurrency)
{
tbl_AnnualIncomeCurrencyBAL objbal = new tbl_AnnualIncomeCurrencyBAL();
tbl_AnnualIncomeCurrencyProp objtbl_tbl_AnnualIncome = new tbl_AnnualIncomeCurrencyProp();
int PageCount = 0;
ds = objbal.Select_Data(objtbl_tbl_AnnualIncome, ref PageCount, 0);
}
else if (lblFrmName.Text == Global.fBloodGroup)
{
tbl_BloodGroupBAL objbal = new tbl_BloodGroupBAL();
tbl_BloodGroupProp objtbl_prop = new tbl_BloodGroupProp();
int PageCount = 0;
ds = objbal.Select_Data(objtbl_prop, ref PageCount, 0);
}
else if (lblFrmName.Text == Global.fCaste)
{
tbl_CasteBAL objbal = new tbl_CasteBAL();
tbl_CasteProp objtbl_prop = new tbl_CasteProp();
int PageCount = 0;
ds = objbal.Select_Data(objtbl_prop, 0, ref PageCount);
}
else if (lblFrmName.Text == Global.fCountry)
{
tbl_CountryBAL objbal = new tbl_CountryBAL();
tbl_CountryProp objtbl_prop = new tbl_CountryProp();
int PageCount = 0;
ds = objbal.Select_Data(objtbl_prop, ref PageCount, 0);
}
else if (lblFrmName.Text == Global.fEducation)
{
tbl_EducationBAL objbal = new tbl_EducationBAL();
tbl_EducationProp objtbl_prop = new tbl_EducationProp();
int PageCount = 0;
ds = objbal.Select_Data(objtbl_prop, ref PageCount, 0);
}
else if (lblFrmName.Text == Global.fMembershipType)
{
tbl_MembershipTypeBAL objbal = new tbl_MembershipTypeBAL();
tbl_MembershipTypeProp objtbl_prop = new tbl_MembershipTypeProp();
int PageCount = 0;
ds = objbal.Select_Data(objtbl_prop, ref PageCount, 0);
}
else if (lblFrmName.Text == Global.fOccupation)
{
tbl_OccupationBAL objbal = new tbl_OccupationBAL();
tbl_OccupationProp objtbl_prop = new tbl_OccupationProp();
int PageCount = 0;
ds = objbal.Select_Data(objtbl_prop, ref PageCount, 0);
}
else if (lblFrmName.Text == Global.fProfileCreatedBy)
{
tbl_ProfileCreatedByBAL objbal = new tbl_ProfileCreatedByBAL();
tbl_ProfileCreatedByProp objtbl_prop = new tbl_ProfileCreatedByProp();
int PageCount = 0;
ds = objbal.Select_Data(objtbl_prop, ref PageCount, 0);
}
else if (lblFrmName.Text == Global.fVisaStatus)
{
tbl_VisaStatusBAL objbal = new tbl_VisaStatusBAL();
tbl_VisaStatusProp objtbl_prop = new tbl_VisaStatusProp();
int PageCount = 0;
ds = objbal.Select_Data(objtbl_prop, ref PageCount, 0);
}
else if (lblFrmName.Text == Global.fWorkingAs)
{
tbl_WorkingAsBAL objbal = new tbl_WorkingAsBAL();
tbl_WorkingAsProp objtbl_prop = new tbl_WorkingAsProp();
int PageCount = 0;
ds = objbal.Select_Data(objtbl_prop, ref PageCount, 0);
}
else if (lblFrmName.Text == Global.fWorkingWith)
{
tbl_WorkingWithBAL objbal = new tbl_WorkingWithBAL();
tbl_WorkingWithProp objtbl_prop = new tbl_WorkingWithProp();
int PageCount = 0;
ds = objbal.Select_Data(objtbl_prop, ref PageCount, 0);
}
else if (lblFrmName.Text == Global.fMaritalStatus)
{
//tbl_WorkingWithBAL objbal = new tbl_WorkingWithBAL();
//tbl_WorkingWithProp objtbl_prop = new tbl_WorkingWithProp();
//int PageCount = 0;
//ds = objbal.Select_Data(objtbl_prop, ref PageCount, 0);
}
else if (lblFrmName.Text == Global.fWorkType)
{
//tbl_WorkingWithBAL objbal = new tbl_WorkingWithBAL();
//tbl_WorkingWithProp objtbl_prop = new tbl_WorkingWithProp();
//int PageCount = 0;
//ds = objbal.Select_Data(objtbl_prop, ref PageCount, 0);
strSQL = "Select * from tbl_WorkType";
ds = objDb.ExecuteDataset(strSQL);
}
else if (lblFrmName.Text == Global.fEmployeeMaster)
{
strSQL = "Select * from tbl_EmployeeMaster";
ds = objDb.ExecuteDataset(strSQL);
}
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex.Message));
this.objEventLoging.AppErrlog("Error In AnantMatrimony.frmCommonMaster.GetSaveList() " + ex.ToString());
}
return(ds);
}
