public MEMBERS.SQLReturnValue ExecuteProceduerWithValueSpecial(string ProceduerName, object obj, int ReturnTypeOutVal = 3)
{
MEMBERS.SQLReturnValue res = new MEMBERS.SQLReturnValue();
try
{
SqlCommand cmd = new SqlCommand
{
CommandText = ProceduerName,
Connection = con,
CommandType = CommandType.StoredProcedure
};
if (obj != null)
{
SqlParameter[] param = new SQLPatameterClass().ConvertClassToSQLParams(obj);
cmd.Parameters.AddRange(param);
}
cmd.Parameters.Add("OUTVAL", (ReturnTypeOutVal == 1 ? SqlDbType.UniqueIdentifier : ReturnTypeOutVal == 2 ? SqlDbType.Int : SqlDbType.NVarChar), -1).Direction = ParameterDirection.Output;
if (con.State != ConnectionState.Open)
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
res.Outval = cmd.Parameters["OUTVAL"].Value;
}
catch (Exception ee)
{
res.Outval = "Error : " + ee.Message;
}
return(res);
}
public MEMBERS.SQLReturnValue ExecuteProcedureWithDatatable(string ProcedureName, DataTable tableValue
, string TableParamName, object obj, int ReturnTypeOutVal = 3)
{
MEMBERS.SQLReturnValue res = new MEMBERS.SQLReturnValue();
SqlCommand cmd = new SqlCommand
{
CommandText = ProcedureName,
Connection = con,
CommandType = CommandType.StoredProcedure
};
SqlParameter[] param = new SQLPatameterClass().ConvertClassToSQLParams(obj);
cmd.Parameters.AddRange(param);
if (tableValue != null)
{
SqlParameter tableParam = new SqlParameter("@" + TableParamName, tableValue)
{
SqlDbType = SqlDbType.Structured
};
cmd.Parameters.Add(tableParam);
}
cmd.Parameters.Add("OUTVAL", (ReturnTypeOutVal == 1 ? SqlDbType.UniqueIdentifier : SqlDbType.Int)).Direction = ParameterDirection.Output;
if (con.State != ConnectionState.Open)
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
res.Outval = cmd.Parameters["OUTVAL"].Value;
return(res);
}
public MEMBERS.SQLReturnValue ExecuteProceduerWithValue(string ProceduerName, object[,] ParamValue, int ReturnTypeOutVal = 3)
{
MEMBERS.SQLReturnValue res = new MEMBERS.SQLReturnValue();
try
{
SqlCommand cmd = new SqlCommand
{
CommandText = ProceduerName,
Connection = con,
CommandType = CommandType.StoredProcedure
};
SqlParameter[] param = new SqlParameter[ParamValue.GetUpperBound(0) + 1];
for (int i = 0; i < param.Length; i++)
{
param[i] = new SqlParameter("@" + ParamValue[i, 0].ToString(), (ParamValue[i, 1] == null ? null : (ParamValue[i, 1].ToString() == "null" ? null : ParamValue[i, 1].ToString())));
}
cmd.Parameters.AddRange(param);
cmd.Parameters.Add("OUTVAL", (ReturnTypeOutVal == 1 ? SqlDbType.UniqueIdentifier : ReturnTypeOutVal == 2 ? SqlDbType.Int : SqlDbType.NVarChar), -1).Direction = ParameterDirection.Output;
if (con.State != ConnectionState.Open)
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
res.Outval = cmd.Parameters["OUTVAL"].Value;
}
catch (Exception ee)
{
res.Outval = "Error : " + ee.Message;
}
return(res);
}
public MEMBERS.SQLReturnValue ExecuteProcedureWithDatatable(string ProceduerName, DataTable data, string TableParamName, object[,] ParamValue, int ReturnTypeOutVal)
{
MEMBERS.SQLReturnValue res = new MEMBERS.SQLReturnValue();
SqlCommand cmd = new SqlCommand
{
CommandText = ProceduerName,
Connection = con,
CommandType = CommandType.StoredProcedure
};
SqlParameter[] param = new SqlParameter[ParamValue.GetUpperBound(0) + 1];
for (int i = 0; i < param.Length; i++)
{
param[i] = new SqlParameter("@" + ParamValue[i, 0].ToString(), ParamValue[i, 1].ToString());
}
cmd.Parameters.AddRange(param);
if (data != null)
{
SqlParameter parameterDataTable = new SqlParameter("@" + TableParamName, data)
{
SqlDbType = SqlDbType.Structured
};
cmd.Parameters.Add(parameterDataTable);
}
cmd.Parameters.Add("OUTVAL", (ReturnTypeOutVal == 1 ? SqlDbType.UniqueIdentifier : ReturnTypeOutVal == 2 ? SqlDbType.Int : SqlDbType.NVarChar), -1).Direction = ParameterDirection.Output;
if (con.State != ConnectionState.Open)
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
res.Outval = cmd.Parameters["OUTVAL"].Value;
return(res);
}
