//protected void btnBookNow_Click (object sender, EventArgs e)
//{
// var UserID = Convert.ToInt32(ddlNames.SelectedValue);
// var BusNumber = Convert.ToInt32(ddlBusNumber.SelectedValue);
// var SeatNumber = Convert.ToInt32(ddlSeatNumber.SelectedValue);
// var PayanamID = Convert.ToInt32(Request.QueryString["pid"]);
// using (VallabaiDataContext db = new VallabaiDataContext())
// {
// var check = from c in db.tab_VA_BUS_BOOKINGs
// where c.payanam_ID == PayanamID && c.user_ID == UserID
// select c;
// if (check.Count() == 0)
// {
// tab_VA_BUS_BOOKING book = new tab_VA_BUS_BOOKING();
// book.payanam_ID = PayanamID;
// book.user_ID = UserID;
// book.bus_NUMBER = BusNumber;
// book.seat_NUMBER = SeatNumber;
// db.tab_VA_BUS_BOOKINGs.InsertOnSubmit(book);
// db.SubmitChanges();
// Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowStatus", "$(function() { funShowMessage('Seat Booked')});", true);
// BindBookedSeats();
// }
// else
// {
// Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowStatus", "$(function() { funShowMessage('Seat is already alloted to this Swamy')});", true);
// }
// }
//}
protected void gvCancel_Click(object sender, EventArgs e)
{
var PayanamID = Convert.ToInt32(Request.QueryString["pid"]);
string CommandArgument = Convert.ToString(((Button)sender).CommandArgument);
if (CommandArgument.Contains(","))
{
var Values = CommandArgument.Split(',');
var SeatNumber = Convert.ToInt32(Values[0]);
var BusNumber = Convert.ToInt32(Values[1]);
using (VallabaiDataContext db = new VallabaiDataContext())
{
var seat = from s in db.tab_VA_BUS_BOOKINGs
where s.payanam_ID == PayanamID && s.seat_NUMBER == SeatNumber && s.bus_NUMBER == BusNumber
select s;
if (seat.Count() > 0)
{
foreach (var item in seat)
{
db.tab_VA_BUS_BOOKINGs.DeleteOnSubmit(item);
db.SubmitChanges();
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowStatus", "$(function() { funShowMessage('Cancelled selected seat')});", true);
BindBookedSeats();
//LoadSeatNumbers();
ClearFields();
}
}
}
}
public static string SeatBooking(int PayanamID, int BusID, int UserID, int SeatNumber)
{
string Response = string.Empty;
using (VallabaiDataContext db = new VallabaiDataContext())
{
try
{
var seat = from s in db.tab_VA_BUS_BOOKINGs
where s.payanam_ID == PayanamID && s.bus_NUMBER == BusID && s.seat_NUMBER == SeatNumber
select s;
if (seat.Count() == 0)
{
tab_VA_BUS_BOOKING booking = new tab_VA_BUS_BOOKING();
booking.payanam_ID = PayanamID;
booking.bus_NUMBER = BusID;
booking.user_ID = UserID;
booking.seat_NUMBER = SeatNumber;
db.tab_VA_BUS_BOOKINGs.InsertOnSubmit(booking);
db.SubmitChanges();
Response = "Seat is Alloted";
}
else
{
Response = "Selected Seat is not available";
}
}
catch (Exception ex)
{
Response = "Some error occured : " + ex.Message;
}
}
return(Response);
}
protected void btnSaveBusDetails_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
var PayanamID = Convert.ToInt32(Request.QueryString["pID"]);
var BusType = ddlVehicleType.SelectedValue;
var RegistrationNumber = txtRegistrationNumber.Text;
var BusNumber = Convert.ToInt32(txtBusNumber.Text);
var TotalSeats = Convert.ToInt32(txtTotalSeats.Text);
var DriverName = txtDriverName.Text;
var DriverMobileNumber = txtDriverMobileNumber.Text;
using (VallabaiDataContext db = new VallabaiDataContext())
{
try
{
tab_VA_PAYANAM_BUS_DETAIL detail = new tab_VA_PAYANAM_BUS_DETAIL();
detail.bus_PAYANAM_NUMBER = PayanamID;
detail.vehicle_TYPE = BusType;
detail.bus_REGISTRATION_NUMBER = RegistrationNumber;
detail.bus_NUMBER = BusNumber;
detail.bus_TOTAL_SEATS = TotalSeats;
detail.bus_DRIVER_NAME = DriverName;
detail.bus_DRIVER_MOBILE_NUMBER = DriverMobileNumber;
db.tab_VA_PAYANAM_BUS_DETAILs.InsertOnSubmit(detail);
db.SubmitChanges();
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowStatus", "$(function() { funShowMessage('User Details updated successfully')});", true);
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowStatus", "$(function() { funShowMessage('" + ex.Message.ToString() + "')});", true);
}
}
}
else
{
Response.Write("Sethu");
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
var fileName = flData.FileName;
var fileContentType = flData.PostedFile.ContentType;
var pathUploaded = Uploader.FileUploader(flData.PostedFile);
var connectionString = Uploader.GetExcelConnectionString(fileContentType, pathUploaded);
OleDbConnection OleCon = new OleDbConnection(connectionString);
DataTable tbl = new DataTable("MyTable");
OleCon.Open();
var tableName = OleCon.GetSchema("Tables").Rows[0]["TABLE_NAME"];
OleDbCommand OleCmd = new OleDbCommand(string.Format("Select * from [{0}]", tableName), OleCon);
OleDbDataAdapter adp = new OleDbDataAdapter(OleCmd);
adp.Fill(tbl);
using (VallabaiDataContext db = new VallabaiDataContext())
{
foreach (DataRow row in tbl.Rows)
{
var OldRegID = Convert.ToString(row.ItemArray[0]);
var Code = OldRegID;
var Name = Convert.ToString(row.ItemArray[1]);
var FatherName = Convert.ToString(row.ItemArray[2]);
var Address = Convert.ToString(row.ItemArray[3]);
var Age = Convert.ToString(row.ItemArray[4]);
var MalaiDetail = Convert.ToString(row.ItemArray[5]);
var MalaiCount = 0;
if (MalaiDetail != "")
{
MalaiCount = 0;
}
else if (MalaiDetail == "KANNI")
{
MalaiCount = 1;
}
else
{
MalaiCount = Convert.ToInt32(MalaiDetail);
}
var MobileNumber = Convert.ToString(row.ItemArray[6]);
var Membership = Convert.ToString(row.ItemArray[10]);
var IsMember = false;
if (Membership != "")
{
IsMember = true;
}
tab_VA_SWAMY_REGISTRATION reg = new tab_VA_SWAMY_REGISTRATION();
try
{
reg.swamy_CODE = Code;
reg.swamy_OLD_REG_NUMBER = OldRegID;
reg.swamy_NAME = Name;
reg.swamy_FATHER_SPOUSE_NAME = FatherName;
reg.swamy_GENDER = "Male";
reg.swamy_IS_MEMBER = IsMember;
reg.swamy_PLACE = Address;
reg.swamy_ADDRESS = Address;
reg.swamy_MOBILE_NUMBER = MobileNumber;
reg.swamy_DISTRICT = "Ramanathapuram";
reg.swamy_MALAI_VISIT = MalaiCount;
reg.swamy_MEMBERSHIP_TYPE = Membership;
db.tab_VA_SWAMY_REGISTRATIONs.InsertOnSubmit(reg);
db.SubmitChanges();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
Response.Write("Upload Completed");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
var SwamyName = txtName.Text;
var SwamyFatherName = txtFatherName.Text;
var SwamyGender = string.Empty;
if (rdlSwamy.Checked)
{
SwamyGender = rdlSwamy.Value;
}
else
{
SwamyGender = rdlMaaligaipuram.Value;
}
var SwamyDOB = string.Empty;
if (Utilities.isValidDate(txtDOB.Text))
{
SwamyDOB = txtDOB.Text;
}
var SwamyMobileNumber = txtMobileNumber.Text;
var SwamyAlternateMobile = txtAlternateMobile.Text;
var SwamyPlace = txtPlace.Text;
var SwamyAddress = txtAddress.Text;
var SwamyDistrict = ddlDistrict.SelectedValue;
var SwamyBloodGroup = ddlBloodGroup.SelectedValue;
var SwamyMalaiVisit = 0;
if (Utilities.isNumber(txtMalai.Text))
{
SwamyMalaiVisit = Convert.ToInt32(txtMalai.Text);
}
var SwamyKanniPoojaiDate = string.Empty;
if (Utilities.isValidDate(txtKanniPoojaiDate.Text))
{
SwamyKanniPoojaiDate = txtKanniPoojaiDate.Text;
}
var SwamyMemebershipExpiry = string.Empty;
if (Utilities.isValidDate(txtMembershipExpiry.Text))
{
SwamyMemebershipExpiry = txtMembershipExpiry.Text;
}
var SwamyMembership = string.Empty;
if (rdlNonMeber.Checked)
{
SwamyMembership = rdlNonMeber.Value;
}
else if (rdlLifetime.Checked)
{
SwamyMembership = rdlLifetime.Value;
}
else
{
SwamyMembership = rdlShortTermMember.Value;
}
//Get Swamy Code
if (btnSave.Text == "Save")
{
var SwamyCode = Utilities.GetSwamyCode();
using (VallabaiDataContext db = new VallabaiDataContext())
{
tab_VA_SWAMY_REGISTRATION regis = new tab_VA_SWAMY_REGISTRATION();
regis.swamy_CODE = SwamyCode;
regis.swamy_NAME = SwamyName;
regis.swamy_FATHER_SPOUSE_NAME = SwamyFatherName;
regis.swamy_GENDER = SwamyGender;
if (!string.IsNullOrEmpty(SwamyDOB))
{
regis.swamy_DOB = Convert.ToDateTime(SwamyDOB);
}
regis.swamy_PLACE = SwamyPlace;
regis.swamy_ADDRESS = SwamyAddress;
regis.swamy_MOBILE_NUMBER = SwamyMobileNumber;
regis.swamy_ALTERNATE_MOBILE = SwamyAlternateMobile;
regis.swamy_DISTRICT = SwamyDistrict;
regis.swamy_BLOOD_GROUP = SwamyBloodGroup;
regis.swamy_MALAI_VISIT = SwamyMalaiVisit;
if (!string.IsNullOrEmpty(SwamyKanniPoojaiDate))
{
regis.swamy_KANNI_POOJAI_DATE = Convert.ToDateTime(SwamyKanniPoojaiDate);
}
//regis.swamy_IS_MEMBER =
regis.swamy_MEMBERSHIP_TYPE = SwamyMembership;
if (!string.IsNullOrEmpty(SwamyMemebershipExpiry))
{
regis.swamy_MEMBERSHIP_EXPIRY_DATE = Convert.ToDateTime(SwamyMemebershipExpiry);
}
db.tab_VA_SWAMY_REGISTRATIONs.InsertOnSubmit(regis);
db.SubmitChanges();
var SwamyID = Utilities.GetLatestRegisterID();
//Save The Photo against the Swamy
if (flPhoto.PostedFiles != null)
{
if (flPhoto.PostedFile.ContentLength > 0)
{
flPhoto.PostedFile.SaveAs(Server.MapPath("~/management/Resources/temp/" + SwamyID + ".jpg"));
}
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowStatus", "$(function() { funShowMessage('User Details updated successfully')});", true);
ClearFields();
}
}
else
{
if (Request.QueryString["sid"] != null)
{
var SwamyID = Convert.ToInt32(Ciphering.Decrypt(Convert.ToString(Request.QueryString["sid"])));
using (VallabaiDataContext db = new VallabaiDataContext())
{
var swamy = from s in db.tab_VA_SWAMY_REGISTRATIONs
where s.swamy_ID == SwamyID
select s;
if (swamy.Count() > 0)
{
foreach (var regis in swamy)
{
regis.swamy_NAME = SwamyName;
regis.swamy_FATHER_SPOUSE_NAME = SwamyFatherName;
if (!string.IsNullOrEmpty(SwamyDOB))
{
regis.swamy_DOB = Convert.ToDateTime(SwamyDOB);
}
regis.swamy_MOBILE_NUMBER = SwamyMobileNumber;
regis.swamy_ALTERNATE_MOBILE = SwamyAlternateMobile;
regis.swamy_PLACE = SwamyPlace;
regis.swamy_ADDRESS = SwamyAddress;
regis.swamy_DISTRICT = SwamyDistrict;
regis.swamy_BLOOD_GROUP = SwamyBloodGroup;
regis.swamy_MALAI_VISIT = SwamyMalaiVisit;
regis.swamy_MEMBERSHIP_TYPE = SwamyMembership;
if (!string.IsNullOrEmpty(SwamyMemebershipExpiry))
{
regis.swamy_MEMBERSHIP_EXPIRY_DATE = Convert.ToDateTime(SwamyMemebershipExpiry);
}
if (flPhoto.PostedFiles != null)
{
if (flPhoto.PostedFile.ContentLength > 0)
{
flPhoto.PostedFile.SaveAs(Server.MapPath("~/management/Resources/temp/" + SwamyID + ".jpg"));
}
}
db.SubmitChanges();
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowStatus", "$(function() { funShowMessage('User Details updated successfully')});", true);
ClearFields();
}
}
}
}
}
}
}