/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void imgbtnShowCalendar_Click(object sender, ImageClickEventArgs e)
{
ImageButton ib = (ImageButton)sender;
if (ib.ID == "imgbtnShowGCalendar")
{
ViewState["TypeSpecifiedDate"] = "G";
ddlYears.Items.Clear();
ddlMonths.Items.Clear();
DateFun.PopulateGreYear(ref ddlYears);
DateFun.PopulateGreMonth(ref ddlMonths);
}
else if (ib.ID == "imgbtnShowHCalendar")
{
ViewState["TypeSpecifiedDate"] = "H";
ddlYears.Items.Clear();
ddlMonths.Items.Clear();
DateFun.PopulateHijYear(ref ddlYears);
DateFun.PopulateHijMonth(ref ddlMonths);
}
Changedate(ViewState["TypeSpecifiedDate"].ToString());
CssStyleCollection pnlCalendarStyle = this.pnlCalendar.Style;
string DISPLAY = pnlCalendarStyle["DISPLAY"];
if (DISPLAY == "none")
{
this.pnlCalendar.Attributes.Add("style", "POSITION: absolute");
}
else
{
this.pnlCalendar.Attributes.Add("style", "DISPLAY: none; POSITION: absolute");
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void BirthDateValidate_ServerValidate(Object source, ServerValidateEventArgs e)
{
try
{
if (source.Equals(cvcalBirthDate))
{
if (string.IsNullOrEmpty(CalBirthDate.getDate()))
{
General.ValidMsg(this, ref cvcalBirthDate, false, "Birth Date is required", "تاريخ الميلاد مطلوب");
e.IsValid = false;
return;
}
else
{
int iStartDate = DateFun.ConvertDateTimeToInt(FormSession.DateType, CalBirthDate.getDate());
int iEndDate = DateFun.ConvertDateTimeToInt(FormSession.DateType, (DateFun.ToAnyFormat(FormSession.DateType, DateTime.Now)));
General.ValidMsg(this, ref cvcalBirthDate, true, "Birthday greater than today's date", "تاريخ الميلاد أكبر من تاريخ اليوم");
if (iStartDate > iEndDate)
{
e.IsValid = false;
}
}
}
}
catch { e.IsValid = false; }
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void setTodayDate()
{
try
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
string DType = "Gregorian";
if (DateType == "S")
{
DType = Session["DateFormat"].ToString();
}
else if (DateType == "G")
{
DType = "Gregorian";
}
else if (DateType == "H")
{
DType = "Hijri";
}
this.txtType.Text = DateType;
if (DType == "Gregorian")
{
this.txtDate.Text = String.Format("{0:dd/MM/yyyy}", DateTime.Now);
}
if (DType == "Hijri")
{
this.txtDate.Text = DateFun.GrnToHij(DateTime.Now).ToString();
}
}
catch (Exception EX) { ClearDate(); }
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void DateValidate_ServerValidate(Object source, ServerValidateEventArgs e)
{
try
{
if (source.Equals(cvCalStartDateEmpty))
{
if (String.IsNullOrEmpty(calStartDate.getDate()))
{
e.IsValid = false;
}
else
{
e.IsValid = true;
}
}
else if (source.Equals(cvCompareDates))
{
if (!String.IsNullOrEmpty(calStartDate.getDate()) && !String.IsNullOrEmpty(calEndDate.getDate()))
{
int iStartDate = DateFun.ConvertDateTimeToInt(FormSession.DateType, calStartDate.getDate());
int iEndDate = DateFun.ConvertDateTimeToInt(FormSession.DateType, calEndDate.getDate());
if (iStartDate > iEndDate)
{
e.IsValid = false;
}
else
{
e.IsValid = true;
}
}
}
}
catch { e.IsValid = false; }
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void DateValidate_ServerValidate(Object source, ServerValidateEventArgs e)
{
try
{
if (source.Equals(cvcalStartDate))
{
if (string.IsNullOrEmpty(calStartdate.getDate()))
{
General.ValidMsg(this, ref cvcalStartDate, false, "Start Date is required", "تاريخ البداية مطلوب");
e.IsValid = false;
return;
}
if (!string.IsNullOrEmpty(calStartdate.getDate()) && !String.IsNullOrEmpty(calEnddate.getDate()))
{
int iStartDate = DateFun.ConvertDateTimeToInt("Gregorian", calStartdate.getDate());
int iEndDate = DateFun.ConvertDateTimeToInt("Gregorian", calEnddate.getDate());
if (iStartDate > iEndDate)
{
General.ValidMsg(this, ref cvcalStartDate, true, "start date more than end date!", "تاريخ الإصدار أكبر من تاريخ الإنتهاء");
e.IsValid = false;
return;
}
}
}
}
catch { e.IsValid = false; }
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
static public void InsertError(string errorPage, string errorFunction)
{
string userID = ((string)HttpContext.Current.Session["UserName"]);
string userRole = Convert.ToString(HttpContext.Current.Session["Role"]);
//string errorPage = "EmployeMaster.aspx";
//string errorFunction = "btnSaveInsert";
DateTime dt = DateTime.Now;
StringBuilder errorQuery = new StringBuilder();
errorQuery.Append("INSERT INTO [ErrorLog]([ErrorPage],[ErrorFunction],[ErrorDate] ,[LoginUserID],[LoginUserRole]) VALUES ('" + errorPage + "','" + errorFunction + "'");
errorQuery.Append(",'" + DateFun.HijToGrn(DateFun.GrnToHij(dt)) + "','" + userID + "','" + userRole + "')");
Int32 returnValue = ExecuteData(errorQuery.ToString());
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public string SelectDateFormat(string pDateType, string pDate)
{
//DateTime Date = Convert.ToDateTime(pDate);
string strValue = "";
if (pDateType == "Gregorian")
{
strValue = DateFun.strTodt(String.Format("{0:dd/MM/yyyy}", pDate)).ToShortDateString();
}
else if (pDateType == "Hijri")
{
strValue = DateFun.HijToGrn(pDate).ToShortDateString();
}
return(strValue);
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void HireDateValidate_ServerValidate(Object source, ServerValidateEventArgs e)
{
try
{
if (source.Equals(cvCalHireDate))
{
if (!string.IsNullOrEmpty(CalHireDate.getDate()))
{
int iStartDate = DateFun.ConvertDateTimeToInt(FormSession.DateType, CalHireDate.getDate());
int iEndDate = DateFun.ConvertDateTimeToInt(FormSession.DateType, (DateFun.ToAnyFormat(FormSession.DateType, DateTime.Now)));
General.ValidMsg(this, ref cvCalHireDate, true, "Hire date greater than today's date", "تاريخ التعيين أكبر من تاريخ اليوم");
if (iStartDate > iEndDate)
{
e.IsValid = false;
}
}
}
}
catch { e.IsValid = false; }
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public static string GrdDisplayDateTime(object pDate, object pType)
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
string DType = "Gregorian";
if (pDate != DBNull.Value && pType != DBNull.Value)
{
DateTime date = (DateTime)pDate;
string Time = fd(Grn.GetHour(date).ToString()) + ":" + fd(Grn.GetMinute(date).ToString());
if (pType.ToString() == "S")
{
DType = HttpContext.Current.Session["DateFormat"].ToString();
}
else if (pType.ToString() == "G")
{
DType = "Gregorian";
}
else if (pType.ToString() == "H")
{
DType = "Hijri";
}
if (DType == "Gregorian")
{
return(fd(Grn.GetDayOfMonth(date).ToString()) + "/" + fd(Grn.GetMonth(date).ToString()) + "/" + fd(Grn.GetYear(date).ToString()) + " " + Time);
}
if (DType == "Hijri")
{
return(DateFun.GrnToHij(Convert.ToDateTime(pDate)).ToString() + " " + Time);
}
}
else
{
return(null);
}
return(null);
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public string GetCardInfo(string pCardID)
{
try
{
dt = DBFun.FetchData("SELECT ExpiryDate FROM CardMaster WHERE CardID = " + pCardID + "");
if (!DBFun.IsNullOrEmpty(dt))
{
if (dt.Rows[0]["ExpiryDate"] != DBNull.Value)
{
if (HttpContext.Current.Session["DateFormat"].ToString() == "Gregorian")
{
return((Convert.ToDateTime(dt.Rows[0]["ExpiryDate"])).ToString("dd/MM/yyyy"));
}
else if (HttpContext.Current.Session["DateFormat"].ToString() == "Hijri")
{
return(Convert.ToString(DateFun.GrnToHij(Convert.ToDateTime(dt.Rows[0]["ExpiryDate"]))));
}
}
}
return(string.Empty);
}
catch (Exception e1) { return(string.Empty); }
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void setDBDate(object pDate, string pType)
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
string DType = "Gregorian";
if (pDate != DBNull.Value && !string.IsNullOrEmpty(pType))
{
DateTime date = (DateTime)pDate;
if (pType == "S")
{
DType = Session["DateFormat"].ToString();
}
else if (pType == "G")
{
DType = "Gregorian";
}
else if (pType == "H")
{
DType = "Hijri";
}
this.txtType.Text = pType;
if (DType == "Gregorian")
{
this.txtDate.Text = fd(Grn.GetDayOfMonth(date).ToString()) + "/" + fd(Grn.GetMonth(date).ToString()) + "/" + fd(Grn.GetYear(date).ToString());
}
if (DType == "Hijri")
{
this.txtDate.Text = DateFun.GrnToHij(Convert.ToDateTime(pDate)).ToString();
}
}
else
{
ClearDate();
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public bool Update(VisitorsPro pro)
{
SqlCommand sqlCommand = new SqlCommand("dbo.[VisitorsCard_Update]", MainConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@VisCardID", IntDB, 10, IN, false, 0, 0, "", DRV, pro.VisCardID));
sqlCommand.Parameters.Add(new SqlParameter("@VisIdentityNo", VchDB, 100, IN, false, 0, 0, "", DRV, pro.VisIdentityNo));
sqlCommand.Parameters.Add(new SqlParameter("@VisNameEn", VchDB, 500, IN, false, 0, 0, "", DRV, pro.VisNameEn));
sqlCommand.Parameters.Add(new SqlParameter("@VisNameAr", VchDB, 500, IN, false, 0, 0, "", DRV, pro.VisNameAr));
sqlCommand.Parameters.Add(new SqlParameter("@VisMobileNo", VchDB, 200, IN, false, 0, 0, "", DRV, pro.VisMobileNo));
sqlCommand.Parameters.Add(new SqlParameter("@VisRegion1", BitDB, 1, IN, false, 0, 0, "", DRV, pro.VisRegion1));
sqlCommand.Parameters.Add(new SqlParameter("@VisRegion2", BitDB, 1, IN, false, 0, 0, "", DRV, pro.VisRegion2));
sqlCommand.Parameters.Add(new SqlParameter("@VisRegion3", BitDB, 1, IN, false, 0, 0, "", DRV, pro.VisRegion3));
sqlCommand.Parameters.Add(new SqlParameter("@VisRegion4", BitDB, 1, IN, false, 0, 0, "", DRV, pro.VisRegion4));
sqlCommand.Parameters.Add(new SqlParameter("@VisRegion5", BitDB, 1, IN, false, 0, 0, "", DRV, pro.VisRegion5));
sqlCommand.Parameters.Add(new SqlParameter("@VisRegion6", BitDB, 1, IN, false, 0, 0, "", DRV, pro.VisRegion6));
sqlCommand.Parameters.Add(new SqlParameter("@VisRegion7", BitDB, 1, IN, false, 0, 0, "", DRV, pro.VisRegion7));
sqlCommand.Parameters.Add(new SqlParameter("@VisRegion8", BitDB, 1, IN, false, 0, 0, "", DRV, pro.VisRegion8));
sqlCommand.Parameters.Add(new SqlParameter("@VisRegion9", BitDB, 1, IN, false, 0, 0, "", DRV, pro.VisRegion9));
sqlCommand.Parameters.Add(new SqlParameter("@StartDate", DtDB, 14, IN, false, 0, 0, "", DRV, DateFun.SaveDB('S', pro.StartDate)));
sqlCommand.Parameters.Add(new SqlParameter("@ExpiryDate", DtDB, 14, IN, false, 0, 0, "", DRV, DateFun.SaveDB('S', pro.ExpiryDate)));
sqlCommand.Parameters.Add(new SqlParameter("@TmpID", IntDB, 10, IN, false, 0, 0, "", DRV, pro.TmpID));
sqlCommand.Parameters.Add(new SqlParameter("@Description", VchDB, 1000, IN, false, 0, 0, "", DRV, pro.Description));
sqlCommand.Parameters.Add(new SqlParameter("@CardStatus", IntDB, 10, IN, false, 0, 0, "", DRV, pro.CardStatus));
//sqlCommand.Parameters.Add(new SqlParameter("@isPrinted", BitDB, 10, IN, false, 0, 0, "", DRV, pro.isPrinted));
if (pro.VisImageLength > 0)
{
sqlCommand.Parameters.Add(new SqlParameter("@VisImage", SqlDbType.Image, 1000000, IN, false, 0, 0, "", DRV, pro.VisImage));
sqlCommand.Parameters.Add(new SqlParameter("@VisImageContentType", VchDB, 100, IN, false, 0, 0, "", DRV, pro.VisImageContentType));
sqlCommand.Parameters.Add(new SqlParameter("@VisImageLength", SqlDbType.BigInt, 100, IN, false, 0, 0, "", DRV, pro.VisImageLength.ToString()));
}
sqlCommand.Parameters.Add(new SqlParameter("@TransactionBy", VchDB, 50, IN, false, 0, 0, "", DRV, pro.TransactionBy));
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public bool Insert(ErrorLogPro pro)
{
SqlCommand sqlCommand = new SqlCommand("dbo.[ErrorLog_Insert]", MainConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@ErrorPage", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.ErrorPage));
sqlCommand.Parameters.Add(new SqlParameter("@ErrorFunction", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.ErrorFunction));
sqlCommand.Parameters.Add(new SqlParameter("@ErrorMessage", SqlDbType.VarChar, 5000, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.ErrorMessage));
sqlCommand.Parameters.Add(new SqlParameter("@ErrorDate", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DateFun.SaveDB('S', pro.ErrorDate)));
sqlCommand.Parameters.Add(new SqlParameter("@LoginUserID", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.LoginUserID));
sqlCommand.Parameters.Add(new SqlParameter("@LoginUserRole", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.LoginUserRole));
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public bool Insert(EmployeePro pro)
{
SqlCommand sqlCommand = new SqlCommand("dbo.[Employee_Insert]", MainConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@EmpID", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpID));
sqlCommand.Parameters.Add(new SqlParameter("@EmpType", SqlDbType.VarChar, 3, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpType));
sqlCommand.Parameters.Add(new SqlParameter("@EmpNameAr", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpNameAr));
sqlCommand.Parameters.Add(new SqlParameter("@EmpNameEn", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpNameEn));
sqlCommand.Parameters.Add(new SqlParameter("@NatID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.NatID));
sqlCommand.Parameters.Add(new SqlParameter("@EmpBirthDate", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DateFun.SaveDB('S', pro.EmpBirthDate)));
sqlCommand.Parameters.Add(new SqlParameter("@EmpJobTitleAr", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpJobTitleAr));
sqlCommand.Parameters.Add(new SqlParameter("@EmpJobTitleEn", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpJobTitleEn));
sqlCommand.Parameters.Add(new SqlParameter("@EmpNationalID", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpNationalID));
sqlCommand.Parameters.Add(new SqlParameter("@EmpBloodGroup", SqlDbType.VarChar, 3, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpBloodGroup));
sqlCommand.Parameters.Add(new SqlParameter("@CompID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.CompID));
sqlCommand.Parameters.Add(new SqlParameter("@SecID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.SecID));
if (!String.IsNullOrEmpty(pro.EmpHireDate))
{
sqlCommand.Parameters.Add(new SqlParameter("@EmpHireDate", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DateFun.SaveDB('S', pro.EmpHireDate)));
}
sqlCommand.Parameters.Add(new SqlParameter("@EmpGender", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpGender));
sqlCommand.Parameters.Add(new SqlParameter("@EmpMobileNo", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpMobileNo));
sqlCommand.Parameters.Add(new SqlParameter("@EmpEmailID", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpEmailID));
if (pro.EmpImageLength > 0)
{
sqlCommand.Parameters.Add(new SqlParameter("@Image", SqlDbType.Image, 1000000, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpImage));
sqlCommand.Parameters.Add(new SqlParameter("@ImageContentType", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpImageContentType));
sqlCommand.Parameters.Add(new SqlParameter("@ImageLength", SqlDbType.BigInt, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpImageLength.ToString()));
}
sqlCommand.Parameters.Add(new SqlParameter("@TransactionBy", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.TransactionBy));
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public bool Update(AppUsersPro pro)
{
SqlCommand sqlCommand = new SqlCommand("dbo.[AppUsers_Update]", MainConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@UsrLoginID", VchDB, 50, IN, false, 0, 0, "", DRV, pro.UsrLoginID));
sqlCommand.Parameters.Add(new SqlParameter("@UsrPassword", VchDB, 100, IN, false, 0, 0, "", DRV, pro.UsrPassword));
sqlCommand.Parameters.Add(new SqlParameter("@UsrFullName", VchDB, 200, IN, false, 0, 0, "", DRV, pro.UsrFullName));
if (!string.IsNullOrEmpty(pro.UsrStartDate))
{
sqlCommand.Parameters.Add(new SqlParameter("@UsrStartDate", DtDB, 14, IN, false, 0, 0, "", DRV, DateFun.SaveDB(pro.UsrStartDateType, pro.UsrStartDate)));
sqlCommand.Parameters.Add(new SqlParameter("@UsrStartDateType", ChrDB, 1, IN, false, 0, 0, "", DRV, pro.UsrStartDateType));
}
if (!string.IsNullOrEmpty(pro.UsrExpiryDate))
{
sqlCommand.Parameters.Add(new SqlParameter("@UsrExpiryDate", DtDB, 14, IN, false, 0, 0, "", DRV, DateFun.SaveDB(pro.UsrExpiryDateType, pro.UsrExpiryDate)));
sqlCommand.Parameters.Add(new SqlParameter("@UsrExpiryDateType", ChrDB, 1, IN, false, 0, 0, "", DRV, pro.UsrExpiryDateType));
}
sqlCommand.Parameters.Add(new SqlParameter("@UsrStatus", BitDB, 1, IN, false, 0, 0, "", DRV, pro.UsrStatus));
sqlCommand.Parameters.Add(new SqlParameter("@UsrPermission", VchDB, 8000, IN, false, 0, 0, "", DRV, pro.UsrPermission));
sqlCommand.Parameters.Add(new SqlParameter("@UsrLanguage", VchDB, 50, IN, false, 0, 0, "", DRV, pro.UsrLanguage));
sqlCommand.Parameters.Add(new SqlParameter("@UsrEmailID", VchDB, 200, IN, false, 0, 0, "", DRV, pro.UsrEmailID));
sqlCommand.Parameters.Add(new SqlParameter("@UsrEmpID", VchDB, 100, IN, false, 0, 0, "", DRV, pro.UsrEmpID));
sqlCommand.Parameters.Add(new SqlParameter("@UsrDescription", VchDB, 8000, IN, false, 0, 0, "", DRV, pro.UsrDescription));
sqlCommand.Parameters.Add(new SqlParameter("@TransactionBy", VchDB, 50, IN, false, 0, 0, "", DRV, pro.TransactionBy));
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public int Insert(CardsPro pro)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[Cards_Insert]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@CardID", SqlDbType.Int, 10, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, pro.CardID));
sqlCommand.Parameters.Add(new SqlParameter("@EmpID", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpID));
sqlCommand.Parameters.Add(new SqlParameter("@IsID", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.IsID));
sqlCommand.Parameters.Add(new SqlParameter("@CardCount", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.CardCount));
sqlCommand.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.DateTime, 14, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DateFun.SaveDB('S', pro.StartDate)));
sqlCommand.Parameters.Add(new SqlParameter("@ExpiryDate", SqlDbType.DateTime, 14, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DateFun.SaveDB('S', pro.ExpiryDate)));
sqlCommand.Parameters.Add(new SqlParameter("@TmpID", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.TmpID));
sqlCommand.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 250, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.Description));
sqlCommand.Parameters.Add(new SqlParameter("@CardStatus", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.CardStatus));
sqlCommand.Parameters.Add(new SqlParameter("@InActiveStatus", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.InActiveStatus));
sqlCommand.Parameters.Add(new SqlParameter("@IsApproved", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.IsApproved));
sqlCommand.Parameters.Add(new SqlParameter("@isPrinted", SqlDbType.Bit, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.isPrinted));
sqlCommand.Parameters.Add(new SqlParameter("@CreatedBy", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.TransactionBy));
sqlCommand.Parameters.Add(new SqlParameter("@CreatedDate", SqlDbType.DateTime, 14, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.TransactionDate));
MainConnection.Open();
int rowsAffected = sqlCommand.ExecuteNonQuery();
rowsAffected = Convert.ToInt32(sqlCommand.Parameters["@CardID"].Value);
return(rowsAffected);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public bool Update(CardsPro pro)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[Cards_Update]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@CardID", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.CardID));
sqlCommand.Parameters.Add(new SqlParameter("@EmpID", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.EmpID));
sqlCommand.Parameters.Add(new SqlParameter("@IsID", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.IsID));
sqlCommand.Parameters.Add(new SqlParameter("@CardCount", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.CardCount));
sqlCommand.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.DateTime, 14, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DateFun.SaveDB('S', pro.StartDate)));
sqlCommand.Parameters.Add(new SqlParameter("@ExpiryDate", SqlDbType.DateTime, 14, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DateFun.SaveDB('S', pro.ExpiryDate)));
sqlCommand.Parameters.Add(new SqlParameter("@TmpID", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.TmpID));
sqlCommand.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 250, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.Description));
sqlCommand.Parameters.Add(new SqlParameter("@CardStatus", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.CardStatus));
sqlCommand.Parameters.Add(new SqlParameter("@TransactionBy", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.TransactionBy));
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw new Exception("Cards::Update::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public bool Update(StickersPro Pro)
{
SqlCommand sqlCmd = new SqlCommand("dbo.[StickerMaster_Update]", MainConnection);
sqlCmd.CommandType = CommandType.StoredProcedure;
try
{
sqlCmd.Parameters.Add(new SqlParameter("@StickerID", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Pro.StickerID));
sqlCmd.Parameters.Add(new SqlParameter("@RegVehicle", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Pro.RegVehicle));
sqlCmd.Parameters.Add(new SqlParameter("@EmpID", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Pro.EmpID));
if (!string.IsNullOrEmpty(Pro.StartDate))
{
sqlCmd.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.DateTime, 14, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DateFun.SaveDB('G', Pro.StartDate)));
}
if (!string.IsNullOrEmpty(Pro.ExpiryDate))
{
sqlCmd.Parameters.Add(new SqlParameter("@ExpiryDate", SqlDbType.DateTime, 14, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DateFun.SaveDB('G', Pro.ExpiryDate)));
}
sqlCmd.Parameters.Add(new SqlParameter("@Owner", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Pro.Owner));
sqlCmd.Parameters.Add(new SqlParameter("@CarType", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Pro.CarType));
sqlCmd.Parameters.Add(new SqlParameter("@Model", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Pro.Model));
sqlCmd.Parameters.Add(new SqlParameter("@Color", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Pro.Color));
sqlCmd.Parameters.Add(new SqlParameter("@TemplateID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Pro.TemplateID));
sqlCmd.Parameters.Add(new SqlParameter("@CompID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Pro.CompID));
sqlCmd.Parameters.Add(new SqlParameter("@Printed", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, true));
sqlCmd.Parameters.Add(new SqlParameter("@Status", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Pro.Status));
sqlCmd.Parameters.Add(new SqlParameter("@TransactionBy", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, Pro.TransactionBy));
MainConnection.Open();
sqlCmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
MainConnection.Close();
sqlCmd.Dispose();
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void ShowReport()
{
StiWebViewerFx1.Report = null;
if (lstReport.SelectedIndex < 0)
{
return;
}
string RepID = lstReport.SelectedValue;
string RepTemp = "";
DataTable RepDT = DBFun.FetchData(" SELECT * FROM Report WHERE RepID = '" + RepID + "'");
if (!DBFun.IsNullOrEmpty(RepDT))
{
RepTemp = RepDT.Rows[0]["RepTemp" + FormSession.Language].ToString();
string RepOrientation = RepDT.Rows[0]["RepOrientation"].ToString();
ViewState["RepOrientation"] = RepDT.Rows[0]["RepOrientation"].ToString();
StiReport StiRep = new StiReport();
StiRep.LoadFromString(RepTemp);
StiRep.Dictionary.Databases.Clear();
StiRep.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", General.ConnString));
StiRep.GetSubReport += new StiGetSubReportEventHandler(rep_GetSubReport);
StiRep.Dictionary.Synchronize();
StiRep.Compile();
/////// Fill Parameters to Report
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
if (pnlDateFromTo.Visible)
{
StiRep["ParamDateFrom"] = DateFun.GetGregDateTime(calStartDate.getDate(), 'S', "F");
StiRep["ParamDateTo"] = DateFun.GetGregDateTime(calEndDate.getDate(), 'S', "T");
}
if (pnlEmployee.Visible)
{
StiRep["EmpID"] = ViewState["EmpID"].ToString();
}
if (pnlCreatedBy.Visible)
{
StiRep["CreatedBy"] = ddlCreatedBy.SelectedValue;
}
if (pnlPrintedBy.Visible)
{
StiRep["PrintedBy"] = ddlPrintedBy.SelectedValue;
}
if (pnlIssue.Visible)
{
StiRep["IssueID"] = Convert.ToInt32(ddlIssue.SelectedValue);
}
if (pnlEmpType.Visible)
{
StiRep["EmpType"] = ddlEmpType.SelectedValue;
StiRep["CompID"] = ddlCompID.SelectedValue;
StiRep["HasCard"] = ddlHasCard.SelectedValue;
}
StiRep["LoginID"] = FormSession.LoginUsr;
StiRep.Render();
StiWebViewerFx1.Report = StiRep;
}
}
