protected MasterDataModel.MasterDataTBBM GetGvValue(BootstrapGridView gv, int key = 0)
{
BootstrapTextBox txtName = gv.FindEditFormTemplateControl("txtName") as BootstrapTextBox;
BootstrapComboBox cmbRegion = gv.FindEditFormTemplateControl("cmbRegion") as BootstrapComboBox;
BootstrapMemo txtAddress = gv.FindEditFormTemplateControl("txtAddress") as BootstrapMemo;
BootstrapTextBox txtTelp = gv.FindEditFormTemplateControl("txtTelp") as BootstrapTextBox;
BootstrapTextBox txtEmail = gv.FindEditFormTemplateControl("txtEmail") as BootstrapTextBox;
MasterDataModel.MasterDataTBBM item = new MasterDataModel.MasterDataTBBM();
item.TBBM_ID_PK = key;
item.Region_ID_FK = Convert.ToByte(cmbRegion.Value);
item.Name = txtName.Text;
item.Address = txtAddress.Text;
item.Telp = txtTelp.Text;
item.Email = txtEmail.Text;
item.CreationBy = UserProfile.Username;
item.UpdateBy = UserProfile.Username;
return(item);
}
protected void OnItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e)
{
BootstrapComboBox editor = source as BootstrapComboBox;
int typeID = GetCurrentItemTypeID();
List <SubType> subTypes;
if (typeID > -1)
{
subTypes = ItemTypeFactory.GetItemSubTypes().Where(s => s.TypeID == typeID && (s.SubTypeDescription.Contains(e.Filter) ||
s.SubTypeName.Contains(e.Filter) ||
s.SubTypeID.ToString().Contains(e.Filter))).ToList();
}
else
{
subTypes = ItemTypeFactory.GetItemSubTypes().Where(s => s.SubTypeDescription.Contains(e.Filter) ||
s.SubTypeName.Contains(e.Filter) ||
s.SubTypeID.ToString().Contains(e.Filter)).ToList();
}
editor.DataSource = subTypes;
editor.DataBind();
}
protected void OnItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e)
{
if (e.Value == null)
{
return;
}
string id = e.Value.ToString();
BootstrapComboBox editor = source as BootstrapComboBox;
int typeID = GetCurrentItemTypeID();
List <SubType> subTypes;
if (typeID > -1)
{
subTypes = ItemTypeFactory.GetItemSubTypes().Where(s => s.TypeID == typeID && s.SubTypeID.ToString() == id).ToList();
}
else
{
subTypes = ItemTypeFactory.GetItemSubTypes().Where(s => s.TypeID == typeID).ToList();
}
editor.DataSource = subTypes;
editor.DataBind();
}
protected MasterDataModel.MasterDataDriver GetGvValue(BootstrapGridView gv, int key = 0)
{
BootstrapTextBox txtName = gv.FindEditFormTemplateControl("txtName") as BootstrapTextBox;
BootstrapComboBox cmbTransportir = gv.FindEditFormTemplateControl("cmbTransportir") as BootstrapComboBox;
BootstrapDateEdit deBirthday = gv.FindEditFormTemplateControl("deBirthday") as BootstrapDateEdit;
BootstrapMemo txtAddress = gv.FindEditFormTemplateControl("txtAddress") as BootstrapMemo;
BootstrapTextBox txtEmail = gv.FindEditFormTemplateControl("txtEmail") as BootstrapTextBox;
BootstrapTextBox txtPhone1 = gv.FindEditFormTemplateControl("txtPhone1") as BootstrapTextBox;
BootstrapTextBox txtPhone2 = gv.FindEditFormTemplateControl("txtPhone2") as BootstrapTextBox;
MasterDataModel.MasterDataDriver item = new MasterDataModel.MasterDataDriver();
item.Driver_ID = key;
item.Name = txtName.Text;
item.Transporter_ID = Convert.ToInt32(cmbTransportir.Value);
if (deBirthday.Value != null)
{
item.Birthday = deBirthday.Date;
}
else
{
item.Birthday = null;
}
item.Address = txtAddress.Text;
item.Email = txtEmail.Text;
item.Phone1 = txtPhone1.Text;
item.Phone2 = txtPhone2.Text;
item.CreationBy = UserProfile.Username;
item.UpdateBy = UserProfile.Username;
if (Session["DriverPhotoImageName"] != null && Session["DriverPhotoImageBytes"] != null)
{
item.ImageName = Convert.ToString(Session["DriverPhotoImageName"]);
item.ImageBytes = (byte[])Session["DriverPhotoImageBytes"];
Session["DriverPhotoImageName"] = null;
Session["DriverPhotoImageBytes"] = null;
}
return(item);
}
public void FilldataSource_DataBind_Dev(Control Ctrl, string Sqlstr, object LinQ, Boolean ActivePropertyGrid)
{
if (_Conexion.State == ConnectionState.Closed)
{
_Conexion.Open();
}
if (Sqlstr != "")
{
SqlDataAdapter MysqlAdapter = new SqlDataAdapter(Sqlstr, _Conexion);
DataSet Mydataset = new DataSet();
MysqlAdapter.Fill(Mydataset);
if (Ctrl is ASPxGridView)
{
ASPxGridView Ctrl1 = (ASPxGridView)Ctrl;
Ctrl1.DataSource = Mydataset.Tables[0];
}
if (Ctrl is ASPxGridLookup)
{
ASPxGridLookup Ctrl1 = (ASPxGridLookup)Ctrl;
Ctrl1.DataSource = Mydataset.Tables[0];
}
if (Ctrl is ASPxComboBox)
{
ASPxComboBox Ctrl1 = (ASPxComboBox)Ctrl;
Ctrl1.DataSource = Mydataset.Tables[0];
}
if (Ctrl is BootstrapComboBox)
{
BootstrapComboBox Ctrl1 = (BootstrapComboBox)Ctrl;
Ctrl1.DataSource = Mydataset.Tables[0];
}
}
else
{
if (Ctrl is ASPxGridView)
{
ASPxGridView Ctrl1 = (ASPxGridView)Ctrl;
Ctrl1.DataSource = LinQ;
}
if (Ctrl is ASPxGridLookup)
{
ASPxGridLookup Ctrl1 = (ASPxGridLookup)Ctrl;
Ctrl1.DataSource = LinQ;
}
if (Ctrl is ASPxComboBox)
{
ASPxComboBox Ctrl1 = (ASPxComboBox)Ctrl;
Ctrl1.DataSource = LinQ;
}
if (Ctrl is BootstrapComboBox)
{
BootstrapComboBox Ctrl1 = (BootstrapComboBox)Ctrl;
Ctrl1.DataSource = LinQ;
}
}
if (ActivePropertyGrid == false)
{
if (Ctrl is ASPxGridView)
{
ASPxGridView Ctrl1 = (ASPxGridView)Ctrl;
Ctrl1.DataBind();
}
if (Ctrl is ASPxGridLookup)
{
ASPxGridLookup Ctrl1 = (ASPxGridLookup)Ctrl;
Ctrl1.DataBind();
}
if (Ctrl is ASPxComboBox)
{
ASPxComboBox Ctrl1 = (ASPxComboBox)Ctrl;
Ctrl1.DataBind();
}
if (Ctrl is BootstrapComboBox)
{
BootstrapComboBox Ctrl1 = (BootstrapComboBox)Ctrl;
Ctrl1.DataBind();
}
}
_Conexion.Close();
}
