public static bool ReturnDBInputStatus(object obj, string SPName) { DBSettingEntity dbSetting = new DBSettingEntity(DataProvider.SqlServer, DBSetting.GetDBConnection(DBSource.MainDBConstr), CommandType.StoredProcedure, DBSetting.GetSPValue(SPName), false); List <SPParameterEntity> sp = SPParameterObject.GetParameter(SPName); PropertyInfo[] ps = obj.GetType().GetProperties(); bool statusVal = false; foreach (PropertyInfo p in ps) { string parametername = string.Empty; if (sp.Exists(delegate(SPParameterEntity s) { parametername = s.name; return(s.name.ToLower() == "@" + p.Name.ToLower()); })) { dbSetting.AddParameters(parametername, p.GetValue(obj, null) == null ? DBNull.Value : p.GetValue(obj, null), ParameterDirection.Input); } } Func <IDataReader, bool> func = delegate(IDataReader dr) { while (dr.Read()) { if (dr["StatusValue"].ToString() == "1") { statusVal = true; } else { statusVal = false; } } return(true); }; DBManager2.Instance.ExecuteReader(dbSetting, func); return(statusVal); }
public static void InputToDB(object obj, string SPName) { DBSettingEntity dbSetting = new DBSettingEntity(DataProvider.SqlServer, DBSetting.GetDBConnection(DBSource.MainDBConstr), CommandType.StoredProcedure, DBSetting.GetSPValue(SPName), false); List <SPParameterEntity> sp = SPParameterObject.GetParameter(SPName); PropertyInfo[] ps = obj.GetType().GetProperties(); foreach (PropertyInfo p in ps) { string parametername = string.Empty; if (sp.Exists(delegate(SPParameterEntity s) { parametername = s.name; return(s.name.ToLower() == "@" + p.Name.ToLower()); })) { dbSetting.AddParameters(parametername, p.GetValue(obj, null) == null ? DBNull.Value : p.GetValue(obj, null), ParameterDirection.Input); } } DBManager2.Instance.ExecuteNonQuery(dbSetting); }