/// <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));
}
