public Branch[] GetBranches(string owner, string name)
{
var items = GetBranchesInternal(owner, name);
var results = new Data.Branch[items.Length];
for (var i = 0; i < items.Length; i++)
{
var protection = items[i].Protected ? GetBranchProtectionInternal(owner, name, items[i].Name) : null;
var status = GetBranchStatus(owner, name, items[i].Name);
results[i] = new Branch(string.Concat(owner, '/', name), items[i].Name)
{
Protection = new BranchProtection(items[i].Protected)
{
EnforceAdmins = protection?.EnforceAdmins?.Enabled,
RequireUpToDate = protection?.RequiredStatusChecks?.Strict,
RequireStatusChecks = protection?.RequiredStatusChecks?.Contexts?.ToArray(),
RequirePullRequestReviews = protection?.RequiredPullRequestReviews != null && protection?.RequiredPullRequestReviews?.RequiredApprovingReviewCount > 0,
DismissStaleReviews = protection?.RequiredPullRequestReviews?.DismissStaleReviews,
RequireCodeOwnerReviews = protection?.RequiredPullRequestReviews?.RequireCodeOwnerReviews,
RequiredApprovingReviewCount = protection?.RequiredPullRequestReviews?.RequiredApprovingReviewCount,
},
Status = status,
};
}
return(results);
}
public List<Branch> Branch_GetByTop(string Top, string Where, string Order)
{
List<Data.Branch> list = new List<Data.Branch>();
using (SqlCommand dbCmd = new SqlCommand("sp_Branch_GetByTop", GetConnection()))
{
Data.Branch obj = new Data.Branch();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@Top", Top));
dbCmd.Parameters.Add(new SqlParameter("@Where", Where));
dbCmd.Parameters.Add(new SqlParameter("@Order", Order));
SqlDataReader dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.BranchIDataReader(dr));
}
dr.Close();
//conn.Close();
}
else
{
dr.Close();
}
}
return list;
}
private void LoadOptions()
{
cboBranch.Items.Clear();
Data.Branch clsBranch = new Data.Branch();
foreach (System.Data.DataRow dr in clsBranch.ListAsDataTable(TerminalNo: TerminalDetails.TerminalNo).Rows)
{
cboBranch.Items.Add(dr["BranchCode"]);
}
Int32 iBranchCount = new Data.Terminal(clsBranch.Connection, clsBranch.Transaction).BranchCount(txtTerminalNo.Text);
clsBranch.CommitAndDispose();
if (iBranchCount == 0)
{
cboBranch.Items.Add("No Applicable Branch");
}
else if (iBranchCount != 0)
{
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(BranchDetails.BranchCode);
cboBranch.Enabled = false;
}
else
{
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(BranchDetails.BranchCode);
cboBranch.Enabled = true;
}
txtTerminalName.Text = TerminalDetails.TerminalName;
txtTerminalNo.Text = TerminalDetails.TerminalNo;
}
private void cmdOK_Click(object sender, EventArgs e)
{
Data.Branch clsBranch = new Data.Branch();
BranchDetails = clsBranch.Details(cboBranch.Text);
clsBranch.CommitAndDispose();
Result = System.Windows.Forms.DialogResult.OK;
this.Hide();
}
protected void cboBranch_SelectedIndexChanged(object sender, System.EventArgs e)
{
Data.Branch clsBranch = new Data.Branch();
Data.BranchDetails clsDetails = clsBranch.Details(Convert.ToInt16(cboBranch.SelectedItem.Value));
clsBranch.CommitAndDispose();
txtBranchAddress.Text = clsDetails.Address;
}
private void cmdOK_Click(object sender, EventArgs e)
{
Data.Branch clsBranch = new Data.Branch();
BranchDetails = clsBranch.Details(cboBranch.Text);
clsBranch.CommitAndDispose();
Result = System.Windows.Forms.DialogResult.OK;
this.Hide();
}
public Data.Node Serialize(IStorage storage, Reflect.Type type, object data, Uri.Locator locator)
{
Data.Branch result = new Data.Branch(data, type);
foreach (Reflect.Field field in data.GetFields())
{
Uri.Locator l = locator.Copy();
string name = field.Name.Convert(Casing.Camel, storage.Casing);
l.Fragment = (l.Fragment.NotEmpty() ? l.Fragment + "." : "") + name;
result.Nodes.Add(storage.Serialize(field.Type, field.Data, l).UpdateName(name));
}
return result;
}
private void LoadOptions()
{
cboBranch.Items.Clear();
Data.Branch clsBranch = new Data.Branch();
foreach (System.Data.DataRow dr in clsBranch.ListAsDataTable().Rows)
{
cboBranch.Items.Add(dr["BranchCode"]);
}
clsBranch.CommitAndDispose();
if (cboBranch.Items.Count == 0)
cboBranch.Items.Add("Please Reload");
else if (BranchDetails.BranchID != 0)
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(BranchDetails.BranchCode);
else
cboBranch.SelectedIndex = 0;
}
private void txtTerminalNo_TextChanged(object sender, EventArgs e)
{
try
{
Int32 iTerminalNo = Int32.Parse(txtTerminalNo.Text);
if (iTerminalNo > 0)
{
Data.Terminal clsTerminal = new Data.Terminal();
TerminalDetails = clsTerminal.Details(txtTerminalNo.Text);
BranchDetails = TerminalDetails.BranchDetails;
Int32 iBranchCount = clsTerminal.BranchCount(txtTerminalNo.Text);
cboBranch.Items.Clear();
Data.Branch clsBranch = new Data.Branch(clsTerminal.Connection, clsTerminal.Transaction);
foreach (System.Data.DataRow dr in clsBranch.ListAsDataTable(TerminalNo: txtTerminalNo.Text).Rows)
{
cboBranch.Items.Add(dr["BranchCode"]);
}
clsTerminal.CommitAndDispose();
if (iBranchCount == 0)
{
cboBranch.Items.Add("No Applicable Branch");
}
else if (iBranchCount == 1)
{
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(BranchDetails.BranchCode);
cboBranch.Enabled = false;
}
else
{
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(BranchDetails.BranchCode);
cboBranch.Enabled = true;
}
txtTerminalName.Text = TerminalDetails.TerminalName;
}
}
catch { }
}
private void txtTerminalNo_TextChanged(object sender, EventArgs e)
{
try
{
Int32 iTerminalNo = Int32.Parse(txtTerminalNo.Text);
if (iTerminalNo > 0)
{
Data.Terminal clsTerminal = new Data.Terminal();
TerminalDetails = clsTerminal.Details(txtTerminalNo.Text);
BranchDetails = TerminalDetails.BranchDetails;
Int32 iBranchCount = clsTerminal.BranchCount(txtTerminalNo.Text);
cboBranch.Items.Clear();
Data.Branch clsBranch = new Data.Branch(clsTerminal.Connection, clsTerminal.Transaction);
foreach (System.Data.DataRow dr in clsBranch.ListAsDataTable(TerminalNo: txtTerminalNo.Text).Rows)
{
cboBranch.Items.Add(dr["BranchCode"]);
}
clsTerminal.CommitAndDispose();
if (iBranchCount == 0)
cboBranch.Items.Add("No Applicable Branch");
else if (iBranchCount == 1)
{
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(BranchDetails.BranchCode);
cboBranch.Enabled = false;
}
else
{
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(BranchDetails.BranchCode);
cboBranch.Enabled = true;
}
txtTerminalName.Text = TerminalDetails.TerminalName;
}
}
catch { }
}
private void LoadOptions()
{
cboBranch.Items.Clear();
Data.Branch clsBranch = new Data.Branch();
foreach (System.Data.DataRow dr in clsBranch.ListAsDataTable().Rows)
{
cboBranch.Items.Add(dr["BranchCode"]);
}
clsBranch.CommitAndDispose();
if (cboBranch.Items.Count == 0)
{
cboBranch.Items.Add("Please Reload");
}
else if (BranchDetails.BranchID != 0)
{
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(BranchDetails.BranchCode);
}
else
{
cboBranch.SelectedIndex = 0;
}
}
public List<Branch> Branch_GetByAll()
{
List<Data.Branch> list = new List<Data.Branch>();
using (SqlCommand dbCmd = new SqlCommand("sp_Branch_GetByAll", GetConnection()))
{
Data.Branch obj = new Data.Branch();
dbCmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.BranchIDataReader(dr));
}
dr.Close();
//conn.Close();
}
else
{
dr.Close();
}
}
return list;
}
public Branch BranchIDataReader(IDataReader dr)
{
Data.Branch obj = new Data.Branch();
obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString();
protected void cboBranch_SelectedIndexChanged(object sender, System.EventArgs e)
{
Data.Branch clsBranch = new Data.Branch();
Data.BranchDetails clsDetails = clsBranch.Details(Convert.ToInt16(cboBranch.SelectedItem.Value));
clsBranch.CommitAndDispose();
txtBranchAddress.Text = clsDetails.Address;
}
private void LoadOptions()
{
cboBranch.Items.Clear();
Data.Branch clsBranch = new Data.Branch();
foreach (System.Data.DataRow dr in clsBranch.ListAsDataTable(TerminalNo: TerminalDetails.TerminalNo).Rows)
{
cboBranch.Items.Add(dr["BranchCode"]);
}
Int32 iBranchCount = new Data.Terminal(clsBranch.Connection, clsBranch.Transaction).BranchCount(txtTerminalNo.Text);
clsBranch.CommitAndDispose();
if (iBranchCount == 0)
{
cboBranch.Items.Add("No Applicable Branch");
}
else if (iBranchCount != 0)
{
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(BranchDetails.BranchCode);
cboBranch.Enabled = false;
}
else
{
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(BranchDetails.BranchCode);
cboBranch.Enabled = true;
}
txtTerminalName.Text = TerminalDetails.TerminalName;
txtTerminalNo.Text = TerminalDetails.TerminalNo;
}
public Data.Node Serialize(IStorage storage, Reflect.Type type, object data, Uri.Locator resource)
{
Data.Node result;
Uri.Locator l = storage.Resolver.Update(data, resource);
if (l.NotNull())
result = new Data.Link(l);
else
{
result = new Data.Branch(data, type);
foreach (Reflect.Property property in data.GetProperties())
{
ParameterAttribute[] attributes = property.GetAttributes<ParameterAttribute>();
if (attributes.Length == 1 && property.Data.NotNull())
{
string name = attributes[0].Name ?? property.Name.Convert(Casing.Pascal, storage.Casing);
if (resource.NotNull())
{
l = resource.Copy();
l.Fragment = (l.Fragment.NotEmpty() ? l.Fragment + "/" : "") + name;
}
(result as Data.Branch).Nodes.Add(storage.Serialize(property.Type, property.Data, l).UpdateName(name).UpdateAttribute(attributes[0]).UpdateLocator(resource));
}
}
}
return result;
}
protected void Update_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Data.Branch obj = new Data.Branch();
obj.Id = Id;
obj.Name = txtName.Text;
obj.Ord = txtOrd.Text != "" ? txtOrd.Text : "1";
obj.Logo = txtLogo.Text;
if (Insert == true)
{
BranchService.Branch_Insert(obj);
}
else
{
BranchService.Branch_Update(obj);
}
BindGrid();
pnView.Visible = true;
pnUpdate.Visible = false;
Insert = false;
}
}
public List<Branch> Branch_Paging(string CurentPage, string PageSize)
{
List<Data.Branch> list = new List<Data.Branch>();
using (SqlCommand dbCmd = new SqlCommand("sp_Branch_Paging", GetConnection()))
{
Data.Branch obj = new Data.Branch();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@CurentPage", CurentPage));
dbCmd.Parameters.Add(new SqlParameter("@PageSize", PageSize));
SqlDataReader dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.BranchIDataReader(dr));
}
dr.Close();
//conn.Close();
}
else
{
dr.Close();
}
}
return list;
}
