private void btn_UcCheckInCheck_Click(object sender, EventArgs e)
{
int?commode;
if (txb_UcCheckInPrice.Text.Equals(""))
{
//MessageBox.Show("لطفا قیمت جلسه را وارد نمایید");
Alert alert = new Alert("لطفا قیمت جلسه را وارد نمایید", "red");
txb_UcCheckInPrice.Focus();
}
else
{
if (txb_UcCheckInPrice.Text.Equals(""))
{
commode = null;
}
else
{
commode = Convert.ToInt32(txb_UcCheckInPrice.Text);
DateTime d = DateTime.Now;
PersianCalendar pc = new PersianCalendar();
String date = String.Format("{0}/{1:00}/{2:00} - {3:00}:{4:00}", pc.GetYear(d), pc.GetMonth(d), pc.GetDayOfMonth(d), pc.GetHour(d), pc.GetMinute(d));
string date1 = string.Format("{0}/{1:00}/{2:00}", pc.GetYear(d), pc.GetMonth(d), pc.GetDayOfMonth(d));
string time1 = string.Format("{0:00}:{1:00}", pc.GetHour(d), pc.GetMinute(d));
//rayan_sportDataSet.logDataTable logeDataTable = new rayan_sportDataSet.logDataTable();
rayan_sportDataSetTableAdapters.logTableAdapter logTableAdapter = new rayan_sportDataSetTableAdapters.logTableAdapter();
rayan_sportDataSet.checkInDataTable checkInDataTabele = new rayan_sportDataSet.checkInDataTable();
rayan_sportDataSetTableAdapters.checkInTableAdapter checkInTableAdapter = new rayan_sportDataSetTableAdapters.checkInTableAdapter();
try
{
checkInTableAdapter.Insert(Convert.ToInt64(txb_UcCheckInPrice.Text), date, commode);
logTableAdapter.Insert("checked in one person", "checkIn", user_name, date1, time1);
//MessageBox.Show("ورود با موفقیت انجام شد");
Alert alert = new Alert("ورود با موفقیت انجام شد", "green");
ClearTexts();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
Alert alert = new Alert(ex.Message, "red");
}
}
}
}
public UC_Home()
{
InitializeComponent();
/*rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
* int count = (int)membershipTableAdapter.ScalarCountOfContract();
* lbl_UcHomeAllContractNum.Text = count.ToString();*/
activeContract = "فعال";
rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter1 = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
int activeCount = (int)membershipTableAdapter1.ScalarCountByActiveContract(activeContract);
lbl_UcHomeActiveContract.Text = activeCount.ToString();
rayan_sportDataSetTableAdapters.memberTableAdapter memberTableAdapter = new rayan_sportDataSetTableAdapters.memberTableAdapter();
int numMember = (int)memberTableAdapter.ScalarCountByMemberNum();
lbl_UcHomeAllMember.Text = numMember.ToString();
String todeyDate1 = getDateShamsi(DateTime.Now.ToString("M/d/yyyy"));
rayan_sportDataSetTableAdapters.membershipTableAdapter membershipTableAdapter2 = new rayan_sportDataSetTableAdapters.membershipTableAdapter();
int expiredContract = (int)membershipTableAdapter1.ScalarCountByTodayExpiredContract(todeyDate1);
lbl_UcHomeExoiredContract.Text = expiredContract.ToString();
rayan_sportDataSetTableAdapters.checkInTableAdapter checkInTableAdapter = new rayan_sportDataSetTableAdapters.checkInTableAdapter();
int notMember = (int)checkInTableAdapter.ScalarCountByNotMember(todeyDate1);
lbl_UcHomeDayliMemberNum.Text = notMember.ToString();
Iam = 0;
}
