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; }