public void DGetExamTransactionStatus(BEProctor objBEProctor)
{
try
{
SqlParameter[] objSqlParam = new SqlParameter[1];
objSqlParam[0] = new SqlParameter("@I_TransID", SqlDbType.BigInt);
objSqlParam[0].Value = objBEProctor.IntTransID;
objBEProctor.DtResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_GetExamTransactionStatus, objSqlParam).Tables[0];
}
catch (Exception Ex)
{
throw Ex;
}
}
public DataSet ShowFileDetailsdDL(UploadFileSchema objUploadFileSchema)
{
ds = new DataSet();
try
{
conn = SQLHelper.OpenConnection();
SqlParameter[] cmdParameter = new SqlParameter[1];
cmdParameter[0] = new SqlParameter("@RowID", SqlDbType.Int);
cmdParameter[0].Value = objUploadFileSchema.RowId;
//Added By K.P
return(ds = SQLHelper.ExecuteDataset(conn, null, CommandType.StoredProcedure, "Usp_GetUploadFile", cmdParameter));
}
catch (Exception ex) { throw ex; }
finally { SQLHelper.CloseConnection(conn); }
}
public void DGetAuditorProviderDetails(BEAuditor objBEAuditor1)
{
try
{
SqlParameter[] objSqlParam = new SqlParameter[1];
objSqlParam[0] = new SqlParameter("@TransID", SqlDbType.VarChar, 1000);
objSqlParam[0].Value = objBEAuditor1.strTransID;
objBEAuditor1.DsResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Auditor_GetProviderDetails, objSqlParam);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查询该工单是否存在，计算批次
/// </summary>
/// <param name="workNo"></param>
/// <returns></returns>
public Carton queryCartonByWorkno(string workNo)
{
Carton carton = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT uuid,cartonNo,cartonQty,carton_status,capacity_no,packType,rule_no,work_no,cus_no,cus_name,cus_po,po_qty,cus_matno,del_matno,offi_no,ver_no,wo_quantity,completed_qty,model_no,so_order,box_No,special_Field,union_Field,prodLine_val,date_code,batchNo,op_user,create_time,update_user,update_time FROM t_carton_info where work_no=@workNo and del_flag is null limit 1");
MySqlParameter[] parameters =
{
new MySqlParameter("@workNo", MySqlDbType.VarChar, 900),
};
parameters[0].Value = workNo;
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
carton = new Carton();
carton.Uuid = ds.Tables[0].Rows[0]["uuid"].ToString();
carton.CartonNo = ds.Tables[0].Rows[0]["cartonNo"].ToString();
carton.CartonQty = (int)ds.Tables[0].Rows[0]["cartonQty"];
carton.CartonStatus = ds.Tables[0].Rows[0]["carton_status"].ToString();
carton.CapacityNo = ds.Tables[0].Rows[0]["capacity_no"].ToString();
carton.PackType = ds.Tables[0].Rows[0]["packType"].ToString();
carton.Ruleno = ds.Tables[0].Rows[0]["rule_no"].ToString();
carton.Workno = ds.Tables[0].Rows[0]["work_no"].ToString();
carton.Cusno = ds.Tables[0].Rows[0]["cus_no"].ToString();
carton.Cusname = ds.Tables[0].Rows[0]["cus_name"].ToString();
carton.Cuspo = ds.Tables[0].Rows[0]["cus_po"].ToString();
carton.Orderqty = ds.Tables[0].Rows[0]["po_qty"].ToString();
carton.Cusmatno = ds.Tables[0].Rows[0]["cus_matno"].ToString();
carton.Delmatno = ds.Tables[0].Rows[0]["del_matno"].ToString();
carton.Offino = ds.Tables[0].Rows[0]["offi_no"].ToString();
carton.Verno = ds.Tables[0].Rows[0]["ver_no"].ToString();
carton.Woquantity = ds.Tables[0].Rows[0]["wo_quantity"].ToString();
carton.Modelno = ds.Tables[0].Rows[0]["model_no"].ToString();
carton.SoOrder = ds.Tables[0].Rows[0]["so_order"].ToString();
carton.BoxNo = ds.Tables[0].Rows[0]["box_No"].ToString();
carton.SpecialField = ds.Tables[0].Rows[0]["special_Field"].ToString();
carton.UnionField = ds.Tables[0].Rows[0]["union_Field"].ToString();
carton.ProdLineVal = ds.Tables[0].Rows[0]["prodLine_val"].ToString();
carton.Datecode = ds.Tables[0].Rows[0]["date_code"].ToString();
carton.BatchNo = ds.Tables[0].Rows[0]["batchNo"].ToString();
carton.Opuser = ds.Tables[0].Rows[0]["op_user"].ToString();
carton.Createtime = ds.Tables[0].Rows[0]["create_time"].ToString();
carton.Updateser = ds.Tables[0].Rows[0]["update_user"].ToString();
carton.Updatetime = ds.Tables[0].Rows[0]["update_time"].ToString();
}
return(carton);
}
public void DGetProfileExamiKeyDetails(BEUser objBEUser)
{
try
{
SqlParameter[] objSqlParam = new SqlParameter[1];
objSqlParam[0] = new SqlParameter("@I_TransId", SqlDbType.BigInt);
objSqlParam[0].Value = objBEUser.IntTransID;
objBEUser.DtResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, "USP_Common_GetProfileExamiKeyDetails", objSqlParam).Tables[0];
}
catch (Exception Ex)
{
throw Ex;
}
}
public void DGetStudentDetails(BEAuditor objBEAuditor)
{
try
{
SqlParameter[] objSqlParam = new SqlParameter[1];
objSqlParam[0] = new SqlParameter("@StudentID", SqlDbType.Int);
objSqlParam[0].Value = objBEAuditor.IntStudentID;
objBEAuditor.DtResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Common_ViewStudentDetails, objSqlParam).Tables[0];
}
catch (Exception Ex)
{
throw Ex;
}
}
public DataSet ShowUploadFileDL(UploadFileSchema objUploadFileSchema)
{
DataSet ds = new DataSet();
try
{
conn = SQLHelper.OpenConnection();
SqlParameter[] cmdParameter = new SqlParameter[2];
cmdParameter[0] = new SqlParameter("@FileCategory", SqlDbType.Int);
cmdParameter[0].Value = objUploadFileSchema.FileCategory;
cmdParameter[1] = new SqlParameter("@Flag", SqlDbType.VarChar);
cmdParameter[1].Value = "Select";
return(ds = SQLHelper.ExecuteDataset(conn, null, CommandType.StoredProcedure, "Sp_UploadFile", cmdParameter));
}
catch (Exception ex) { throw ex; }
finally { SQLHelper.CloseConnection(conn); }
}
public void DGetTimeZone(BEUser objBEUser)
{
try
{
SqlParameter[] objSqlParam = new SqlParameter[1];
objSqlParam[0] = new SqlParameter("@I_StudentID", SqlDbType.Int);
objSqlParam[0].Value = objBEUser.IntUserID;
objBEUser.DsResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Common_GetTimeZoneList, objSqlParam);
}
catch (Exception Ex)
{
throw Ex;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.tbMessage GetModelTran(int id, SqlTransaction transaction)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id, messagetitle, messagecontent, createtime, userid, visitcount ");
strSql.Append(" from tbMessage ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Util.MyUtil.PrintSql(strSql.ToString());
Model.tbMessage model = new Model.tbMessage();
DataSet ds = SQLHelper.ExecuteDataset(transaction, CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.messagetitle = ds.Tables[0].Rows[0]["messagetitle"].ToString();
model.messagecontent = ds.Tables[0].Rows[0]["messagecontent"].ToString();
if (ds.Tables[0].Rows[0]["createtime"].ToString() != "")
{
model.createtime = DateTime.Parse(ds.Tables[0].Rows[0]["createtime"].ToString());
}
if (ds.Tables[0].Rows[0]["userid"].ToString() != "")
{
model.userid = int.Parse(ds.Tables[0].Rows[0]["userid"].ToString());
}
if (ds.Tables[0].Rows[0]["visitcount"].ToString() != "")
{
model.visitcount = int.Parse(ds.Tables[0].Rows[0]["visitcount"].ToString());
}
return(model);
}
else
{
return(null);
}
}
public void DGetExamDetails(BEProctor objBEProctor)
{
try
{
SqlParameter[] objSqlParam = new SqlParameter[2];
objSqlParam[0] = new SqlParameter("@I_TransID", SqlDbType.BigInt);
objSqlParam[0].Value = objBEProctor.IntExamID1;
objSqlParam[1] = new SqlParameter("@I_UserID", SqlDbType.Int);
objSqlParam[1].Value = objBEProctor.IntUserID;
objBEProctor.DsResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Proctor_GetExamDetails, objSqlParam);
}
catch (Exception Ex)
{
throw Ex;
}
}
public string queryRuleByID(string uuid)
{
string ruleNo = "";
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT rule_no FROM t_rule_info where uuid =@uuid");
MySqlParameter[] parameters =
{
new MySqlParameter("@uuid", MySqlDbType.VarChar, 900)
};
parameters[0].Value = uuid;
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ruleNo = ds.Tables[0].Rows[0]["rule_no"].ToString();
}
return(ruleNo);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.tbGrant GetModelTran(int id, SqlTransaction transaction)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id, userid, subjectid, classid ");
strSql.Append(" from tbGrant ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Util.MyUtil.PrintSql(strSql.ToString());
Model.tbGrant model = new Model.tbGrant();
DataSet ds = SQLHelper.ExecuteDataset(transaction, CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["userid"].ToString() != "")
{
model.userid = int.Parse(ds.Tables[0].Rows[0]["userid"].ToString());
}
if (ds.Tables[0].Rows[0]["subjectid"].ToString() != "")
{
model.subjectid = int.Parse(ds.Tables[0].Rows[0]["subjectid"].ToString());
}
if (ds.Tables[0].Rows[0]["classid"].ToString() != "")
{
model.classid = int.Parse(ds.Tables[0].Rows[0]["classid"].ToString());
}
return(model);
}
else
{
return(null);
}
}
public void DProcessedExamRequest(BEAuditor objBEAuditor)
{
try
{
SqlParameter[] objSqlParam = new SqlParameter[1];
objSqlParam[0] = new SqlParameter("@I_UserID", SqlDbType.Int);
objSqlParam[0].Value = objBEAuditor.IntUserID;
//objSqlParam[1] = new SqlParameter("@I_Period", SqlDbType.Int);
//objSqlParam[1].Value = objBEAuditor.IntPeriod;
objBEAuditor.DtResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Auditor_ProcessedExamRequest, objSqlParam).Tables[0];
}
catch (Exception Ex)
{
throw Ex;
}
}
public void GetAutoProctorInbox(BEProctor objBEProctor)
{
try
{
SqlParameter[] objSqlParam = new SqlParameter[1];
objSqlParam[0] = new SqlParameter("@I_UserID", SqlDbType.Int);
objSqlParam[0].Value = objBEProctor.IntUserID;
//objBEAuditor.dtResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Auditor_Inbox).Tables[0];
//objBEAuditor.dtResult1 = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Auditor_Inbox).Tables[1];
objBEProctor.objDs = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Proctor_AutoProctorInbox, objSqlParam);
}
catch (Exception Ex)
{
throw Ex;
}
}
public List <Pallet> queryPalletsByPalletkNo(string palletNo)
{
List <Pallet> pallets = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT uuid,palletNo,palletQty,batchNo,capacity_no,model_no,rule_no,cus_no,cus_matno,del_matno,cus_name,cus_po,so_order,vehicle_No,op_user,create_time,update_user,update_time FROM t_pallet_info where palletNo =@palletNo and del_flag is null order by create_time");
MySqlParameter[] parameters =
{
new MySqlParameter("@palletNo", MySqlDbType.VarChar, 900)
};
parameters[0].Value = palletNo;
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
pallets = new List <Pallet>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
Pallet pallet = new Pallet();;
pallet.Uuid = dr["uuid"].ToString();
pallet.PalletNo = dr["palletNo"].ToString();
pallet.PalletQty = (int)dr["palletQty"];
pallet.BatchNo = dr["batchNo"].ToString();
pallet.CapacityNo = dr["capacity_no"].ToString();
pallet.Modelno = dr["model_no"].ToString();
pallet.Ruleno = dr["rule_no"].ToString();
pallet.Cusno = dr["cus_no"].ToString();
pallet.Cusname = dr["cus_name"].ToString();
pallet.Cuspo = dr["cus_po"].ToString();
pallet.Delmatno = dr["del_matno"].ToString();
pallet.Cusmatno = dr["cus_matno"].ToString();
pallet.SoOrder = dr["so_order"].ToString();
pallet.VehicleNo = dr["vehicle_No"].ToString();
pallet.Opuser = dr["op_user"].ToString();
pallet.Createtime = dr["create_time"].ToString();
pallet.Updateser = dr["update_user"].ToString();
pallet.Updatetime = dr["update_time"].ToString();
pallets.Add(pallet);
}
}
return(pallets);
}
public DataSet GetAuditTrail()
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "GetUserSession", null))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public void DGetProctorExams(BEProctor objBEProctor)
{
try
{
SqlParameter[] objSqlParam = new SqlParameter[3];
objSqlParam[0] = new SqlParameter("@V_Date", SqlDbType.DateTime);
objSqlParam[0].Value = Convert.ToDateTime(objBEProctor.dtDate);
objSqlParam[1] = new SqlParameter("@I_TransactionType", SqlDbType.Int);
objSqlParam[1].Value = 0;
objSqlParam[2] = new SqlParameter("@UserID", SqlDbType.Int);
objSqlParam[2].Value = objBEProctor.IntUserID;
objBEProctor.DtResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Proctor_ValidateStudentIdentity, objSqlParam).Tables[0];
}
catch (Exception Ex)
{
throw Ex;
}
}
public DataSet GetPlaceHolderList()
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "Usp_GetPlaceHolderList", null))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public void DGetComments(BEAuditor objBEAuditor)
{
try
{
SqlParameter[] objSqlParam = new SqlParameter[2];
objSqlParam[0] = new SqlParameter("@CommentID", SqlDbType.Int);
objSqlParam[0].Value = objBEAuditor.IntCommentID;
objSqlParam[1] = new SqlParameter("@UserID", SqlDbType.Int);
objSqlParam[1].Value = objBEAuditor.IntUserID;
objBEAuditor.DsResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, "USP_Auditor_GetEditComments", objSqlParam);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetSubAlbum()
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "Sp_DisplaySubAlbums", null))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public DataTable FetchVideo()
{
try
{
conn = SQLHelper.OpenConnection();
sqlQuery = "Select * from Video order by VideoID desc";
ds = SQLHelper.ExecuteDataset(conn, null, CommandType.Text, sqlQuery);
return(ds.Tables[0]);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
SQLHelper.CloseConnection(conn);
}
}
public DataSet GetComplaintsDetails()
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "usp_GetComplaintDetails", null))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public DataTable FetchAudioList()
{
try
{
conn = SQLHelper.OpenConnection();
sqlQuery = "Select VideoID, VideoName, VideoPath, '../../Site/Upload/Video/' + ImagePath as VideoImage from Video where Type='Audio' order by VideoName";
ds = SQLHelper.ExecuteDataset(conn, null, CommandType.Text, sqlQuery);
return(ds.Tables[0]);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
SQLHelper.CloseConnection(conn);
}
}
public void DGetProctorExamLookUp(BEProctor objBEProctor)
{
try
{
SqlParameter[] objSqlParam = new SqlParameter[4];
objSqlParam[0] = new SqlParameter("@V_ExamName", SqlDbType.VarChar, 100);
objSqlParam[0].Value = objBEProctor.strExamName;
objSqlParam[1] = new SqlParameter("@v_Name", SqlDbType.VarChar, 100);
objSqlParam[1].Value = objBEProctor.strStudentName;
objSqlParam[2] = new SqlParameter("@I_TransID", SqlDbType.BigInt);
objSqlParam[2].Value = objBEProctor.IntTransID;
objSqlParam[3] = new SqlParameter("@I_UserID", SqlDbType.Int);
objSqlParam[3].Value = objBEProctor.IntUserID;
objBEProctor.DtResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Proctor_GetProctorExamLookUp, objSqlParam).Tables[0];
}
catch (Exception Ex)
{
throw Ex;
}
}
/// <summary>
/// 根據箱號查詢裝箱單信息
/// </summary>
/// <param name="cartonNo"></param>
/// <returns></returns>
public QualityInfo queryQualityInfoByNo(string qualityNo)
{
QualityInfo qualityInfo = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT uuid,qualiatyNo,woNo,startTime,endTime,duringTime,deliverMan,status,op_user,create_time FROM t_qualityInfo where qualiatyNo=@qualityNo and del_flag is null");
MySqlParameter[] parameters =
{
new MySqlParameter("@qualityNo", MySqlDbType.VarChar, 900),
};
parameters[0].Value = qualityNo;
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
qualityInfo = new QualityInfo();
qualityInfo.Uuid = ds.Tables[0].Rows[0]["uuid"].ToString();
qualityInfo.QualiatyNo = ds.Tables[0].Rows[0]["qualiatyNo"].ToString();
qualityInfo.WoNo = ds.Tables[0].Rows[0]["woNo"].ToString();
if (ds.Tables[0].Rows[0]["startTime"] != null && !(ds.Tables[0].Rows[0]["startTime"].ToString().Trim().Equals("")))
{
qualityInfo.StartTime = (DateTime)ds.Tables[0].Rows[0]["startTime"];
}
if (ds.Tables[0].Rows[0]["endTime"] != null && !(ds.Tables[0].Rows[0]["endTime"].ToString().Trim().Equals("")))
{
qualityInfo.EndTime = (DateTime)ds.Tables[0].Rows[0]["endTime"];
}
if (ds.Tables[0].Rows[0]["duringTime"] != null && !(ds.Tables[0].Rows[0]["duringTime"].ToString().Trim().Equals("")))
{
qualityInfo.DuringTime = (long)ds.Tables[0].Rows[0]["duringTime"];
}
qualityInfo.DeliverMan = ds.Tables[0].Rows[0]["deliverMan"].ToString();
qualityInfo.Status = ds.Tables[0].Rows[0]["status"].ToString();
qualityInfo.Opuser = ds.Tables[0].Rows[0]["op_user"].ToString();
qualityInfo.Createtime = ds.Tables[0].Rows[0]["create_time"].ToString();
}
return(qualityInfo);
}
public DataTable FetchVideoPath(String VideoID)
{
try
{
conn = SQLHelper.OpenConnection();
SqlParameter[] cmdParameter = new SqlParameter[1];
cmdParameter[0] = new SqlParameter("@VideoID", SqlDbType.BigInt);
cmdParameter[0].Value = VideoID;
sqlQuery = "Select VideoPath from Video where VideoID =@VideoID";
ds = SQLHelper.ExecuteDataset(conn, null, CommandType.Text, sqlQuery, cmdParameter);
return(ds.Tables[0]);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
SQLHelper.CloseConnection(conn);
}
}
public DataSet GetVisitorCount(BannerControlSchema objBannerControlSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@UserName", SqlDbType.NVarChar);
param[0].Value = objBannerControlSchema.UserName;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "SP_VISITORCOUNT", param))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public DataSet GetUCBreadCrumDataforQuickMenu(BannerControlSchema objBannerControlSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@MenuID", SqlDbType.Int);
param[0].Value = objBannerControlSchema.MenuID;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "procGetBreadCrumofQuickMenuData", param))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public DataTable FetchRecord(string id)
{
try
{
conn = SQLHelper.OpenConnection();
SqlParameter[] cmdParameter = new SqlParameter[1];
cmdParameter[0] = new SqlParameter("@id", SqlDbType.NVarChar);
cmdParameter[0].Value = id;
sqlQuery = "Select * from Video where VideoID=@id";
ds = SQLHelper.ExecuteDataset(conn, null, CommandType.Text, sqlQuery, cmdParameter);
return(ds.Tables[0]);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
SQLHelper.CloseConnection(conn);
}
}
public DataTable FetchVideoByLangId(int langid)
{
try
{
conn = SQLHelper.OpenConnection();
SqlParameter[] cmdParameter = new SqlParameter[1];
cmdParameter[0] = new SqlParameter("@Langid", SqlDbType.Int);
cmdParameter[0].Value = langid;
sqlQuery = "Select * from Video where langid=@Langid order by VideoID desc";
ds = SQLHelper.ExecuteDataset(conn, null, CommandType.Text, sqlQuery, cmdParameter);
return(ds.Tables[0]);
}
catch (Exception)
{
return(null);
}
finally
{
ds = null;
SQLHelper.CloseConnection(conn);
}
}
