public DataTable FillDataTable(string _procedureName, string _HKey, string _JKey, string _KKey, string _LKey, string _MKey, string _NKey)
{
strErrMsg = "";
try
{
CDataAccess objDataAccessHelper = new CDataAccess();
SqlParameter[] objBuyerParameter = new SqlParameter[6];
objBuyerParameter[0] = new SqlParameter("@pHKey", SqlDbType.VarChar, 20);
objBuyerParameter[1] = new SqlParameter("@pJKey", SqlDbType.VarChar, 20);
objBuyerParameter[2] = new SqlParameter("@pKKey", SqlDbType.VarChar, 20);
objBuyerParameter[3] = new SqlParameter("@pLKey", SqlDbType.VarChar, 20);
objBuyerParameter[4] = new SqlParameter("@pMKey", SqlDbType.VarChar, 20);
objBuyerParameter[5] = new SqlParameter("@pMKey", SqlDbType.VarChar, 20);
objBuyerParameter[0].Value = _HKey;
objBuyerParameter[1].Value = _JKey;
objBuyerParameter[2].Value = _KKey;
objBuyerParameter[3].Value = _LKey;
objBuyerParameter[4].Value = _MKey;
objBuyerParameter[5].Value = _NKey;
return(objDataAccessHelper.GetDataTable(_procedureName, objBuyerParameter));
}
catch (Exception Ex)
{
strErrMsg = Ex.Message;
return(null);
}
}
public string saveRegistrationDetails()
{
string _result;
try
{
SqlParameter[] objParameter = new SqlParameter[6];
objParameter[0] = new SqlParameter("@pName", SqlDbType.VarChar, 50); objParameter[0].Value = Name;
objParameter[1] = new SqlParameter("@pMobileNo", SqlDbType.VarChar, 50); objParameter[1].Value = MobileNo;
objParameter[2] = new SqlParameter("@pEmail", SqlDbType.VarChar, 50); objParameter[2].Value = Email;
objParameter[3] = new SqlParameter("@pPassword", SqlDbType.VarChar, 50); objParameter[3].Value = Password;
objParameter[4] = new SqlParameter("@pMode", SqlDbType.VarChar, 50); objParameter[4].Value = Mode;
objParameter[5] = new SqlParameter("@pvcOut", SqlDbType.VarChar, 50); objParameter[5].Direction = ParameterDirection.Output;
CDataAccess.ExecuteNonQuery(CommandType.StoredProcedure, "Add_RegistrationDetails", objParameter);
_result = objParameter[5].Value.ToString();
return(_result);
}
catch (Exception ex)
{
return(_result = ex.Message.ToString());
}
}
/// <summary>
/// Deepak Balhara:17-07-2016
/// </summary>
/// <param name="xDDL"></param>
/// <param name="xCommandName"></param>
/// <param name="xCommandType"></param>
/// <returns></returns>
public bool FillDDL(DropDownList xDDL, string xCommandName, CommandType xCommandType)
{
strErrMsg = "";
try
{
CDataAccess objDataAccessHelper = new CDataAccess();
DataTable xDt = objDataAccessHelper.GetDataTable(xCommandName, xCommandType);
objDataAccessHelper = null;
xDDL.DataSource = xDt;
xDDL.DataMember = xDt.TableName;
xDDL.DataTextField = xDt.Columns[0].ColumnName;
if (xDt.Columns.Count > 1)
{
xDDL.DataTextField = xDt.Columns[0].ColumnName;
xDDL.DataValueField = xDt.Columns[1].ColumnName;
}
else
{
xDDL.DataValueField = xDt.Columns[0].ColumnName;
}
xDDL.DataBind();
xDDL.Items.Insert(0, new ListItem("Choose", null));
return(true);
}
catch (Exception ex)
{
strErrMsg = ex.Message;
return(false);
}
}
/// <summary>
/// Deepak Balhara:06-08-2016
/// Fill Data Table with Parameter
/// </summary>
/// <param name="_procedureName"></param>
/// <param name="_ClassKey"></param>
/// <param name="_SectionKey"></param>
/// <returns></returns>
public DataTable FillDataTable(string _procedureName, string _FKey, string _GKey, string _HKey, string _IKey)
{
strErrMsg = "";
try
{
CDataAccess objDataAccessHelper = new CDataAccess();
SqlParameter[] objBuyerParameter = new SqlParameter[4];
objBuyerParameter[0] = new SqlParameter("@pFKey", SqlDbType.NVarChar, 20);
objBuyerParameter[1] = new SqlParameter("@pGKey", SqlDbType.NVarChar, 20);
objBuyerParameter[2] = new SqlParameter("@pHKey", SqlDbType.NVarChar, 20);
objBuyerParameter[3] = new SqlParameter("@pIKey", SqlDbType.NVarChar, 20);
objBuyerParameter[0].Value = _FKey;
objBuyerParameter[1].Value = _GKey;
objBuyerParameter[2].Value = _HKey;
objBuyerParameter[3].Value = _IKey;
return(objDataAccessHelper.GetDataTable(_procedureName, objBuyerParameter));
}
catch (Exception Ex)
{
strErrMsg = Ex.Message;
return(null);
}
}
//----------------------------------------------------------------End DropDown List Filling---------------------------------------------------------------------//
//----------------------------------------------------------------Start Checkbox List Filling-------------------------------------------------------------------//
//Start CheckBox List Filling
/// <summary>
/// Deepak Balhara:18-07-2016
/// </summary>
/// <param name="xCBL"></param>
/// <param name="xQry"></param>
/// <returns></returns>
public bool FillCheckBoxList(CheckBoxList xCBL, string xQry)
{
strErrMsg = "";
try
{
CDataAccess objDataAccessHelper = new CDataAccess();
DataTable xDt = objDataAccessHelper.GetDataTable(xQry, CommandType.Text);
objDataAccessHelper = null;
xCBL.DataSource = xDt;
xCBL.DataMember = xDt.TableName;
xCBL.DataTextField = xDt.Columns[0].ColumnName;
if (xDt.Columns.Count > 1)
{
xCBL.DataValueField = xDt.Columns[1].ColumnName;
}
else
{
xCBL.DataValueField = xDt.Columns[0].ColumnName;
}
xCBL.DataBind();
xCBL.Items.Insert(0, new ListItem("--Select--", "0"));
return(true);
}
catch (Exception ex)
{
strErrMsg = ex.Message;
return(false);
}
}
//----------------------------------------------------------
public void Load(string id, TMetaEntity me)
{
CDataAccess access = Context.GetDataAccess(me);
access.Context = this.Context;
DataTable dataTable = access.SelectById(id);
Load(dataTable, me);
}
//----------------------------------------------------------
public void Load(int no, TMetaEntity me)
{
CDataAccess access = Context.GetDataAccess(me);
access.Context = this.Context;
DataTable dataTable = access.SelectByNo(no);
Load(dataTable, me);
}
// User Login Check
public DataTable LoginAdmin(string user_id, string user_pwd)
{
CDataAccess objDataAccessHelper = new CDataAccess();
SqlParameter[] objParameter = new SqlParameter[2];
objParameter[0] = new SqlParameter("@email", SqlDbType.VarChar, 100); objParameter[0].Value = user_id;
objParameter[1] = new SqlParameter("@password", SqlDbType.VarChar, 50); objParameter[1].Value = user_pwd;
return(objDataAccessHelper.GetDataTable("login_check", objParameter));
}
public DataTable LoginUser(string user_id, string user_pwd)
{
CDataAccess objDataAccessHelper = new CDataAccess();
SqlParameter[] objParameter = new SqlParameter[2];
//int Results;
objParameter[0] = new SqlParameter("@username", SqlDbType.NVarChar, 50); objParameter[0].Value = user_id;
objParameter[1] = new SqlParameter("@password", SqlDbType.NVarChar, 50); objParameter[1].Value = user_pwd;
return(objDataAccessHelper.GetDataTable("AdminLogin", objParameter));
}
private void OpenFile(string FileName)
{
_dataAccess = new CDataAccess(FileName);
_dataAccess.ReadAllAccounts();
_dataAccess.ReadAllBudgets();
_dataAccess.ReadAllTransations();
_accountDesc.SetAccounts(_dataAccess.Accounts);
_transaction.SetBudgets(_dataAccess.Budgets);
_transaction.SetCategories(_dataAccess.Categories);
}
public LSReportCrystal()
: base()
{
// Mark the ctor as Internal. So, from outside the local assembly user needs
// to call the Static Methods to instantiate the class.
try
{
CDataAccess objCDataAccess = CDataAccess.NewCDataAccess();
DbCommand objDbCommand = objCDataAccess.GetMyCommand(false, IsolationLevel.ReadCommitted, "unknow", false);
}
catch { }
}
/// <summary>
/// Deepak Balhara:15-07-2016
/// </summary>
/// <param name="_query"></param>
/// <returns></returns>
public object ExecuteScalar(string _query)
{
CDataAccess objDataAccessHelper = new CDataAccess();
try
{
return(objDataAccessHelper.GetScalerValue(_query));
}
catch (Exception)
{
return("error");
}
}
/// <summary>
/// Deepak Balhara:19-07-2016
/// </summary>
/// <param name="propertyId"></param>
/// <param name="procedure"></param>
/// <returns></returns>
public DataTable AgentImagesDataTable(int propertyId, string procedure)
{
try
{
CDataAccess objDataAccessHelper = new CDataAccess();
SqlParameter[] objParameter = new SqlParameter[1];
objParameter[0] = new SqlParameter("@pUID", SqlDbType.Int); objParameter[0].Value = propertyId;
return(objDataAccessHelper.GetDataTable(procedure, objParameter));
}
catch (Exception)
{
return(null);
}
}
/// <summary>
/// Get images from database
/// Deepak Balhara:21-07-2016
/// </summary>
/// <param name="imgId"></param>
/// <param name="_colomnName"></param>
/// <param name="_tableName"></param>
/// <returns></returns>
public DataTable GetImages(string imgId, string _colomnName, string _tableName)
{
try
{
CDataAccess objDataAccessHelper = new CDataAccess();
SqlParameter[] objParameter = new SqlParameter[3];
objParameter[0] = new SqlParameter("@pUID", SqlDbType.Int); objParameter[0].Value = imgId;
objParameter[1] = new SqlParameter("@pColumnName", SqlDbType.VarChar, 50); objParameter[1].Value = _colomnName;
objParameter[2] = new SqlParameter("@pTableName", SqlDbType.VarChar, 50); objParameter[2].Value = _tableName;
return(objDataAccessHelper.GetDataTable("GetImages", objParameter));
}
catch (Exception)
{
return(null);
}
}
/// <summary>
/// Deepak Balhara:04-08-2016
/// Fill Data Table with Query
/// </summary>
///<param name="_query"></param>
///<param name="_commandType"></param>
/// <returns></returns>
public DataTable FillDataTable(string _query, CommandType _commandType)
{
strErrMsg = "";
CDataAccess objDataAccessHelper = new CDataAccess();
DataTable _dt = new DataTable();
try
{
_dt = objDataAccessHelper.GetDataTable(_query, _commandType);
}
catch (Exception Ex)
{
strErrMsg = Ex.Message;
}
return(_dt);
}
/// <summary>
/// Deepak Balhara:27-07-2016
/// Activate records table-wise
/// </summary>
/// <param name="pUID"></param>
/// <param name="ptablename"></param>
public void Activate(string pUID, string ptablename)
{
try
{
SqlParameter[] oParameters = new SqlParameter[2];
oParameters[0] = new SqlParameter("@pUID", SqlDbType.VarChar);
oParameters[0].Value = pUID;
oParameters[1] = new SqlParameter("@pTABLE_NAME", SqlDbType.VarChar);
oParameters[1].Value = ptablename;
CDataAccess.ExecuteNonQuery(CommandType.StoredProcedure, "Table_Wise_Activate", oParameters);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Deepak Balhara:06-08-2016
/// Fill Data Table with Parameter
/// </summary>
/// <param name="_procedureName"></param>
/// <param name="_StyleKey"></param>
/// <returns></returns>
public DataTable FillDataTable(string _procedureName, string _StyleKey)
{
strErrMsg = "";
try
{
CDataAccess objDataAccessHelper = new CDataAccess();
SqlParameter[] objBuyerParameter = new SqlParameter[1];
objBuyerParameter[0] = new SqlParameter("@pStyle_Key", SqlDbType.VarChar, 20);
objBuyerParameter[0].Value = _StyleKey;
return(objDataAccessHelper.GetDataTable(_procedureName, objBuyerParameter));
}
catch (Exception Ex)
{
strErrMsg = Ex.Message;
return(null);
}
}
/// <summary>
/// Deepak Balhara:06-08-2016
/// Fill Data Table with Parameter
/// </summary>
/// <param name="xCompGrpCode"></param>
/// <param naparam name="xTblName"></param>
/// <param name="xFldName"></param>
/// <returns></returns>
public string GetNextPK(string xCompGrpCode, string xTblName, string xFldName)
{
strErrMsg = "";
try
{
CDataAccess objDataAccessHelper = new CDataAccess();
SqlParameter[] objPara = new SqlParameter[3];
objPara[0] = new SqlParameter("@pvarCompGroupCode", xCompGrpCode);
objPara[1] = new SqlParameter("@pTblNm", xTblName);
objPara[2] = new SqlParameter("@pFldNm", xFldName);
return(xCompGrpCode + objDataAccessHelper.GetScalerValue("UDF_SaS_NextPK", objPara).ToString());
}
catch (Exception Ex)
{
strErrMsg = Ex.Message;
return(null);
}
}
/// <summary>
/// Deepak Balhara:06-08-2016
/// </summary>
/// <param name="xTblName"></param>
/// <param name="xFldName"></param>
/// <param name="xHead_PkeyFldNm"></param>
/// <param name="xHead_PkeyFldVal"></param>
/// <returns></returns>
public string GetNextPK_Detail(string xTblName, string xFldName, string xHead_PkeyFldNm, string xHead_PkeyFldVal)
{
strErrMsg = "";
try
{
CDataAccess objDataAccessHelper = new CDataAccess();
SqlParameter[] objPara = new SqlParameter[4];
objPara[0] = new SqlParameter("@pTblNm", xTblName);
objPara[1] = new SqlParameter("@pFldNm", xFldName);
objPara[2] = new SqlParameter("@pHead_PkeyFldNm", xHead_PkeyFldNm);
objPara[3] = new SqlParameter("@pHead_PkeyFldVal", xHead_PkeyFldVal);
return(objDataAccessHelper.GetScalerValue("UDF_SaS_NextPK_Detail", objPara).ToString());
}
catch (Exception Ex)
{
strErrMsg = Ex.Message;
return(null);
}
}
//---------------------------------------------------------------------
private void SaveColumnsBrutally(TMetaEntity me)
{
TMetaTable mt = me.MetaTable;
CDataAccess access = Context.GetDataAccess(me);
access.Context = this.Context;
string tableName = mt.TableName;
foreach (TMetaColumn mc in mt.Columns)
{
if (!mc.IsBrutallySave)
{
continue;
}
object v = GetEpoPropertyValue(mc);
string strValue = null;
switch (mc.DataType)
{
case TDataType.Int32:
case TDataType.Int64:
case TDataType.Int16:
case TDataType.Decimal:
strValue = v.ToString();
break;
case TDataType.String:
strValue = String.Format("'{0}'", v);
break;
case TDataType.DateTime:
strValue = String.Format("'{0}'", v);
break;
default:
strValue = v.ToString();
break;
}
string cmdText = String.Format("Update {0} set {1}={2} where ID='{3}'", mt.TableName, mc.ColumnName, strValue, Id);
access.ExecuteNonQuery(cmdText);
}
}
public string saveCategory()
{
string _result;
try
{
SqlParameter[] objParameter = new SqlParameter[2];
objParameter[0] = new SqlParameter("@pType", SqlDbType.NVarChar, 50); objParameter[0].Value = Category;
objParameter[1] = new SqlParameter("@pvcOut", SqlDbType.VarChar, 50); objParameter[1].Direction = ParameterDirection.Output;
CDataAccess.ExecuteNonQuery(CommandType.StoredProcedure, "Add_Type", objParameter);
_result = objParameter[1].Value.ToString();
return(_result);
}
catch (Exception ex)
{
return(_result = ex.Message.ToString());
}
}
/// <summary>
///
/// </summary>
/// <param name="psearchtext"></param>
/// <param name="pSearchby"></param>
/// <param name="createdby"></param>
/// <param name="Session"></param>
/// <param name="_procedureName"></param>
/// <returns></returns>
public System.Data.DataTable GetSearchingListing1(string psearchtext, int pSearchby, string createdby, string Session, string _procedureName)
{
DataSet _myDataSet = new DataSet();
try
{
SqlParameter[] oParameters = new SqlParameter[6];
oParameters[0] = new SqlParameter("@pvcSerachField", SqlDbType.VarChar);
oParameters[0].Value = psearchtext;
oParameters[1] = new SqlParameter("@pvcSortBy", SqlDbType.VarChar);
oParameters[1].Value = "";
oParameters[2] = new SqlParameter("@pvcSortOrder", SqlDbType.VarChar);
oParameters[2].Value = "";
oParameters[3] = new SqlParameter("@pintStartingWith", SqlDbType.Int);
oParameters[3].Value = pSearchby;
oParameters[4] = new SqlParameter("@pvcCreatedby", SqlDbType.VarChar);
oParameters[4].Value = createdby;
oParameters[5] = new SqlParameter("@pvrSession", SqlDbType.BigInt);
oParameters[5].Value = Session;
//if (createdby.Equals(string.Empty))
// oParameters[4].Value = DBNull.Value;
//else
_myDataSet = CDataAccess.ExecuteDataSet(System.Data.CommandType.StoredProcedure, _procedureName, oParameters);
return(_myDataSet.Tables[0]);
}
catch (Exception)
{
return(_myDataSet.Tables[0]);
}
}
/// <summary>
/// Deepak Balhara:19-07-2016
/// </summary>
/// <param name="xCBL"></param>
/// <param name="xCommandName"></param>
/// <param name="xCommandType"></param>
/// <param name="xTxtFld"></param>
/// <param name="xValFld"></param>
/// <returns></returns>
public bool FillCheckBoxList(CheckBoxList xCBL, string xCommandName, CommandType xCommandType, string xTxtFld, string xValFld)
{
strErrMsg = "";
try
{
CDataAccess objDataAccessHelper = new CDataAccess();
DataTable xDt = objDataAccessHelper.GetDataTable(xCommandName, xCommandType);
objDataAccessHelper = null;
xCBL.DataSource = xDt;
xCBL.DataMember = xDt.TableName;
xCBL.DataTextField = xTxtFld;
xCBL.DataValueField = xValFld;
xCBL.DataBind();
xCBL.Items.Insert(0, new ListItem("--Select--", "0"));
return(true);
}
catch (Exception ex)
{
strErrMsg = ex.Message;
return(false);
}
}
public string saveUserProject()
{
string _result;
try
{
SqlParameter[] objParameter = new SqlParameter[3];
objParameter[0] = new SqlParameter("@pProjectID", SqlDbType.VarChar, 50); objParameter[0].Value = ProjectID;
objParameter[1] = new SqlParameter("@pMode", SqlDbType.VarChar, 50); objParameter[1].Value = Mode;
objParameter[2] = new SqlParameter("@pvcOut", SqlDbType.VarChar, 50); objParameter[2].Direction = ParameterDirection.Output;
CDataAccess.ExecuteNonQuery(CommandType.StoredProcedure, "add_userprojects", objParameter);
_result = objParameter[2].Value.ToString();
return(_result);
}
catch (Exception ex)
{
return(_result = ex.Message.ToString());
}
}
public string saveBlogPost()
{
string _result;
try
{
SqlParameter[] objParameter = new SqlParameter[4];
objParameter[0] = new SqlParameter("@pProjectTitle", SqlDbType.NVarChar, -1); objParameter[0].Value = ProjectTitle;
objParameter[1] = new SqlParameter("@pProjectDesc", SqlDbType.NVarChar, -1); objParameter[1].Value = BlogPost;
objParameter[2] = new SqlParameter("@pMode", SqlDbType.VarChar, 50); objParameter[2].Value = Mode;
objParameter[3] = new SqlParameter("@pvcOut", SqlDbType.VarChar, 50); objParameter[3].Direction = ParameterDirection.Output;
CDataAccess.ExecuteNonQuery(CommandType.StoredProcedure, "Add_Project", objParameter);
_result = objParameter[3].Value.ToString();
return(_result);
}
catch (Exception ex)
{
return(_result = ex.Message.ToString());
}
}
//---------------------------------------------------------
public virtual CDataAccess GetDataAccess()
{
if (Context == null)
{
return(null);
}
Type type = this.GetType();
TMetaEntity meta = GetMetaEntity(type);
CDataAccess access = Context.AccessCache.GetDataAccess(meta);
if (access == null)
{
//TODO: DataAccess comes first from override method, then MetaEntity
// find is there any override CreateDataAccess in exactly that hierarchy level?
access = CreateDataAccess();
access.MetaTable = meta.MetaTable;
Context.AccessCache.Register(meta, access);
}
access.Context = this.Context;
return(access);
}
public string saveSong()
{
string _result;
try
{
SqlParameter[] objParameter = new SqlParameter[5];
objParameter[0] = new SqlParameter("@psongname", SqlDbType.NVarChar, 50); objParameter[0].Value = SongName;
objParameter[1] = new SqlParameter("@psingerID", SqlDbType.NVarChar, 50); objParameter[1].Value = SingerID;
objParameter[2] = new SqlParameter("@pTypeID", SqlDbType.NVarChar, 50); objParameter[2].Value = TypeID;
objParameter[3] = new SqlParameter("@psongpath", SqlDbType.NVarChar, 50); objParameter[3].Value = SongPath;
objParameter[4] = new SqlParameter("@pvcOut", SqlDbType.VarChar, 50); objParameter[4].Direction = ParameterDirection.Output;
CDataAccess.ExecuteNonQuery(CommandType.StoredProcedure, "Add_Song", objParameter);
_result = objParameter[4].Value.ToString();
return(_result);
}
catch (Exception ex)
{
return(_result = ex.Message.ToString());
}
}
public CRptGroupForms()
{
Con.ConnectionString = CDataAccess.GetConStr();
}
private static void NewCmd()
{
Cmd = new SqlCommand();
Con.ConnectionString = CDataAccess.GetConStr();
Cmd.Connection = Con;
}
/// <summary>
/// Deepak Balhara:15-07-2016
/// </summary>
/// <param name="_query"></param>
/// <returns></returns>
public SqlDataReader subquery(string _query)
{
return(CDataAccess.ExecuteReader(CommandType.Text, _query));
}
