public static int DeleteDesa(DesaClass ds) { SqlConnection con = new SqlConnection(cs); //SqlCommand cmd = new SqlCommand("delete from Desa where DesaID='" + ds.desaid + "'", con); SqlCommand cmd = new SqlCommand("update Desa set deleted=1,UpdatedDate=@UpdatedDate,UpdatedBy=@UpdatedBy where DesaID=@desaid", con); if (con.State.Equals(ConnectionState.Closed)) { con.Open(); } cmd.Parameters.AddWithValue("@desaid", ds.desaid); cmd.Parameters.AddWithValue("@UpdatedDate", DateTime.Now); cmd.Parameters.AddWithValue("@UpdatedBy", ds.UpdatedBy); int i = cmd.ExecuteNonQuery(); con.Close(); return(i); }
public static IEnumerable <DesaClass> getDesaList() { SqlConnection con = new SqlConnection(cs); SqlCommand cmd = new SqlCommand("Select * from Desa where deleted=0 order by cast(replace(desaid,'DS','') as int)", con); if (con.State.Equals(ConnectionState.Closed)) { con.Open(); } List <DesaClass> newdesa = new List <DesaClass>(); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { DesaClass ds = new DesaClass(rd.GetString(0), rd.GetString(1), rd.GetString(2), rd.GetString(3)); newdesa.Add(ds); } return(newdesa); }
public static int UpdateDesa(DesaClass ds) { SqlConnection con = new SqlConnection(cs); SqlCommand cmd = new SqlCommand("update Desa set NamaDesa=@namadesa,mesjidDesa=@mesjiddesa, alamat=@alamat,UpdatedDate=@UpdatedDate,UpdatedBy=@UpdatedBy where DesaID=@desaid and deleted=0", con); if (con.State.Equals(ConnectionState.Closed)) { con.Open(); } cmd.Parameters.AddWithValue("@desaid", ds.desaid); cmd.Parameters.AddWithValue("@namadesa", ds.namadesa); cmd.Parameters.AddWithValue("@mesjiddesa", ds.mesjiddesa); cmd.Parameters.AddWithValue("@alamat", ds.alamat); cmd.Parameters.AddWithValue("@UpdatedDate", DateTime.Now); cmd.Parameters.AddWithValue("@UpdatedBy", ds.UpdatedBy); int i = cmd.ExecuteNonQuery(); con.Close(); return(i); }
public static int InsertDesa(DesaClass ds) { SqlConnection con = new SqlConnection(cs); SqlCommand cmd = new SqlCommand("insert into Desa (DesaID,NamaDesa,MesjidDesa,Alamat,CreatedDate,CreatedBy,UpdatedDate, UpdatedBy) values(@desaid,@namadesa,@mesjiddesa ,@alamat,@CreatedDate,@CreatedBy,@UpdatedDate, @UpdatedBy)", con); if (con.State.Equals(ConnectionState.Closed)) { con.Open(); } cmd.Parameters.AddWithValue("@desaid", ds.desaid); cmd.Parameters.AddWithValue("@namadesa", ds.namadesa); cmd.Parameters.AddWithValue("@mesjiddesa", ds.mesjiddesa); cmd.Parameters.AddWithValue("@alamat", ds.alamat); cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now); cmd.Parameters.AddWithValue("@CreatedBy", ds.CreatedBy); cmd.Parameters.AddWithValue("@UpdatedDate", DateTime.Now); cmd.Parameters.AddWithValue("@UpdatedBy", ds.UpdatedBy); int i = cmd.ExecuteNonQuery(); con.Close(); return(i); }
public static int UpdateDesa(DesaClass ds) { return(DesaModel.UpdateDesa(ds)); }
public static int InsertDesa(DesaClass ds) { return(DesaModel.InsertDesa(ds)); }
public static int DeleteDesa(DesaClass ds) { return(DesaModel.DeleteDesa(ds)); }