public static void InsertData(DataObject.SysBillMasterHozinal obj) { String Insert = "INSERT INTO SYS_BILL_MASTER_HOZINAL (BILL_MASTER_ID) VALUES "; Insert += " (@BILL_MASTER_ID)"; SqlConnection conn = Common.Connection.SqlConnect(); SqlCommand cmd = new SqlCommand(Insert); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@BILL_MASTER_ID", obj.BILL_MASTER_ID); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public static void UpdateData(DataObject.SysBillMasterHozinal obj) { SqlConnection conn = Common.Connection.SqlConnect(); String Update = "UPDATE SYS_BILL_MASTER_HOZINAL SET BILL_MASTER_ID = @BILL_MASTER_ID "; Update += " Where ID = @ID"; SqlCommand cmd = new SqlCommand(Update); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@BILL_MASTER_ID", obj.BILL_MASTER_ID); cmd.Parameters.AddWithValue("@ID", obj.ID); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public static int InsertDataReturnId(DataObject.SysBillMasterHozinal obj) { String Insert = "INSERT INTO SYS_BILL_MASTER_HOZINAL (BILL_MASTER_ID) VALUES "; Insert += " (@BILL_MASTER_ID)"; SqlConnection conn = Common.Connection.SqlConnect(); SqlCommand cmd = new SqlCommand(Insert); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@BILL_MASTER_ID", obj.BILL_MASTER_ID); cmd.ExecuteNonQuery(); cmd.CommandText = "SELECT scope_identity()"; conn.Open(); int identity = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(identity); }
public static List <DataObject.SysBillMasterHozinal> GetData(Int32 Id) { List <DataObject.SysBillMasterHozinal> lstSysBillMasterHozinal = new List <DataObject.SysBillMasterHozinal>(); String Select = ""; SqlCommand cmd = null; SqlConnection conn = Common.Connection.SqlConnect(); if (Id > 0) { Select = "Select * from SYS_BILL_MASTER_HOZINAL Where BILL_MASTER_ID = @ID"; cmd = new SqlCommand(Select); cmd.CommandType = CommandType.Text; cmd.Connection = conn; cmd.Parameters.AddWithValue("@ID", Id); } else { Select = "Select * from SYS_BILL_MASTER_HOZINAL"; cmd = new SqlCommand(Select); cmd.CommandType = CommandType.Text; cmd.Connection = conn; } conn.Open(); using (SqlDataReader oReader = cmd.ExecuteReader()) { while (oReader.Read()) { DataObject.SysBillMasterHozinal obj = new DataObject.SysBillMasterHozinal(); obj.ID = Int32.Parse(oReader["ID"].ToString()); obj.BILL_MASTER_ID = Int32.Parse(oReader["BILL_MASTER_ID"].ToString()); lstSysBillMasterHozinal.Add(obj); } } conn.Close(); return(lstSysBillMasterHozinal); }