public int AddRecord(EventBirthDayBLL objEBDB)
{
int row;
try
{
conn.Open();
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
SqlParameter[] par = new SqlParameter[12];
//par[0] = new SqlParameter("@BID",objEBDB.BId1);
par[0] = new SqlParameter("@NameOfPerson", objEBDB.NameOfPerson1);
par[1] = new SqlParameter("@MobileNo", objEBDB.MobileNo1);
par[2] = new SqlParameter("@BirthDate", objEBDB.Birthdate1);
par[5] = new SqlParameter("@Gender", objEBDB.Gender1);
par[6] = new SqlParameter("@SMsg", objEBDB.SMsg1);
par[7] = new SqlParameter("@MDescp", objEBDB.MDescp1);
par[3] = new SqlParameter("@RemDate", objEBDB.RemDate1);
par[4] = new SqlParameter("@Time", objEBDB.Time1);
par[8] = new SqlParameter("@UserId", objEBDB.UserId1);
par[9] = new SqlParameter("@Status1", objEBDB.Status);
par[10] = new SqlParameter("@Status2", objEBDB.Status4);
//par[10] = new SqlParameter("@Status3", objEBDB.Status5);
string srt = DateTime.Now.Date.ToString("yyyy-MM-dd");
//string srt = DateTime.Now.Date.AddDays(1).ToString("yyyy-MM-dd");
//par[11] = new SqlParameter("@CurrentDate", cc.DateFormatStatus());
par[11] = new SqlParameter("@CurrentDate", srt);
row = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "EventBirthDayInsert", par);
///string str = "Update tbl_EBirthDay set Status1='1' where UserId='" + objEBDB.UserId1 + "'";
//int i = cc.ExecuteNonQuery(str);
}
return(row);
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
public DataSet catchBDay(EventBirthDayBLL objEBDB)
{
try
{
DataSet ds = new DataSet();
conn.Open();
SqlCommand cmd = new SqlCommand("EventCatchBday", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return(ds);
}
catch (Exception ex)
{
throw ex;
}
}
//-------------------------------------------------------Add Record BirthdayEvent----------------------------------------------------------------
public DataSet loadGrid(EventBirthDayBLL objEBDB)
{
DataSet ds = new DataSet();
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
SqlParameter[] par = new SqlParameter[10];
par[0] = new SqlParameter("@UserId", objEBDB.UserId1);
par[1] = new SqlParameter("@Status", 1);
par[1].Direction = ParameterDirection.Output;
ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "EventLoadGridBDay", par);
}
return(ds);
}
catch (Exception ex)
{
throw ex;
}
}
public void SelectRecord(EventBirthDayBLL objEBDB)
{
SqlDataReader dr;
try
{
conn.Open();
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
SqlParameter[] par = new SqlParameter[]
{
new SqlParameter("BID", objEBDB.BID1),
};
dr = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "EBdaySelect", par);
if (dr.HasRows)
{
dr.Read();
objEBDB.NameOfPerson1 = Convert.ToString(dr["NameOfPerson"]);
objEBDB.Birthdate1 = Convert.ToString(dr["Birthdate"]);
objEBDB.RemDate1 = Convert.ToString(dr["RemDate"]);
objEBDB.MobileNo1 = Convert.ToString(dr["MobileNo"]);
objEBDB.Time1 = Convert.ToString(dr["Time"]);
objEBDB.Gender1 = Convert.ToString(dr["Gender"]);
objEBDB.SMsg1 = Convert.ToString(dr["SMsg"]);
objEBDB.MDescp1 = Convert.ToString(dr["MDescp"]);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
//-------------------------------------------------------Update Record BirthdayEvent----------------------------------------------------------------
public int UpdateRecord(EventBirthDayBLL objEBDB)
{
int row;
try
{
conn.Open();
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
SqlParameter[] par = new SqlParameter[]
{
new SqlParameter("@BID", objEBDB.BID1),
new SqlParameter("@NameOfPerson", objEBDB.NameOfPerson1),
new SqlParameter("@Birthdate", objEBDB.Birthdate1),
new SqlParameter("@RemDate", objEBDB.RemDate1),
new SqlParameter("@MobileNo", objEBDB.MobileNo1),
new SqlParameter("@Time", objEBDB.Time1),
new SqlParameter("@SMsg", objEBDB.SMsg1),
new SqlParameter("@MDescp", objEBDB.MDescp1),
new SqlParameter("@Gender", objEBDB.Gender1),
new SqlParameter("@CurrentDate", cc.DateFormatStatus()),
new SqlParameter("UserId", objEBDB.UserId1),
};
row = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "sp_UEBDay", par);
return(row);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
public int UpdateRecordBLL(EventBirthDayBLL objEBDB)
{
int k = ovjEBD.UpdateRecord(objEBDB);
return(k);
}
public void Selectrecord(EventBirthDayBLL objEBDB)
{
ovjEBD.SelectRecord(objEBDB);
}
public DataSet catchBdayBLL(EventBirthDayBLL objEBDB)
{
return(ovjEBD.catchBDay(objEBDB));
}
public int AddRecordBLL(EventBirthDayBLL objEBDB)
{
int k = ovjEBD.AddRecord(objEBDB);
return(k);
}
public DataSet LoadgridBLL(EventBirthDayBLL objEBDB)
{
return(ovjEBD.loadGrid(objEBDB));
}
