private SqlParameter[] GetParameters(U_EVNT_MASTER tobjU_EVNT_MASTER)
{
SqlParameter[] objParamArray = SqlHelperParameterCache.GetCachedParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_EVNT_MASTER);
if (objParamArray == null)
{
//Represents a parameter to a System.Data.SqlClient.SqlCommand,
//and optionally, its mapping to System.Data.DataSet columns.
objParamArray = new SqlParameter[]
{
new SqlParameter(PARAM_Event_Id, tobjU_EVNT_MASTER.Event_Id),
new SqlParameter(PARAM_Event_Creator_Id, tobjU_EVNT_MASTER.Event_Creator_Id),
new SqlParameter(PARAM_Event_Type_Id, tobjU_EVNT_MASTER.Event_Type_Id),
new SqlParameter(PARAM_Event_Name, tobjU_EVNT_MASTER.Event_Name),
new SqlParameter(PARAM_Event_Desc, tobjU_EVNT_MASTER.Event_Desc),
new SqlParameter(PARAM_Event_StartDate, tobjU_EVNT_MASTER.Event_StartDate),
new SqlParameter(PARAM_Event_EndDate, tobjU_EVNT_MASTER.Event_EndDate),
new SqlParameter(PARAM_Even_Location, tobjU_EVNT_MASTER.Even_Location),
new SqlParameter(PARAM_Event_Status, tobjU_EVNT_MASTER.Event_Status),
new SqlParameter(PARAM_Media_Id_Img, tobjU_EVNT_MASTER.Media_Id_Img),
new SqlParameter(PARAM_COMMENTS, tobjU_EVNT_MASTER.COMMENTS),
new SqlParameter(PARAM_Created_Date, tobjU_EVNT_MASTER.Created_Date),
new SqlParameter(PARAM_Updated_Date, tobjU_EVNT_MASTER.Updated_Date),
new SqlParameter(PARAM_Created_by, tobjU_EVNT_MASTER.Created_by),
new SqlParameter(PARAM_Updated_by, tobjU_EVNT_MASTER.Updated_by),
};
SqlHelperParameterCache.CacheParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_EVNT_MASTER, objParamArray);
}
return(objParamArray);
}
public string CreateEvent(CreateEvent obj)
{
U_EVNT_MASTERDAL oeventDAL = new U_EVNT_MASTERDAL();
U_EVNT_MASTER oevent = new U_EVNT_MASTER();
oevent.Event_Creator_Id = obj.User_Id;
oevent.COMMENTS = "";
oevent.Created_by = obj.User_Id;
oevent.Created_Date = DateTime.Now;
oevent.Event_Desc = obj.Description;
oevent.Event_EndDate = obj.End_Date;
oevent.Event_Id = Guid.NewGuid().ToString();
oevent.Event_StartDate = obj.Start_Date;
oevent.Event_Name = obj.Event_Name;
oevent.Event_Status = "1";
oevent.Event_Type_Id = obj.Type_Id;
oevent.Even_Location = obj.Event_Location;
oevent.Media_Id_Img = SelectMediaImageId(obj.Type_Id);
oevent.Updated_by = "";
oevent.Updated_Date = DateTime.Now;
var status = oeventDAL.InsertU_EVNT_MASTER(oevent);
if (status == true)
{
return("1");
}
else
{
return("0");
}
}
public int Update_EventDetailsDb(U_EVNT_MASTER eve)
{
SqlParameter[] aParms = GetParameters(eve);
SetParameters(aParms, eve);
using (SqlConnection conn = General.GetConnection())
{
int status = 0;
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SQL_UPDATE_Event, aParms);
trans.Commit();
status = 1;
}
catch (System.Exception e)
{
Console.Write(e);
trans.Rollback();
//log.Error(lobjError, e);
throw;
}
}
return(status);
}
}
private void SetParameters(SqlParameter[] U_EVNT_MASTERParms, U_EVNT_MASTER tobjU_EVNT_MASTER)
{
U_EVNT_MASTERParms[0].Value = tobjU_EVNT_MASTER.Event_Id;
U_EVNT_MASTERParms[1].Value = tobjU_EVNT_MASTER.Event_Creator_Id;
U_EVNT_MASTERParms[2].Value = tobjU_EVNT_MASTER.Event_Type_Id;
U_EVNT_MASTERParms[3].Value = tobjU_EVNT_MASTER.Event_Name;
U_EVNT_MASTERParms[4].Value = tobjU_EVNT_MASTER.Event_Desc;
U_EVNT_MASTERParms[5].Value = tobjU_EVNT_MASTER.Event_StartDate;
U_EVNT_MASTERParms[6].Value = tobjU_EVNT_MASTER.Event_EndDate;
U_EVNT_MASTERParms[7].Value = tobjU_EVNT_MASTER.Even_Location;
U_EVNT_MASTERParms[8].Value = tobjU_EVNT_MASTER.Event_Status;
U_EVNT_MASTERParms[9].Value = tobjU_EVNT_MASTER.Media_Id_Img;
U_EVNT_MASTERParms[10].Value = tobjU_EVNT_MASTER.COMMENTS;
U_EVNT_MASTERParms[11].Value = tobjU_EVNT_MASTER.Created_Date;
U_EVNT_MASTERParms[12].Value = tobjU_EVNT_MASTER.Updated_Date;
U_EVNT_MASTERParms[13].Value = tobjU_EVNT_MASTER.Created_by;
U_EVNT_MASTERParms[14].Value = tobjU_EVNT_MASTER.Updated_by;
}
public bool InsertU_EVNT_MASTER(U_EVNT_MASTER tobjU_EVNT_MASTER)
{
if (tobjU_EVNT_MASTER != null)
{
//Get the parameter list needed by the given object
SqlParameter[] lParamArray = GetParameters(tobjU_EVNT_MASTER);
SetParameters(lParamArray, tobjU_EVNT_MASTER);
//Get the connection
SqlConnection con = General.GetConnection();
if (con == null)
{
//Connection is not created
return(false);
}
//Execute the insertion
int i = SqlHelper.ExecuteNonQuery(
con,
CommandType.Text,
SQL_INSERT_U_EVNT_MASTER,
lParamArray);
//Dispose the Sql connection
con.Dispose();
if (i == 1)
{
//Done and insert the object to the table
return(true);
}
else
{
//Fail to execute the insertion
return(false);
}
}
else
{
//No object found to insert
return(false);
}
}
public int GetUpdateEvent(Event eve)
{
U_EVNT_MASTERDAL eveDAL = new U_EVNT_MASTERDAL();
U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL();
U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER();
U_EVNT_MASTER NewEveObj = new U_EVNT_MASTER();
var OldEveObj = eveDAL.GetSingleEventDetailsDb(eve.Event_id);
if (!(eve.Event_PicUrl == "/img/default_event.png") && !(string.IsNullOrEmpty(eve.Event_PicUrl)))
{
imgData.Media_Id = Guid.NewGuid().ToString();
imgData.Media_Type = "Image";
imgData.Media_File_Location = eve.Event_PicUrl;
imgData.Media_Source = " ";
imgData.Media_Oth_Dtl = " ";
imgData.Created_by = eve.Event_Update_by;
imgData.Updated_by = eve.Event_Update_by;
imgData.Created_Date = DateTime.Now;
imgData.Updated_Date = DateTime.Now;
ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData);
NewEveObj.Media_Id_Img = imgData.Media_Id;
}
NewEveObj.Event_Id = string.IsNullOrEmpty(eve.Event_id) ? OldEveObj.Event_id : eve.Event_id;
NewEveObj.Event_Name = string.IsNullOrEmpty(eve.Event_Name) ? OldEveObj.Event_Name : eve.Event_Name;
NewEveObj.Even_Location = string.IsNullOrEmpty(eve.Event_Location) ? OldEveObj.Event_Location : eve.Event_Location;
NewEveObj.Event_Desc = string.IsNullOrEmpty(eve.Event_Desc) ? OldEveObj.Event_Desc : eve.Event_Desc;
NewEveObj.Event_Status = string.IsNullOrEmpty(eve.Event_Status) ? OldEveObj.Event_Status : eve.Event_Status;
NewEveObj.Event_StartDate = eve.Event_StartDate;
NewEveObj.Event_EndDate = eve.Event_EndDate;
NewEveObj.Created_Date = DateTime.Now; //do nothing
NewEveObj.Updated_Date = DateTime.Now;
NewEveObj.Updated_by = eve.Event_Update_by;
NewEveObj.Media_Id_Img = string.IsNullOrEmpty(eve.Event_PicUrl) ? eveDAL.GetEventMediaIdDb(eve.Event_id) : imgData.Media_Id;
return(eveDAL.Update_EventDetailsDb(NewEveObj));
}
public EventDetails Get_EventsDetails(string EventId, string UserId)
{
SqlConnection connection = null;
SqlParameter[] aParms = new SqlParameter[] { new SqlParameter(PARAM_Event_Id, EventId), new SqlParameter(PARAM_Event_Creator_Id, UserId) };
U_EVNT_MASTER omst = new U_EVNT_MASTER();
List <ItemsList> olist = new List <ItemsList>();
EventDetails oevent = new EventDetails();
List <Invites> olist1 = new List <Invites>();
try
{
try
{
connection = General.GetConnection();
}
catch (System.Exception e)
{
Console.Write(e);
return(null);
}
SqlDataReader reader = SqlHelper.ExecuteReader(connection, CommandType.Text, SQL_SELECT_Event_Details, aParms);
while (reader.Read())
{
omst = new U_EVNT_MASTER(
reader.GetString(0),
reader.GetString(1),
reader.GetString(2),
reader.GetString(3),
reader.GetString(4),
reader.GetDateTime(5),
reader.GetDateTime(6),
reader.GetString(7),
reader.GetString(8),
reader.GetString(9),
reader.GetString(10),
reader.GetDateTime(11),
reader.GetDateTime(12),
reader.GetString(13),
reader.GetString(14));
}
if (reader.NextResult())
{
while (reader.Read())
{
olist.Add(new ItemsList(
reader.GetString(0),
reader.GetString(1),
reader.GetDecimal(2),
reader.GetString(3)));
}
}
if (reader.NextResult())
{
while (reader.Read())
{
olist1.Add(new Invites(
reader.GetString(0),
reader.GetString(1),
reader.GetString(2),
reader.GetString(3)));
}
}
reader.Close();
oevent.ItemList = olist.ToArray();
oevent.EventMaster = omst;
oevent.InvitedMembers = olist1.ToArray();
return(oevent);
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(ex.Message);
return(null);
}
finally
{
if (connection != null)
{
connection.Dispose();
}
}
}
