public override void Insert_T_NewsChuyenDe_From_T_NewsChuyenDe(int news_id, int copyfrom, int Lang_id, int status, int nguoisua, DateTime ngaysua) { string _sql = "[Insert_T_NewsChuyenDe_From_T_NewsChuyenDe]"; SqlService _sqlservice = new SqlService(); try { _sqlservice.AddParameter("@ID", SqlDbType.Int, news_id, true); _sqlservice.AddParameter("@CopyFrom", SqlDbType.Int, copyfrom, true); _sqlservice.AddParameter("@Lang_Id", SqlDbType.Int, Lang_id, true); _sqlservice.AddParameter("@News_Status", SqlDbType.Int, status, true); _sqlservice.AddParameter("@News_EditorID", SqlDbType.Int, nguoisua, true); _sqlservice.AddParameter("@News_DateEdit", SqlDbType.DateTime, ngaysua, true); _sqlservice.ExecuteSP(_sql); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override void UpdateObject(object obj) { SqlService _sqlservice = new SqlService(connectionString); string sql = "Sp_UpdateRow" + obj.GetType().Name; foreach (PropertyInfo propertyinfo in obj.GetType().GetProperties()) { //if (propertyinfo.PropertyType.ToString() == "System.DateTime") //{ // if ((DateTime)propertyinfo.GetValue(obj, null) == DateTime.MinValue || (DateTime)propertyinfo.GetValue(obj, null) == DateTime.MaxValue) // _sqlservice.AddParameter(new SqlParameter("@" + propertyinfo.Name, DBNull.Value)); // else // _sqlservice.AddParameter(new SqlParameter("@" + propertyinfo.Name, propertyinfo.GetValue(obj, null))); //} //else //{ _sqlservice.AddParameter(new SqlParameter("@" + propertyinfo.Name, propertyinfo.GetValue(obj, null))); // } } try { _sqlservice.ExecuteSP(sql); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override double ExecStoreReturn(string StoreName, string[] param1, object[] value) { string _sql = StoreName; SqlService _sqlservice = new SqlService(connectionString); for (int i = 0; i < param1.Length; i++) { _sqlservice.AddParameter(new SqlParameter(param1[i], value[i])); } SqlParameter paraOutput = new SqlParameter("@ReturnValue", SqlDbType.Float); paraOutput.Value = 0; paraOutput.Direction = ParameterDirection.Output; _sqlservice.AddParameter(paraOutput); try { _sqlservice.ExecuteSP(_sql); return((double)paraOutput.Value); } catch (Exception ex) { throw ex; } finally { _sqlservice.CloseConnect(); _sqlservice.Disconnect(); } }
public override void ExecStore(string StoreName) { string _sql = StoreName; SqlService _sqlservice = new SqlService(connectionString); _sqlservice.ExecuteSP(_sql); _sqlservice.Disconnect(); }
public override int InsertObjectReturn(object obj, string spName) { SqlService _sqlservice = new SqlService(connectionString); string sql = spName; foreach (PropertyInfo propertyinfo in obj.GetType().GetProperties()) { if (propertyinfo.PropertyType.ToString() == "System.DateTime") { if ((DateTime)propertyinfo.GetValue(obj, null) == DateTime.MinValue || (DateTime)propertyinfo.GetValue(obj, null) == DateTime.MaxValue) { _sqlservice.AddParameter(new SqlParameter("@" + propertyinfo.Name, DBNull.Value)); } else { _sqlservice.AddParameter(new SqlParameter("@" + propertyinfo.Name, propertyinfo.GetValue(obj, null))); } } else { _sqlservice.AddParameter(new SqlParameter("@" + propertyinfo.Name, propertyinfo.GetValue(obj, null))); } } SqlParameter paraOutput = new SqlParameter("@ReturnValue", SqlDbType.Int); paraOutput.Value = 0; paraOutput.Direction = ParameterDirection.Output; _sqlservice.AddParameter(paraOutput); try { _sqlservice.ExecuteSP(sql); return((int)paraOutput.Value); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override void Insert_T_Event_Category_From_T_Event_Category(int news_id) { string _sql = "[Insert_T_Event_Category_From_T_Event_Category]"; SqlService _sqlservice = new SqlService(); try { _sqlservice.AddParameter("@ID", SqlDbType.Int, news_id, true); _sqlservice.ExecuteSP(_sql); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override void Insert_T_CategoryChuyenDe_From_T_CategoryChuyenDe(int news_id, int copyfrom) { string _sql = "[Insert_T_CategoryChuyenDe_From_T_CategoryChuyenDe]"; SqlService _sqlservice = new SqlService(); try { _sqlservice.AddParameter("@ID", SqlDbType.Int, news_id, true); _sqlservice.AddParameter("@CopyFrom", SqlDbType.Int, copyfrom, true); _sqlservice.ExecuteSP(_sql); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override void Insert_T_NewsEvent_Content_From_T_NewsEvent_Content(int news_id, int _CopyFrom) { string _sql = "Insert_T_NewsEvent_Content_From_T_NewsEvent_Content"; SqlService _sqlservice = new SqlService(); try { _sqlservice.AddParameter("@ID", SqlDbType.Int, news_id, true); _sqlservice.AddParameter("@Copyfrom", SqlDbType.Int, _CopyFrom, true); _sqlservice.ExecuteSP(_sql); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override void ExecStore(string StoreName, string[] param1, object[] value) { string _sql = StoreName; SqlService _sqlservice = new SqlService(connectionString); for (int i = 0; i < param1.Length; i++) { _sqlservice.AddParameter(new SqlParameter(param1[i], value[i])); } try { _sqlservice.ExecuteSP(_sql); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }