public static OpCode AddOrUpdate(OpCode obj)
{
ProcQuery = SpNameList.UspInsertOrUpdate;
ConnString = ConfigStatic.PskwConnectionstring;
if (obj.OpcodeId > 0)
{
ListSqlParameters.Add(new SqlParameter("@OpcodeID ", obj.OpcodeId));
}
ListSqlParameters.Add(new SqlParameter("@OpcodeName ", obj.OpcodeName));
ListSqlParameters.Add(new SqlParameter("@OpcodeDescription ", obj.OpcodeDescription));
ListSqlParameters.Add(new SqlParameter("@ProgramID ", obj.ProgramId));
ListSqlParameters.Add(new SqlParameter("@UpdatedDate ", DateTime.Now));
ListSqlParameters.Add(new SqlParameter("@IsActive ", !obj.IsActive));
//0 for add or insert
ListSqlParameters.Add(new SqlParameter("@OpFlag", SqlDbType.Int)
{
Value = 0
});
//var outPut = new SqlParameter("@OutStatus", SqlDbType.Int) { Direction = ParameterDirection.Output };
//ListSqlParameters.Add(outPut);
var dt = SqlHelper.ExecuteStoredProcedure<DataTable>(ConnString, ProcQuery, ListSqlParameters);
return SqlHelper.DataTableToList<OpCode>(dt).FirstOrDefault();
//return CultureInfoFormat.ToInt32(outPut.Value);
}
public static OpCode Delete(OpCode obj)
{
ProcQuery = SpNameList.UspInsertOrUpdate;
ConnString = ConfigStatic.PskwConnectionstring;
ListSqlParameters.Add(new SqlParameter("@OpcodeID ", obj.OpcodeId));
ListSqlParameters.Add(new SqlParameter("@IsActive ", obj.IsActive));
//1 for Delete
ListSqlParameters.Add(new SqlParameter("@OpFlag ", 1));
var dt = SqlHelper.ExecuteStoredProcedure<DataTable>(ConnString, ProcQuery, ListSqlParameters);
return SqlHelper.DataTableToList<OpCode>(dt).FirstOrDefault();
}
public static ICollection<OpCode> Get(OpCode obj)
{
ProcQuery = SpNameList.UspGetOpCodeList;
ConnString = ConfigStatic.PskwConnectionstring;
if (obj.OpcodeId > 0)
{
ListSqlParameters.Add(new SqlParameter("@OpcodeID ", obj.OpcodeId));
}
var dt = SqlHelper.ExecuteStoredProcedure<DataTable>(ConnString, ProcQuery, ListSqlParameters);
return SqlHelper.DataTableToList<OpCode>(dt);
//return (from DataRow row in dt.Rows
// select new OpCode
// {
// OpcodeId = !string.IsNullOrEmpty(CultureInfoFormat.ToString(row["OpcodeID"])) ? CultureInfoFormat.ToInt64(row["OpcodeID"]) : 0,
// OpcodeName = !string.IsNullOrEmpty(CultureInfoFormat.ToString(row["OpcodeName"])) ? CultureInfoFormat.ToString(row["OpcodeName"]) : string.Empty,
// OpcodeDescription = !string.IsNullOrEmpty(CultureInfoFormat.ToString(row["OpcodeDescription"])) ? CultureInfoFormat.ToString(row["OpcodeDescription"]) : string.Empty,
// ProgramId = !string.IsNullOrEmpty(CultureInfoFormat.ToString(row["ProgramID"])) ? CultureInfoFormat.ToString(row["ProgramID"]) : string.Empty,
// UpdatedDate = !string.IsNullOrEmpty(CultureInfoFormat.ToString(row["UpdatedDate"])) ? CultureInfoFormat.ToString(CultureInfoFormat.ToDateTime(row["UpdatedDate"])) : string.Empty,
// IsActive = !string.IsNullOrEmpty(CultureInfoFormat.ToString(row["IsActive"])) && CultureInfoFormat.ToBoolean(row["IsActive"]),
// }).ToList();
}
public static ICollection<OpCode> Get(OpCode obj)
{
return OpCodeDa.Get(obj);
}