protected void RadioButtonList_selectcity_SelectedIndexChanged(object sender, EventArgs e)
{
if (RadioButtonList_selectcity.SelectedValue == "Delhi")
{
VisaForm advisaform = new VisaForm();
List <VisaForm> adlst = new List <VisaForm>();
adlst = visafmbl.ReadDelhiForm();
Visa_gridshow.DataSource = adlst;
Visa_gridshow.DataBind();
}
else if (RadioButtonList_selectcity.SelectedValue == "Mumbai")
{
VisaForm advisaform = new VisaForm();
List <VisaForm> adlst = new List <VisaForm>();
adlst = visafmbl.ReadMumbaiForm();
Visa_gridshow.DataSource = adlst;
Visa_gridshow.DataBind();
}
else if (RadioButtonList_selectcity.SelectedValue == "Channai")
{
VisaForm advisaform = new VisaForm();
List <VisaForm> adlst = new List <VisaForm>();
adlst = visafmbl.ReadChannaiForm();
Visa_gridshow.DataSource = adlst;
Visa_gridshow.DataBind();
}
else if (RadioButtonList_selectcity.SelectedValue == "Bangalore")
{
VisaForm advisaform = new VisaForm();
List <VisaForm> adlst = new List <VisaForm>();
adlst = visafmbl.ReadBangaloreForm();
Visa_gridshow.DataSource = adlst;
Visa_gridshow.DataBind();
}
}
public List <VisaForm> ReadSchengenForm(int?id)
{
List <VisaForm> lstSchengen = new List <VisaForm>();
VisaForm visaRequirement = null;
DbCommand dbCommand = myDataBase.GetStoredProcCommand("procReadSchengenVisaForm");
dbCommand.CommandType = CommandType.StoredProcedure;
if (id == null)
{
myDataBase.AddInParameter(dbCommand, "@in_CountryId", DbType.Int32, DBNull.Value);
}
else
{
myDataBase.AddInParameter(dbCommand, "@in_CountryId", DbType.Int32, id);
}
using (IDataReader reader = myDataBase.ExecuteReader(dbCommand))
{
while (reader.Read())
{
// VisaForm visaForm = new VisaForm();
visaRequirement = new VisaForm();
visaRequirement.Form = Convert.ToString(reader["Form"]);
visaRequirement.CountryForVisa = Convert.ToString(reader["COUNTRY_NAME"]);
visaRequirement.VisaTitle = Convert.ToString(reader["Visa_title"]);
visaRequirement.CountryId = Convert.ToInt32(reader["COUNTRY_ID"]);
lstSchengen.Add(visaRequirement);
}
}
return(lstSchengen);
}
public List <VisaForm> ReadVisaFormByCountry(string countryName, string consulate)
{
List <VisaForm> lstVisaForm = new List <VisaForm>();
DbCommand dbCommand = myDataBase.GetStoredProcCommand("procReadVisaFormByCountry");
myDataBase.AddInParameter(dbCommand, "@inCountry", DbType.String, countryName);
if (!String.IsNullOrEmpty(consulate))
{
myDataBase.AddInParameter(dbCommand, "@inConsulate", DbType.String, consulate);
}
else
{
myDataBase.AddInParameter(dbCommand, "@inConsulate", DbType.String, DBNull.Value);
}
IDataReader reader = myDataBase.ExecuteReader(dbCommand);
{
while (reader.Read())
{
VisaForm addVisaDom = new VisaForm();
//addVisaDom.Id = GetIntegerFromDataReader(reader, "Id");
//addVisaDom.CountryForVisa = GetStringFromDataReader(reader, "Country_for_Visa");
addVisaDom.Id = GetIntegerFromDataReader(reader, "Id");
addVisaDom.Form = GetStringFromDataReader(reader, "Form");
addVisaDom.VisaCity = GetStringFromDataReader(reader, "Visa_City");
addVisaDom.CountryForVisa = GetStringFromDataReader(reader, "Country_for_Visa");
addVisaDom.VisaTitle = GetStringFromDataReader(reader, "Visa_title");
lstVisaForm.Add(addVisaDom);
}
return(lstVisaForm);
}
}
public void InsertVaccination(VisaForm addVisaDom)
{
DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.CREATE_VACCINATION_VISA_FORM);
myDataBase.AddInParameter(dbCommand, "Visa_title", DbType.String, addVisaDom.VisaTitle);
myDataBase.AddInParameter(dbCommand, "@Form", DbType.String, addVisaDom.Form);
myDataBase.AddInParameter(dbCommand, "@CreatedBy", DbType.String, addVisaDom.Created_By);
myDataBase.ExecuteNonQuery(dbCommand);
}
public void InsertCoverNote(VisaForm addVisaDom)
{
DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.CREATE_COVERNOTE_FORM);
myDataBase.AddInParameter(dbCommand, "Visa_title", DbType.String, addVisaDom.VisaTitle);
myDataBase.AddInParameter(dbCommand, "@Form", DbType.String, addVisaDom.Form);
myDataBase.AddInParameter(dbCommand, "@CreatedBy", DbType.String, addVisaDom.Created_By);
myDataBase.ExecuteNonQuery(dbCommand);
}
private VisaForm VaccinationFromDataReader(IDataReader reader)
{
VisaForm addVisaDom = new VisaForm();
addVisaDom.Id = GetIntegerFromDataReader(reader, "Id");
addVisaDom.VisaTitle = GetStringFromDataReader(reader, "Visa_title");
addVisaDom.Form = GetStringFromDataReader(reader, "Path");
return(addVisaDom);
}
private VisaForm GeneraterecordFromDataReaderc(IDataReader reader)
{
VisaForm addVisaDom = new VisaForm();
addVisaDom.Id = GetIntegerFromDataReader(reader, "Id");
addVisaDom.CountryForVisa = GetStringFromDataReader(reader, "Country_for_Visa");
addVisaDom.VisaTitle = GetStringFromDataReader(reader, "Visa_title");
addVisaDom.Form = GetStringFromDataReader(reader, "Form");
return(addVisaDom);
}
private void addVisa_Click(object sender, EventArgs e)
{
visa v = new visa {
date_of_issue = DateTime.Now, expirition_date = DateTime.Now
};
VisaForm visaForm = new VisaForm(v);
visaForm.ShowDialog();
client.visas.Add(v);
setDGVDatasourse();
}
private void visaDGV_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
;
visa v = visaDGV.Rows[e.RowIndex].DataBoundItem as visa;
VisaForm visaForm = new VisaForm(v);
visaForm.ShowDialog();
setDGVDatasourse();
}
public List <VisaForm> ReadBangaloreForm()
{
List <VisaForm> adlst = new List <VisaForm>();
DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.SELECT_BANGALORE);
VisaForm addVisaDom = new VisaForm();
IDataReader reader = myDataBase.ExecuteReader(dbCommand);
{
while (reader.Read())
{
addVisaDom = GeneraterecordFromDataReaderb(reader);
adlst.Add(addVisaDom);
}
return(adlst);
}
}
protected void LinkButtonA_Click(object sender, EventArgs e)
{
if (RadioButtonList_selectcity.SelectedValue == "Delhi")
{
string strCity = "Delhi";
string strStartCountry = ((LinkButton)sender).CommandArgument;
VisaForm advisaform = new VisaForm();
List <VisaForm> adlst = new List <VisaForm>();
adlst = visafmbl.ReadForm(strStartCountry, strCity);
Visa_gridshow.DataSource = adlst;
Visa_gridshow.DataBind();
}
else if (RadioButtonList_selectcity.SelectedValue == "Mumbai")
{
string strCity = "Mumbai";
string strStartCountry = ((LinkButton)sender).CommandArgument;
VisaForm advisaform = new VisaForm();
List <VisaForm> adlst = new List <VisaForm>();
adlst = visafmbl.ReadForm(strStartCountry, strCity);
Visa_gridshow.DataSource = adlst;
Visa_gridshow.DataBind();
}
else if (RadioButtonList_selectcity.SelectedValue == "Channai")
{
string strCity = "Channai";
string strStartCountry = ((LinkButton)sender).CommandArgument;
VisaForm advisaform = new VisaForm();
List <VisaForm> adlst = new List <VisaForm>();
adlst = visafmbl.ReadForm(strStartCountry, strCity);
Visa_gridshow.DataSource = adlst;
Visa_gridshow.DataBind();
}
else if (RadioButtonList_selectcity.SelectedValue == "Bangalore")
{
string strCity = "Bangalore";
string strStartCountry = ((LinkButton)sender).CommandArgument;
VisaForm advisaform = new VisaForm();
List <VisaForm> adlst = new List <VisaForm>();
adlst = visafmbl.ReadForm(strStartCountry, strCity);
Visa_gridshow.DataSource = adlst;
Visa_gridshow.DataBind();
}
}
public List <VisaForm> ReadCoverNote(int?id)
{
List <VisaForm> adlst = new List <VisaForm>();
DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.READ_COVERNOTE_VISA_FORM);
myDataBase.AddInParameter(dbCommand, "@id", DbType.Int32, id);
IDataReader reader = myDataBase.ExecuteReader(dbCommand);
{
while (reader.Read())
{
VisaForm addVisaDom = new VisaForm();
addVisaDom = VaccinationFromDataReader(reader);
adlst.Add(addVisaDom);
}
return(adlst);
}
}
public List <VisaForm> ReadVisarecord(String name)
{
List <VisaForm> adlst = new List <VisaForm>();
DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.SEARCH_VISA_FORM);
myDataBase.AddInParameter(dbCommand, "Visa_City", DbType.String, name);
VisaForm addVisaDom = new VisaForm();
IDataReader reader = myDataBase.ExecuteReader(dbCommand);
{
while (reader.Read())
{
addVisaDom = GeneraterecordFromDataReaderread(reader);
adlst.Add(addVisaDom);
}
return(adlst);
}
}
public List <VisaForm> ReadVisaForm()
{
List <VisaForm> adlst = new List <VisaForm>();
DbCommand dbCommand = myDataBase.GetSqlStringCommand("select * from visa_form where isdeleted=0 order by visa_title ASC");
IDataReader reader = myDataBase.ExecuteReader(dbCommand);
{
while (reader.Read())
{
VisaForm addVisaDom = new VisaForm();
addVisaDom.Id = GetIntegerFromDataReader(reader, "Id");
addVisaDom.CountryForVisa = GetStringFromDataReader(reader, "Country_for_Visa");
addVisaDom.VisaTitle = GetStringFromDataReader(reader, "Visa_title");
addVisaDom.Form = GetStringFromDataReader(reader, "Form");
adlst.Add(addVisaDom);
}
return(adlst);
}
}
public List <VisaForm> ReadForm(string str, string strCity)
{
List <VisaForm> adlst = new List <VisaForm>();
DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.SELECT_BY_FILTER);
myDataBase.AddInParameter(dbCommand, "@Visa_City", DbType.String, strCity);
myDataBase.AddInParameter(dbCommand, "@Country_for_Visa", DbType.String, str);
VisaForm addVisaDom = new VisaForm();
IDataReader reader = myDataBase.ExecuteReader(dbCommand);
{
while (reader.Read())
{
addVisaDom = GeneraterecordFromDataReadercharecter(reader);
adlst.Add(addVisaDom);
}
return(adlst);
}
}
public void InsertRecordForSchnegenCountry(VisaForm addVisaDom)
{
//foreach (VisaForm adVisaDom in addVisaDom)
//{
string schnegenCountryComm = addVisaDom.CountryForVisa;
string[] schnegen = schnegenCountryComm.Split(',');
string cityCommaSep = addVisaDom.VisaCity;
string[] city = cityCommaSep.Split(',');
foreach (var item in city)
{
if (item != "")
{
foreach (var schengenCountry in schnegen)
{
if (schengenCountry != "")
{
DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.CREATE_VISA_FORM);
// myDataBase.AddInParameter(dbCommand, "@LocationId", DbType.Int32, adVisaDom.LocationId);
myDataBase.AddInParameter(dbCommand, "@Visa_City", DbType.String, item);
myDataBase.AddInParameter(dbCommand, "@Country_for_Visa", DbType.String, schengenCountry);
myDataBase.AddInParameter(dbCommand, "Visa_title", DbType.String, addVisaDom.VisaTitle);
myDataBase.AddInParameter(dbCommand, "@Form", DbType.String, addVisaDom.Form);
//myDataBase.AddInParameter(dbCommand, "@FilePath", DbType.String, adVisaDom.FilePath);
//myDataBase.AddInParameter(dbCommand, "@CountryId", DbType.String, adVisaDom.CountryId);
////myDataBase.AddInParameter(dbCommand, "@Type", DbType.String, adVisaDom.VisaTitle);
myDataBase.AddInParameter(dbCommand, "@CreatedBy", DbType.String, addVisaDom.Created_By);
myDataBase.ExecuteNonQuery(dbCommand);
}
}
}
}
}
public void InsertRecordForSchnegenCountry(VisaForm addvisadom)
{
addVisaFormDal.InsertRecordForSchnegenCountry(addvisadom);
}
public void InsertCoverNote(VisaForm addvisadom)
{
addVisaFormDal.InsertCoverNote(addvisadom);
}
public void InsertVaccination(VisaForm addvisadom)
{
addVisaFormDal.InsertVaccination(addvisadom);
}
