/// <summary> /// Insert Junk Words /// </summary> /// <param name="JunkWordsMaster"></param> /// <returns></returns> public int InsertJunkWords(JunkWordsMaster junkWordsMaster) { int success = 0; try { conn.Open(); MySqlCommand cmd = new MySqlCommand("SP_InsertJunkKeywords", conn); cmd.Connection = conn; cmd.Parameters.AddWithValue("@Junk_Keyword", string.IsNullOrEmpty(junkWordsMaster.JunkKeyword) ? "" : junkWordsMaster.JunkKeyword.TrimEnd(',')); cmd.Parameters.AddWithValue("@_Reason", string.IsNullOrEmpty(junkWordsMaster.Reason) ? "" : junkWordsMaster.Reason); cmd.Parameters.AddWithValue("@Created_By", junkWordsMaster.CreatedBy); cmd.Parameters.AddWithValue("@Tenant_Id", junkWordsMaster.TenantID); cmd.CommandType = CommandType.StoredProcedure; success = cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } return(success); }
/// <summary> /// List JunkWords /// </summary> /// <param name="tenantId"></param> /// <returns></returns> public List <JunkWordsMaster> ListJunkWords(int tenantId) { DataSet ds = new DataSet(); List <JunkWordsMaster> listJunkWords = new List <JunkWordsMaster>(); try { conn.Open(); MySqlCommand cmd = new MySqlCommand("SP_ListJunkKeywords", conn) { Connection = conn, CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@Tenant_Id", tenantId); MySqlDataAdapter da = new MySqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds); if (ds != null && ds.Tables[0] != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { JunkWordsMaster junkWordsMaster = new JunkWordsMaster(); junkWordsMaster.JunkKeywordID = ds.Tables[0].Rows[i]["JunkKeywordID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["JunkKeywordID"]); junkWordsMaster.JunkKeyword = ds.Tables[0].Rows[i]["JunkKeywords"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["JunkKeywords"]); junkWordsMaster.Reason = ds.Tables[0].Rows[i]["Reason"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Reason"]); junkWordsMaster.EnteredBy = ds.Tables[0].Rows[i]["EnteredBy"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["EnteredBy"]); junkWordsMaster.EnteredDate = ds.Tables[0].Rows[i]["EnteredDate"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["EnteredDate"]); junkWordsMaster.ModifyBy = ds.Tables[0].Rows[i]["ModifyBy"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ModifyBy"]); junkWordsMaster.ModifyDate = ds.Tables[0].Rows[i]["ModifyDate"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ModifyDate"]); listJunkWords.Add(junkWordsMaster); } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } return(listJunkWords); }
public int UpdateJunkWords(IJunkWords junkWords, JunkWordsMaster junkWordsMaster) { _junkWords = junkWords; return(_junkWords.UpdateJunkWords(junkWordsMaster)); }
public int InsertJunkWords(IJunkWords junkWords, JunkWordsMaster junkWordsMaster) { _junkWords = junkWords; return(_junkWords.InsertJunkWords(junkWordsMaster)); }