public static void IntrestApprovel(string MatrimonialID, string FromID, IntrestStatus Status)
{
/* * * * * * * * * * * * * * * * * * * * * * * * *
* Procedure Name : UserIntrests_ApproveIntrest
* * * * * * * * * * * * * * * * * * * * * * * * *
* Type: INSERT
* * * * * * * * * * * * * * * * * * * * * * * * *
* Parameters :
* * * * * * * * * * * * * * * * * * * * * * * * *
* @IntrestFrom varchar(25),
* @IntrestTo varchar(25),
* @Status smallint,
* * * * * * * * * * * * * * * * * * * * * * * * */
using (SqlConnection objConnection = DBConnection.GetSqlConnection())
{
try
{
//Inserting data into
//Creating Command object
SqlCommand objCommand = new SqlCommand("UserIntrests_ApproveIntrest", objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@IntrestFrom", SqlDbType.VarChar));
objCommand.Parameters.Add(new SqlParameter("@IntrestTo", SqlDbType.VarChar));
objCommand.Parameters.Add(new SqlParameter("@Status", SqlDbType.SmallInt));
// Setting Valuse
objCommand.Parameters["@IntrestFrom"].Value = FromID;
objCommand.Parameters["@IntrestTo"].Value = MatrimonialID;
//objCommand.Parameters["@Status"].Value = 2;
switch (Status)
{
case IntrestStatus.Pending:
objCommand.Parameters["@Status"].Value = 1;
break;
case IntrestStatus.Accepted:
objCommand.Parameters["@Status"].Value = 2;
break;
case IntrestStatus.Declined:
objCommand.Parameters["@Status"].Value = 3;
break;
}
// Executing Qurey
objConnection.Open();
int intTemp = objCommand.ExecuteNonQuery();
}
catch (Exception Ex)
{
ErrorLog.WriteErrorLog("InternalMessage.IntrestApprovel", Ex);
}
finally
{
objConnection.Close();
}
}
}
public static int GetIntrestCount(string MatrimonialID, IntrestStatus intrestStatus, MailType mailType)
{
/* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Procedure Name : UserIntrests_Count
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Type: SELECT
* * * * * * * * * * * * * * * * * * * * * * * * * * * */
int strInt = 0;
using (SqlConnection objConnection = DBConnection.GetSqlConnection())
{
try
{
//Creating Command object
SqlCommand objCommand = new SqlCommand("UserIntrests_Count", objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.Parameters.Add(new SqlParameter("@MatrimonialID", SqlDbType.VarChar));
objCommand.Parameters["@MatrimonialID"].Value = MatrimonialID;
if (mailType == MailType.OutBox)
{
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.SmallInt));
objCommand.Parameters["@Flag"].Value = 1;
}
objCommand.Parameters.Add(new SqlParameter("@Status", SqlDbType.SmallInt));
switch (intrestStatus)
{
case IntrestStatus.Pending:
objCommand.Parameters["@Status"].Value = 1;
break;
case IntrestStatus.Accepted:
objCommand.Parameters["@Status"].Value = 2;
break;
case IntrestStatus.Declined:
objCommand.Parameters["@Status"].Value = 3;
break;
}
objConnection.Open();
SqlDataReader objReader = objCommand.ExecuteReader();
objReader.Read();
strInt = objReader.GetInt32(0);
objReader.Close();
}
catch (Exception Ex)
{
ErrorLog.WriteErrorLog("InternalMessage- GetIntrestCount", Ex);
strInt = 0;
}
finally
{
objConnection.Close();
}
return(strInt);
}
}
