public static Appointmnet GetAppointmnetByClientID(int ClientID)
{
Appointmnet appointmnet = new Appointmnet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnet = sqlAppointmnetProvider.GetAppointmnetByClientID(ClientID);
return appointmnet;
}
protected void btnSaveAppointment_Click(object sender, EventArgs e)
{
MembershipUser currentUser;
currentUser = Membership.GetUser();
Appointmnet appointmnet = new Appointmnet();
// appointmnet.AppointmnetID= int.Parse(ddlAppointmnetID.SelectedValue);
appointmnet.ClientID = Convert.ToInt32(mCusomerID.Value);
appointmnet.Date = DateTime.Parse(txtAptDate.Text);
appointmnet.Time = txtApttime.Text;
appointmnet.CreateBy = currentUser.ProviderUserKey.ToString();
// appointmnet.City = int.Parse(ddlAppointmentCityID.SelectedValue);
appointmnet.MetroLocationID = int.Parse("0");
appointmnet.StastusID = 1;
appointmnet.CreatedDate = DateTime.Now;
int resutl = AppointmnetManager.InsertAppointmnet(appointmnet);
showAppointment(Convert.ToInt32(mCusomerID.Value));
div_appointmentadd.Visible = false;
btnSaveAppointment.Visible = false;
btnCancelAppointment.Visible = false;
btnAddAppointment.Visible = true;
ClearAppointment();
}
public static Appointmnet GetMetroLocationByMetroLocationID(int MetroLocationID)
{
Appointmnet appointmnet = new Appointmnet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnet = sqlAppointmnetProvider.GetAppointmnetByMetroLocationID(MetroLocationID);
return(appointmnet);
}
public static Appointmnet GetAppointmnetByClientID(int ClientID)
{
Appointmnet appointmnet = new Appointmnet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnet = sqlAppointmnetProvider.GetAppointmnetByClientID(ClientID);
return(appointmnet);
}
public static Appointmnet GetStastusByStastusID(int StastusID)
{
Appointmnet appointmnet = new Appointmnet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnet = sqlAppointmnetProvider.GetAppointmnetByStastusID(StastusID);
return(appointmnet);
}
public bool UpdateAppointmnet(Appointmnet appointmnet)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateAppointmnet", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AppointmnetID", SqlDbType.Int).Value = appointmnet.AppointmnetID;
cmd.Parameters.Add("@ClientID", SqlDbType.Int).Value = appointmnet.ClientID;
cmd.Parameters.Add("@Date", SqlDbType.DateTime).Value = appointmnet.Date;
cmd.Parameters.Add("@Time", SqlDbType.NVarChar).Value = appointmnet.Time;
// cmd.Parameters.Add("@CreateBy", SqlDbType.NVarChar).Value = appointmnet.CreateBy;
// cmd.Parameters.Add("@City", SqlDbType.Int).Value = appointmnet.City;
cmd.Parameters.Add("@MetroLocationID", SqlDbType.Int).Value = appointmnet.MetroLocationID;
cmd.Parameters.Add("@StastusID", SqlDbType.Int).Value = appointmnet.StastusID;
// cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = appointmnet.CreatedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public void addAppoinmemnt(int clientid)
{
MembershipUser currentUser;
currentUser = Membership.GetUser();
if (txtAppointmentDate.Text != "" && txtAppointmentTime.Text != "")
{
Appointmnet appointmnet = new Appointmnet();
// appointmnet.AppointmnetID= int.Parse(ddlAppointmnetID.SelectedValue);
appointmnet.ClientID = clientid;
appointmnet.Date = DateTime.Parse(txtAppointmentDate.Text);
appointmnet.Time = txtAppointmentTime.Text;
appointmnet.CreateBy = currentUser.ProviderUserKey.ToString();
appointmnet.City = txtCity.Text;
appointmnet.MetroLocationID = int.Parse("0");
appointmnet.StastusID = 1;
appointmnet.CreatedDate = DateTime.Now;
int resutl = AppointmnetManager.InsertAppointmnet(appointmnet);
}
}
public Appointmnet GetAppointmnetFromReader(IDataReader reader)
{
try
{
Appointmnet appointmnet = new Appointmnet
(
DataAccessObject.IsNULL <int>(reader["AppointmnetID"]),
DataAccessObject.IsNULL <int>(reader["ClientID"]),
DataAccessObject.IsNULL <DateTime>(reader["Date"]),
DataAccessObject.IsNULL <string>(reader["Time"]),
DataAccessObject.IsNULL <string>(reader["CreateBy"].ToString()),
DataAccessObject.IsNULL <string>(reader["City"]),
DataAccessObject.IsNULL <int>(reader["MetroLocationID"]),
DataAccessObject.IsNULL <int>(reader["StastusID"]),
DataAccessObject.IsNULL <DateTime>(reader["CreatedDate"])
);
return(appointmnet);
}
catch (Exception ex)
{
return(null);
}
}
public bool UpdateAppointmnet(Appointmnet appointmnet)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateAppointmnet", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AppointmnetID", SqlDbType.Int).Value = appointmnet.AppointmnetID;
cmd.Parameters.Add("@ClientID", SqlDbType.Int).Value = appointmnet.ClientID;
cmd.Parameters.Add("@Date", SqlDbType.DateTime).Value = appointmnet.Date;
cmd.Parameters.Add("@Time", SqlDbType.NVarChar).Value = appointmnet.Time;
// cmd.Parameters.Add("@CreateBy", SqlDbType.NVarChar).Value = appointmnet.CreateBy;
// cmd.Parameters.Add("@City", SqlDbType.Int).Value = appointmnet.City;
cmd.Parameters.Add("@MetroLocationID", SqlDbType.Int).Value = appointmnet.MetroLocationID;
cmd.Parameters.Add("@StastusID", SqlDbType.Int).Value = appointmnet.StastusID;
// cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = appointmnet.CreatedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public Appointmnet GetAppointmnetFromReader(IDataReader reader)
{
try
{
Appointmnet appointmnet = new Appointmnet
(
DataAccessObject.IsNULL<int>(reader["AppointmnetID"]),
DataAccessObject.IsNULL<int>(reader["ClientID"]),
DataAccessObject.IsNULL<DateTime>(reader["Date"]),
DataAccessObject.IsNULL<string>(reader["Time"]),
DataAccessObject.IsNULL<string>(reader["CreateBy"].ToString()),
DataAccessObject.IsNULL<string>(reader["City"]),
DataAccessObject.IsNULL<int>(reader["MetroLocationID"]),
DataAccessObject.IsNULL<int>(reader["StastusID"]),
DataAccessObject.IsNULL<DateTime>(reader["CreatedDate"])
);
return appointmnet;
}
catch(Exception ex)
{
return null;
}
}
public static bool UpdateAppointmnet(Appointmnet appointmnet)
{
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
return(sqlAppointmnetProvider.UpdateAppointmnet(appointmnet));
}
public static int InsertAppointmnet(Appointmnet appointmnet)
{
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
return(sqlAppointmnetProvider.InsertAppointmnet(appointmnet));
}
public static Appointmnet GetMetroLocationByMetroLocationID(int MetroLocationID)
{
Appointmnet appointmnet = new Appointmnet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnet = sqlAppointmnetProvider.GetAppointmnetByMetroLocationID(MetroLocationID);
return appointmnet;
}
public static bool UpdateAppointmnet(Appointmnet appointmnet)
{
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
return sqlAppointmnetProvider.UpdateAppointmnet(appointmnet);
}
public static int InsertAppointmnet(Appointmnet appointmnet)
{
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
return sqlAppointmnetProvider.InsertAppointmnet(appointmnet);
}
public static Appointmnet GetStastusByStastusID(int StastusID)
{
Appointmnet appointmnet = new Appointmnet();
SqlAppointmnetProvider sqlAppointmnetProvider = new SqlAppointmnetProvider();
appointmnet = sqlAppointmnetProvider.GetAppointmnetByStastusID(StastusID);
return appointmnet;
}
