public void CreateQuery(enQuery enQuery_)
{
var objSqlHelper = new SqlHelper();
SqlConnection objSqlConnection = null;
SqlTransaction objSqlTransaction = null;
try
{
using (objSqlConnection = objSqlHelper.GetConnection())
{
objSqlConnection.Open();
using (objSqlTransaction = objSqlConnection.BeginTransaction(IsolationLevel.ReadCommitted))
{
var objDLQuery = new dlQuery(enQuery_);
var AdvertisementImageID = objDLQuery.Create(objSqlTransaction);
foreach (var item in enQuery_.ListOfAdvertisementImages)
{
item.Advertisement_ID = AdvertisementImageID;
var objDLAdvertisementImage = new dlAdvertisementImage(item);
objDLAdvertisementImage.Create();
}
objSqlTransaction.Commit();
}
}
}
catch
{
if (objSqlTransaction != null)
{
objSqlTransaction.Rollback();
}
throw;
}
}
private void ConstructObject(IDataReader dr_, enQuery enQuery_)
{
enQuery_.ID = Convert.ToInt32(dr_["ID"]);
enQuery_.Name = dr_["Name"].ToString();
enQuery_.E_Mail = dr_["E_Mail"].ToString();
enQuery_.Contact = dr_["Contact"].ToString();
enQuery_.Subject = dr_["Subject"].ToString();
enQuery_.Topic_Type = DBNull.Value == dr_["Topic_Type"] ? (int?)null : Convert.ToInt32(dr_["Topic_Type"]);
enQuery_.Message = dr_["Message"].ToString();
enQuery_.File_Name = dr_["File_Name"].ToString();
enQuery_.Type = Convert.ToInt32(dr_["Type"]);
enQuery_.User_ID = Convert.ToInt32(dr_["User_ID"]);
enQuery_.InsertedOn = Convert.ToDateTime(dr_["InsertedOn"]);
enQuery_.ModifiedOn = DBNull.Value == dr_["ModifiedOn"] ? (DateTime?)null : Convert.ToDateTime(dr_["ModifiedOn"]);
}
public ActionResult Advertise(enQuery enQuery_)
{
if (enQuery_.files != null)
{
enQuery_.Type = (int)Query_Type.ADVERTISE;
enQuery_.User_ID = CookieDetail.UserID;
enQuery_.ListOfAdvertisementImages = new List <enAdvertisementImage>();
foreach (var image in enQuery_.files)
{
enQuery_.File_Name = Path.GetFileName(image.FileName);
enQuery_.File_Name = Helper.GetRandomAlphaNumericSMSToken() + "-" + enQuery_.File_Name;
var objENQuery = new blQuery(enQuery_);
try
{
var path = Path.Combine(Server.MapPath(Helper.UserAdvertisementImagePath((int)Session["User_ID"]) + enQuery_.File_Name));
bool exist = Directory.Exists(Server.MapPath(Helper.UserAdvertisementImagePath((int)Session["User_ID"])));
if (!exist)
{
Directory.CreateDirectory(Server.MapPath(Helper.UserAdvertisementImagePath((int)Session["User_ID"])));
}
image.SaveAs(path);
enQuery_.ListOfAdvertisementImages.Add(new enAdvertisementImage {
Name = enQuery_.File_Name
});
}
catch (Exception ex)
{
Log.Error("Hangout.UI.QueryController.Advertise() Error while Create() UserAdvertisementPath Exception: " + ex.ToString());
}
}
var objCBQuery = new cbQuery();
try
{
objCBQuery.createCompleteSection(enQuery_);
}
catch (Exception ex)
{
Log.Error("Hangout.UI.QueryController.Advertise() Error while Create() Query Exception:" + ex.ToString());
}
TempData["ErrorMessage"] = "Message is successfully submitted...";
return(RedirectToAction("advertise"));
}
else
{
return(RedirectToAction("error", "misc"));
}
}
public List <enQuery> ReadAll()
{
var listOfQueries = new List <enQuery>();
using (IDataReader idr = base.Read(_enQuery.ID, _enQuery.Type, _enQuery.User_ID, null, null))
{
while (idr.Read())
{
var objENQuery = new enQuery();
ConstructObject(idr, objENQuery);
listOfQueries.Add(objENQuery);
_enQuery.IsGetSuccess = true;
}
}
return(listOfQueries);
}
public JsonResult QueryConfirmation(int qID, int t_type, int confType)
{
var Point_ = (int)RewardPoints.TOPIC;
var Type_ = (int)RewardType.TOPIC;
if (t_type == 1)
{
Point_ = (int)RewardPoints.IDEA;
Type_ = (int)RewardType.IDEA;
}
if (confType == 1)
{
var objENReward = new enReward()
{
User_ID = qID, Point = Point_, Type = Type_
};
var objBLReward = new blReward(objENReward);
try
{
objBLReward.Create();
}
catch (Exception ex)
{
return(Json("failure", JsonRequestBehavior.AllowGet));
}
}
else
{
var objENQuery = new enQuery()
{
ID = qID
};
var objBLQuery = new blQuery(objENQuery);
try
{
objBLQuery.Delete();
}
catch (Exception ex)
{
return(Json("failure", JsonRequestBehavior.AllowGet));
}
}
return(Json("success", JsonRequestBehavior.AllowGet));
}
public ActionResult ContactUs(enQuery enQuery_)
{
enQuery_.Type = (int)Query_Type.CONTACTUS;
enQuery_.User_ID = CookieDetail.UserID;
var objBLQuery = new blQuery(enQuery_);
try
{
objBLQuery.Create();
}
catch (Exception ex)
{
Log.Error("Hangout.UI.QueryController.ContactUs() Error while Create() Query Exception:-" + ex.ToString());
}
TempData["ErrorMessage"] = "Message is successfully submitted...";
return(RedirectToAction("contactus"));
}
public ActionResult TopicAndIdea()
{
var objENQuery = new enQuery()
{
Type = (int)Query_Type.IDEA
};
var objBLQuery = new blQuery(objENQuery);
List <enQuery> listOfQueries = new List <enQuery>();
try
{
listOfQueries = objBLQuery.ReadAll();
}
catch (Exception ex)
{
}
return(View(listOfQueries));
}
public ActionResult ContactUs()
{
var objENQuery = new enQuery()
{
Type = (int)Query_Type.CONTACTUS
};
var objBLQuery = new blQuery(objENQuery);
List <enQuery> listOfQueries = new List <enQuery>();
try
{
listOfQueries = objBLQuery.ReadAll();
}
catch (Exception ex)
{
}
return(View(listOfQueries));
}
public ActionResult Advertise()
{
var objENQuery = new enQuery()
{
Type = (int)Query_Type.ADVERTISE
};
var objBLQuery = new blQuery(objENQuery);
List <enQuery> listOfQueries = new List <enQuery>();
try
{
listOfQueries = objBLQuery.ReadAll();
}
catch (Exception ex)
{
}
return(View(listOfQueries));
}
public void SetQueryToExit()
{
enCurrent = enQuery.Exit;
}
public void SetQueryToMainMenu()
{
enCurrent = enQuery.MainMenu;
}
public void SetQueryToRestart()
{
enCurrent = enQuery.Restart;
}
public dlQuery(enQuery enQuery_)
: base("Query")
{
this._enQuery = enQuery_;
}
public blQuery(enQuery enQuery_)
{
this._enQuery = enQuery_;
}
public void createCompleteSection(enQuery enQuery_)
{
var objBLQuery = new blQuery(enQuery_);
GetDALReference().CreateQuery(enQuery_);
}
