internal static void InsertMail(string Mail_Value)
{
using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
{
DbUtilsDal.ExecuteDataRow(con, "dbo.InsertMail",
new string[] { "@Mail_Value" },
new SqlDbType[] { SqlDbType.VarChar },
new object[] { Mail_Value });
}
}
internal static void UpdateUsedMails(long Mail_ID)
{
using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
{
DbUtilsDal.ExecuteDataRow(con, "dbo.UpdateUsedMails",
new string[] { "@Mail_ID" },
new SqlDbType[] { SqlDbType.BigInt },
new object[] { Mail_ID });
}
}
internal static DataRow GetMail(string Mail_Value)
{
DataRow R = null;
using (SqlConnection con = DbUtilsDal.OpenConnection(DbUtilsDal.MainDB))
{
R = DbUtilsDal.ExecuteDataRow(con, "dbo.GetMail",
new string[] { "@Mail_Value" },
new SqlDbType[] { SqlDbType.VarChar },
new object[] { Mail_Value });
}
return(R);
}